# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 699.593 | ↓ 0.0 | 141 | 1 |
→
Custom Scan (Citus Router) (cost=0.00..0.00 rows=0 width=0) (actual time=699.587..699.593 rows=141 loops=1)
|
2. | 0.070 | 871.649 | ↑ 13.0 | 141 | 1 |
→
Finalize GroupAggregate (cost=116,212.90..116,258.85 rows=1,838 width=16) (actual time=871.565..871.649 rows=141 loops=1)
|
3. | 0.062 | 871.579 | ↑ 8.8 | 420 | 1 |
→
Sort (cost=116,212.90..116,222.09 rows=3,676 width=16) (actual time=871.559..871.579 rows=420 loops=1)
|
4. | 28.239 | 871.517 | ↑ 8.8 | 420 | 1 |
→
Gather (cost=115,609.22..115,995.20 rows=3,676 width=16) (actual time=871.359..871.517 rows=420 loops=1)
|
5. | 37.512 | 843.278 | ↑ 13.1 | 140 | 3 |
→
Partial HashAggregate (cost=114,609.22..114,627.60 rows=1,838 width=16) (actual time=843.238..843.278 rows=140 loops=3)
|
6. | 104.201 | 805.766 | ↓ 3.6 | 78,217 | 3 |
→
Merge Join (cost=30,440.08..114,500.65 rows=21,715 width=8) (actual time=429.218..805.766 rows=78,217 loops=3)
|
7. | 31.341 | 234.640 | ↑ 1.4 | 32,769 | 3 |
→
Sort (cost=30,439.47..30,557.62 rows=47,261 width=24) (actual time=225.062..234.640 rows=32,769 loops=3)
|
8. | 203.299 | 203.299 | ↑ 1.4 | 32,769 | 3 |
→
Parallel Seq Scan on meetings_108749 meetings (cost=0.00..26,770.04 rows=47,261 width=24) (actual time=0.050..203.299 rows=32,769 loops=3)
|
9. | 466.925 | 466.925 | ↓ 1.6 | 438,075 | 3 |
→
Index Only Scan using entity_associations_source_to_target_107725 on entity_associations_107725 entity_associations (cost=0.56..231,638.15 rows=273,549 width=16) (actual time=0.061..466.925 rows=438,075 loops=3)
|