Enumerated CT 2

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
8648.662 100.00% 
 Hash Join (cost=143014.64..166165.25 rows=2 width=311) (actual time=8624.243..8648.662 rows=4609 loops=1)
  Hash Cond: (r.submission_id = r.submission_id)
2908.372 33.63% 
  -> HashAggregate (cost=43562.05..65449.57 rows=91198 width=22) (actual time=2898.427..2908.372 rows=4609 loops=1)
313.653 3.63% 
        -> Hash Join (cost=16.87..17478.49 rows=434726 width=22) (actual time=0.475..313.653 rows=106007 loops=1)
              Hash Cond: (r.question_id = cvq.id)
110.027 1.27% 
              -> Seq Scan on canvas_integerresponse r (cost=0.0..10547.08 rows=684608 width=12) (actual time=0.020..110.027 rows=682267 loops=1)
0.424 0.00% 
              -> Hash (cost=15.28..15.28 rows=127 width=18) (actual time=0.424..0.424 rows=158 loops=1)
0.345 0.00% 
                    -> Hash Join (cost=8.04..15.28 rows=127 width=18) (actual time=0.164..0.345 rows=158 loops=1)
                          Hash Cond: (cvq.question_id = q.id)
0.091 0.00% 
                          -> Seq Scan on canvas_chartversionquestion cvq (cost=0.0..5.5 rows=127 width=12) (actual time=0.021..0.091 rows=158 loops=1)
                                Filter: (chart_id = ANY ('{3,18}'::integer[]))
0.122 0.00% 
                          -> Hash (cost=6.35..6.35 rows=135 width=14) (actual time=0.122..0.122 rows=135 loops=1)
0.061 0.00% 
                                -> Seq Scan on canvas_question q (cost=0.0..6.35 rows=135 width=14) (actual time=0.010..0.061 rows=135 loops=1)
5725.771 66.20% 
  -> Hash (cost=99452.56..99452.56 rows=2 width=243) (actual time=5725.771..5725.771 rows=4609 loops=1)
5714.930 66.08% 
        -> Hash Join (cost=76027.65..99452.56 rows=2 width=243) (actual time=5689.827..5714.930 rows=4609 loops=1)
              Hash Cond: (r.submission_id = r.submission_id)
4073.075 47.09% 
              -> HashAggregate (cost=34964.07..57317.56 rows=77081 width=22) (actual time=4060.235..4073.075 rows=4609 loops=1)
263.322 3.04% 
                    -> Hash Join (cost=16.87..12686.34 rows=307279 width=22) (actual time=0.445..263.322 rows=129052 loops=1)
                          Hash Cond: (r.question_id = cvq.id)
79.487 0.92% 
                          -> Seq Scan on canvas_foreignkeyresponse r (cost=0.0..7782.04 rows=483904 width=12) (actual time=0.007..79.487 rows=471444 loops=1)
0.422 0.00% 
                          -> Hash (cost=15.28..15.28 rows=127 width=18) (actual time=0.422..0.422 rows=158 loops=1)
0.343 0.00% 
                                -> Hash Join (cost=8.04..15.28 rows=127 width=18) (actual time=0.160..0.343 rows=158 loops=1)
                                      Hash Cond: (cvq.question_id = q.id)
0.087 0.00% 
                                      -> Seq Scan on canvas_chartversionquestion cvq (cost=0.0..5.5 rows=127 width=12) (actual time=0.015..0.087 rows=158 loops=1)
                                            Filter: (chart_id = ANY ('{3,18}'::integer[]))
0.121 0.00% 
                                      -> Hash (cost=6.35..6.35 rows=135 width=14) (actual time=0.121..0.121 rows=135 loops=1)
0.059 0.00% 
                                            -> Seq Scan on canvas_question q (cost=0.0..6.35 rows=135 width=14) (actual time=0.009..0.059 rows=135 loops=1)
1629.547 18.84% 
              -> Hash (cost=41063.54..41063.54 rows=3 width=127) (actual time=1629.547..1629.547 rows=4609 loops=1)
1622.552 18.76% 
                    -> Hash Join (cost=29744.92..41063.54 rows=3 width=127) (actual time=1604.219..1622.552 rows=4609 loops=1)
                          Hash Cond: (r.submission_id = r.submission_id)
1065.432 12.32% 
                          -> HashAggregate (cost=7569.44..17921.84 rows=69016 width=19) (actual time=1056.684..1065.432 rows=4609 loops=1)
98.401 1.14% 
                                -> Hash Join (cost=16.87..3922.9 rows=97241 width=19) (actual time=0.473..98.401 rows=64526 loops=1)
                                      Hash Cond: (r.question_id = cvq.id)
27.127 0.31% 
                                      -> Seq Scan on canvas_booleanresponse r (cost=0.0..2359.36 rows=153136 width=9) (actual time=0.007..27.127 rows=150124 loops=1)
0.442 0.01% 
                                      -> Hash (cost=15.28..15.28 rows=127 width=18) (actual time=0.442..0.442 rows=158 loops=1)
