# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 3,263.904 | ↓ 0.0 | 141 | 1 |
→
Custom Scan (Citus Router) (cost=0.00..0.00 rows=0 width=0) (actual time=3,263.899..3,263.904 rows=141 loops=1)
|
2. | 0.000 | 3,354.868 | ↑ 12.7 | 141 | 1 |
→
Finalize GroupAggregate (cost=29,837.22..30,076.29 rows=1,792 width=16) (actual time=3,222.767..3,354.868 rows=141 loops=1)
|
3. | 0.000 | 3,356.815 | ↑ 4.1 | 416 | 1 |
→
Gather Merge (cost=29,837.22..30,049.81 rows=1,712 width=16) (actual time=3,212.791..3,356.815 rows=416 loops=1)
|
4. | 80.805 | 9,703.941 | ↑ 6.2 | 139 | 3 |
→
Partial GroupAggregate (cost=28,837.19..28,852.17 rows=856 width=16) (actual time=3,186.376..3,234.647 rows=139 loops=3)
|
5. | 340.806 | 9,623.136 | ↓ 62.3 | 53,354 | 3 |
→
Sort (cost=28,837.19..28,839.33 rows=856 width=8) (actual time=3,186.284..3,207.712 rows=53,354 loops=3)
|
6. | 922.391 | 9,282.330 | ↓ 62.3 | 53,354 | 3 |
→
Nested Loop (cost=0.99..28,795.50 rows=856 width=8) (actual time=485.505..3,094.110 rows=53,354 loops=3) |
7. | 1,771.299 | 1,771.299 | ↓ 24.8 | 109,811 | 3 |
→
Parallel Index Only Scan using entity_associations_source_to_target_107725 on entity_associations_107725 entity_associations (cost=0.56..17,206.68 rows=4,425 width=8) (actual time=0.040..590.433 rows=109,811 loops=3)
|
8. | 6,588.640 | 6,588.640 | ↓ 0.0 | 0 | 329,432 |
→
Index Scan using virtual_pkey_a_id_meetings_108749 on meetings_108749 meetings (cost=0.42..2.62 rows=1 width=16) (actual time=0.020..0.020 rows=0 loops=329,432)
|