query-plan-1197

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
106.617 100.00% 
 Limit (cost=4771.08..4771.33 rows=100 width=32) (actual time=106.593..106.617 rows=100 loops=1)
106.600 99.98% 
  -> Sort (cost=4771.08..4773.0 rows=765 width=32) (actual time=106.591..106.600 rows=100 loops=1)
        Sort Key: cs.chart_id, cs.id, dateresponse.value
        Sort Method:  top-N heapsort  Memory: 32kB
93.433 87.63% 
        -> Nested Loop (cost=1012.35..4741.85 rows=765 width=32) (actual time=2.748..93.433 rows=27702 loops=1)
16.818 15.77% 
              -> Hash Join (cost=1012.35..1227.97 rows=402 width=32) (actual time=2.726..16.818 rows=9234 loops=1)
                    Hash Cond: (nullbooleanresponse.submission_id = cs.id)
2.140 2.01% 
                    -> Seq Scan on canvas_nullbooleanresponse nullbooleanresponse (cost=0.0..142.34 rows=9234 width=4) (actual time=0.008..2.140 rows=9234 loops=1)
2.699 2.53% 
                    -> Hash (cost=955.16..955.16 rows=4575 width=28) (actual time=2.699..2.699 rows=4617 loops=1)
1.488 1.40% 
                          -> Bitmap Heap Scan on canvas_submission cs (cost=91.98..955.16 rows=4575 width=28) (actual time=0.634..1.488 rows=4617 loops=1)
                                Recheck Cond: (chart_id = ANY ('{3,18}'::integer[]))
0.610 0.57% 
                                -> Bitmap Index Scan on canvas_submission_chart_id (cost=0.0..90.83 rows=4575 width=0) (actual time=0.610..0.610 rows=4617 loops=1)
                                      Index Cond: (chart_id = ANY ('{3,18}'::integer[]))
64.638 60.63% 
              -> Index Scan using canvas_dateresponse_submission_id on canvas_dateresponse dateresponse (cost=0.0..8.72 rows=2 width=8) (actual time=0.004..0.007 rows=3 loops=9234)
                    Index Cond: (dateresponse.submission_id = cs.id)
Run-time
0.106723 seconds (106.723 ms)