0.339 0.00% 
                                            -> Hash Join (cost=8.04..15.28 rows=127 width=18) (actual time=0.151..0.339 rows=158 loops=1)
                                                  Hash Cond: (cvq.question_id = q.id)
0.086 0.00% 
                                                  -> Seq Scan on canvas_chartversionquestion cvq (cost=0.0..5.5 rows=127 width=12) (actual time=0.014..0.086 rows=158 loops=1)
                                                        Filter: (chart_id = ANY ('{3,18}'::integer[]))
0.119 0.00% 
                                                  -> Hash (cost=6.35..6.35 rows=135 width=14) (actual time=0.119..0.119 rows=135 loops=1)
0.055 0.00% 
                                                        -> Seq Scan on canvas_question q (cost=0.0..6.35 rows=135 width=14) (actual time=0.009..0.055 rows=135 loops=1)
547.490 6.33% 
                          -> Hash (cost=22175.42..22175.42 rows=5 width=109) (actual time=547.490..547.490 rows=4609 loops=1)
542.979 6.28% 
                                -> Hash Join (cost=16564.46..22175.42 rows=5 width=109) (actual time=531.869..542.979 rows=4609 loops=1)
                                      Hash Cond: (r.submission_id = cs.id)
126.188 1.46% 
                                      -> HashAggregate (cost=6574.48..10750.04 rows=104389 width=22) (actual time=122.766..126.188 rows=4609 loops=1)
73.301 0.85% 
                                            -> Hash Join (cost=16.87..5267.36 rows=130712 width=22) (actual time=0.443..73.301 rows=13827 loops=1)
                                                  Hash Cond: (r.question_id = cvq.id)
27.305 0.32% 
                                                  -> Seq Scan on canvas_dateresponse r (cost=0.0..3171.45 rows=205845 width=12) (actual time=0.007..27.305 rows=199850 loops=1)
0.417 0.00% 
                                                  -> Hash (cost=15.28..15.28 rows=127 width=18) (actual time=0.417..0.417 rows=158 loops=1)
0.334 0.00% 
                                                        -> Hash Join (cost=8.04..15.28 rows=127 width=18) (actual time=0.147..0.334 rows=158 loops=1)
                                                              Hash Cond: (cvq.question_id = q.id)
0.100 0.00% 
                                                              -> Seq Scan on canvas_chartversionquestion cvq (cost=0.0..5.5 rows=127 width=12) (actual time=0.015..0.100 rows=158 loops=1)
                                                                    Filter: (chart_id = ANY ('{3,18}'::integer[]))
0.116 0.00% 
                                                              -> Hash (cost=6.35..6.35 rows=135 width=14) (actual time=0.116..0.116 rows=135 loops=1)
0.060 0.00% 
                                                                    -> Seq Scan on canvas_question q (cost=0.0..6.35 rows=135 width=14) (actual time=0.010..0.060 rows=135 loops=1)
409.033 4.73% 
                                      -> Hash (cost=9989.92..9989.92 rows=5 width=93) (actual time=409.033..409.033 rows=4609 loops=1)
405.580 4.69% 
                                            -> Hash Join (cost=6858.68..9989.92 rows=5 width=93) (actual time=395.817..405.580 rows=4609 loops=1)
                                                  Hash Cond: (r.submission_id = cs.id)
72.982 0.84% 
                                                  -> HashAggregate (cost=3639.09..5786.19 rows=71570 width=34) (actual time=69.035..72.982 rows=4609 loops=1)
44.187 0.51% 
                                                        -> Hash Join (cost=16.87..3102.32 rows=71570 width=34) (actual time=0.454..44.187 rows=9218 loops=1)
                                                              Hash Cond: (r.question_id = cvq.id)
17.537 0.20% 
                                                              -> Seq Scan on canvas_textresponse r (cost=0.0..1947.09 rows=112709 width=24) (actual time=0.016..17.537 rows=109643 loops=1)
0.403 0.00% 
                                                              -> Hash (cost=15.28..15.28 rows=127 width=18) (actual time=0.403..0.403 rows=158 loops=1)
0.334 0.00% 
                                                                    -> Hash Join (cost=8.04..15.28 rows=127 width=18) (actual time=0.174..0.334 rows=158 loops=1)
                                                                          Hash Cond: (cvq.question_id = q.id)
0.078 0.00% 
                                                                          -> Seq Scan on canvas_chartversionquestion cvq (cost=0.0..5.5 rows=127 width=12) (actual time=0.016..0.078 rows=158 loops=1)
                                                                                Filter: (chart_id = ANY ('{3,18}'::integer[]))
0.141 0.00% 
                                                                          -> Hash (cost=6.35..6.35 rows=135 width=14) (actual time=0.141..0.141 rows=135 loops=1)
0.060 0.00% 
                                                                                -> Seq Scan on canvas_question q (cost=0.0..6.35 rows=135 width=14) (actual time=0.009..0.060 rows=135 loops=1)
