# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.006 | 10.177 | ↓ 4.5 | 9 | 1 |
→
Limit (cost=99.36..99.37 rows=2 width=27) (actual time=10.171..10.177 rows=9 loops=1)
|
2. | 0.075 | 10.171 | ↓ 4.5 | 9 | 1 |
→
Sort (cost=99.36..99.37 rows=2 width=27) (actual time=10.169..10.171 rows=9 loops=1)
|
3. | 4.793 | 10.096 | ↓ 4.5 | 9 | 1 |
→
GroupAggregate (cost=48.42..99.35 rows=2 width=27) (actual time=5.436..10.096 rows=9 loops=1)
|
4. | 1.892 | 5.240 | ↓ 1,810.0 | 3,620 | 1 |
→
Sort (cost=48.42..48.43 rows=2 width=27) (actual time=4.561..5.240 rows=3,620 loops=1)
|
5. | 1.363 | 3.348 | ↓ 1,810.0 | 3,620 | 1 |
→
Nested Loop (cost=5.05..48.41 rows=2 width=27) (actual time=0.047..3.348 rows=3,620 loops=1)
|
6. | 0.035 | 0.050 | ↓ 9.0 | 9 | 1 |
→
Bitmap Heap Scan on mailings (cost=4.49..39.15 rows=1 width=4) (actual time=0.027..0.050 rows=9 loops=1)
|
7. | 0.015 | 0.015 | ↑ 1.0 | 9 | 1 |
→
Bitmap Index Scan on mailings_mailing_group_id_index (cost=0.00..4.49 rows=9 width=0) (actual time=0.015..0.015 rows=9 loops=1)
|
8. | 1.935 | 1.935 | ↓ 19.1 | 402 | 9 |
→
Index Only Scan using form_responses_form_id_mailing_id_covering_index on form_responses (cost=0.56..9.05 rows=21 width=27) (actual time=0.007..0.215 rows=402 loops=9)
|
9. |
SubPlan (for GroupAggregate) |
|||||
10. | 0.036 | 0.036 | ↑ 1.0 | 1 | 9 |
→
Index Scan using mailings_pkey on mailings mailings_1 (cost=0.42..8.44 rows=1 width=33) (actual time=0.004..0.004 rows=1 loops=9)
|
11. | 0.018 | 0.018 | ↑ 1.0 | 1 | 9 |
→
Index Scan using mailings_pkey on mailings mailings_2 (cost=0.42..8.44 rows=1 width=18) (actual time=0.001..0.002 rows=1 loops=9)
|
12. | 0.009 | 0.009 | ↑ 1.0 | 1 | 9 |
→
Index Scan using mailings_pkey on mailings mailings_3 (cost=0.42..8.44 rows=1 width=9) (actual time=0.001..0.001 rows=1 loops=9)
|
Planning time | : | 0.908 ms |
---|