# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.011 | 4,702.620 | ↑ 1.0 | 20 | 1 |
→
Limit (cost=358,845.43..358,845.48 rows=20 width=16) (actual time=4,702.607..4,702.620 rows=20 loops=1)
|
2. | 0.117 | 4,702.609 | ↑ 10.9 | 20 | 1 |
→
Sort (cost=358,845.43..358,845.98 rows=218 width=16) (actual time=4,702.605..4,702.609 rows=20 loops=1)
|
3. | 1,098.463 | 4,702.492 | ↑ 1.8 | 122 | 1 |
→
GroupAggregate (cost=314,433.48..358,839.63 rows=218 width=16) (actual time=1,533.753..4,702.492 rows=122 loops=1)
|
4. | 717.920 | 3,602.931 | ↓ 1.0 | 1,599,469 | 1 |
→
Merge Join (cost=314,433.48..341,824.39 rows=1,544,575 width=16) (actual time=1,525.738..3,602.931 rows=1,599,469 loops=1)
|
5. | 1.465 | 1.465 | ↑ 1.0 | 5,492 | 1 |
→
Index Only Scan using forms_pkey on forms (cost=0.28..355.43 rows=5,635 width=4) (actual time=0.009..1.465 rows=5,492 loops=1)
|
6. | 746.885 | 2,883.546 | ↓ 1.0 | 1,599,469 | 1 |
→
Materialize (cost=314,432.02..322,154.89 rows=1,544,575 width=16) (actual time=1,525.488..2,883.546 rows=1,599,469 loops=1)
|
7. | 1,382.879 | 2,136.661 | ↓ 1.0 | 1,599,469 | 1 |
→
Sort (cost=314,432.02..318,293.45 rows=1,544,575 width=16) (actual time=1,525.485..2,136.661 rows=1,599,469 loops=1)
|
8. | 753.782 | 753.782 | ↓ 1.0 | 1,599,469 | 1 |
→
Index Only Scan using form_responses_form_id_mailing_id_covering_index on form_responses (cost=0.56..129,262.14 rows=1,544,575 width=16) (actual time=0.020..753.782 rows=1,599,469 loops=1)
|
9. |
SubPlan (for GroupAggregate) |
|||||
10. | 0.610 | 0.610 | ↑ 1.0 | 1 | 122 |
→
Index Scan using forms_pkey on forms forms_1 (cost=0.28..8.30 rows=1 width=26) (actual time=0.005..0.005 rows=1 loops=122)
|
11. | 0.244 | 0.244 | ↑ 1.0 | 1 | 122 |
→
Index Scan using forms_pkey on forms forms_2 (cost=0.28..8.30 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=122)
|
12. | 0.244 | 0.244 | ↑ 1.0 | 1 | 122 |
→
Index Scan using forms_pkey on forms forms_3 (cost=0.28..8.30 rows=1 width=18) (actual time=0.001..0.002 rows=1 loops=122)
|
Planning time | : | 0.489 ms |
---|