query-plan-1198

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
102.985 100.00% 
 Limit (cost=6042.9..6043.15 rows=100 width=32) (actual time=102.961..102.985 rows=100 loops=1)
102.968 99.98% 
  -> Sort (cost=6042.9..6064.66 rows=8705 width=32) (actual time=102.959..102.968 rows=100 loops=1)
        Sort Key: cs.chart_id, cs.id, dateresponse.value
        Sort Method:  top-N heapsort  Memory: 32kB
97.689 94.86% 
        -> Hash Join (cost=1012.35..5710.2 rows=8705 width=32) (actual time=2.761..97.689 rows=13851 loops=1)
              Hash Cond: (dateresponse.submission_id = cs.id)
27.070 26.29% 
              -> Seq Scan on canvas_dateresponse dateresponse (cost=0.0..3111.74 rows=199874 width=8) (actual time=0.009..27.070 rows=199874 loops=1)
2.735 2.66% 
              -> Hash (cost=955.16..955.16 rows=4575 width=28) (actual time=2.735..2.735 rows=4617 loops=1)
1.478 1.44% 
                    -> Bitmap Heap Scan on canvas_submission cs (cost=91.98..955.16 rows=4575 width=28) (actual time=0.627..1.478 rows=4617 loops=1)
                          Recheck Cond: (chart_id = ANY ('{3,18}'::integer[]))
0.603 0.59% 
                          -> Bitmap Index Scan on canvas_submission_chart_id (cost=0.0..90.83 rows=4575 width=0) (actual time=0.603..0.603 rows=4617 loops=1)
                                Index Cond: (chart_id = ANY ('{3,18}'::integer[]))
Run-time
0.103080 seconds (103.080 ms)