326.758 3.78% 
                                                  -> Hash (cost=3219.49..3219.49 rows=8 width=25) (actual time=326.758..326.758 rows=4609 loops=1)
324.081 3.75% 
                                                        -> Hash Join (cost=2787.31..3219.49 rows=8 width=25) (actual time=316.349..324.081 rows=4609 loops=1)
                                                              Hash Cond: (r.submission_id = cs.id)
277.211 3.21% 
                                                              -> HashAggregate (cost=1250.04..1618.76 rows=4609 width=19) (actual time=273.594..277.211 rows=4609 loops=1)
32.971 0.38% 
                                                                    -> Hash Join (cost=16.87..840.32 rows=20486 width=19) (actual time=0.422..32.971 rows=32263 loops=1)
                                                                          Hash Cond: (r.question_id = cvq.id)
5.606 0.06% 
                                                                          -> Seq Scan on canvas_nullresponse r (cost=0.0..497.61 rows=32261 width=9) (actual time=0.008..5.606 rows=32263 loops=1)
0.398 0.00% 
                                                                          -> Hash (cost=15.28..15.28 rows=127 width=18) (actual time=0.398..0.398 rows=158 loops=1)
0.320 0.00% 
                                                                                -> Hash Join (cost=8.04..15.28 rows=127 width=18) (actual time=0.147..0.320 rows=158 loops=1)
                                                                                      Hash Cond: (cvq.question_id = q.id)
0.086 0.00% 
                                                                                      -> Seq Scan on canvas_chartversionquestion cvq (cost=0.0..5.5 rows=127 width=12) (actual time=0.014..0.086 rows=158 loops=1)
                                                                                            Filter: (chart_id = ANY ('{3,18}'::integer[]))
0.115 0.00% 
                                                                                      -> Hash (cost=6.35..6.35 rows=135 width=14) (actual time=0.115..0.115 rows=135 loops=1)
0.057 0.00% 
                                                                                            -> Seq Scan on canvas_question q (cost=0.0..6.35 rows=135 width=14) (actual time=0.008..0.057 rows=135 loops=1)
42.711 0.49% 
                                                              -> Hash (cost=1534.82..1534.82 rows=196 width=14) (actual time=42.711..42.711 rows=4609 loops=1)
40.741 0.47% 
                                                                    -> Hash Join (cost=1310.12..1534.82 rows=196 width=14) (actual time=34.938..40.741 rows=4609 loops=1)
                                                                          Hash Cond: (r.submission_id = cs.id)
33.492 0.39% 
                                                                          -> HashAggregate (cost=294.04..431.11 rows=4569 width=19) (actual time=31.279..33.492 rows=4609 loops=1)
8.812 0.10% 
                                                                                -> Hash Join (cost=16.87..250.53 rows=5802 width=19) (actual time=0.418..8.812 rows=9218 loops=1)
                                                                                      Hash Cond: (r.question_id = cvq.id)
1.500 0.02% 
                                                                                      -> Seq Scan on canvas_nullbooleanresponse r (cost=0.0..141.37 rows=9137 width=9) (actual time=0.007..1.500 rows=9218 loops=1)
0.390 0.00% 
                                                                                      -> Hash (cost=15.28..15.28 rows=127 width=18) (actual time=0.390..0.390 rows=158 loops=1)
0.317 0.00% 
                                                                                            -> Hash Join (cost=8.04..15.28 rows=127 width=18) (actual time=0.163..0.317 rows=158 loops=1)
                                                                                                  Hash Cond: (cvq.question_id = q.id)
0.079 0.00% 
                                                                                                  -> Seq Scan on canvas_chartversionquestion cvq (cost=0.0..5.5 rows=127 width=12) (actual time=0.019..0.079 rows=158 loops=1)
                                                                                                        Filter: (chart_id = ANY ('{3,18}'::integer[]))
0.126 0.00% 
                                                                                                  -> Hash (cost=6.35..6.35 rows=135 width=14) (actual time=0.126..0.126 rows=135 loops=1)
0.062 0.00% 
                                                                                                        -> Seq Scan on canvas_question q (cost=0.0..6.35 rows=135 width=14) (actual time=0.010..0.062 rows=135 loops=1)
3.624 0.04% 
                                                                          -> Hash (cost=957.47..957.47 rows=4689 width=8) (actual time=3.624..3.624 rows=4609 loops=1)
2.086 0.02% 
                                                                                -> Bitmap Heap Scan on canvas_submission cs (cost=92.86..957.47 rows=4689 width=8) (actual time=0.753..2.086 rows=4609 loops=1)
                                                                                      Recheck Cond: (chart_id = ANY ('{3,18}'::integer[]))
0.724 0.01% 
                                                                                      -> Bitmap Index Scan on canvas_submission_questionnaire_id (cost=0.0..91.69 rows=4689 width=0) (actual time=0.724..0.724 rows=4721 loops=1)
                                                                                            Index Cond: (chart_id = ANY ('{3,18}'::integer[]))
Run-time
8.656707 seconds (8656.707 ms)