# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 0.000 | ↓ 0.0 |
→
Subquery Scan on q1 (cost=964,934.28..965,368.02 rows=34,699 width=782) (actual rows= loops=) |
||
2. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=964,934.28..965,021.03 rows=34,699 width=818) (actual rows= loops=)
|
||
3. | 0.000 | 0.000 | ↓ 0.0 |
→
GroupAggregate (cost=948,878.05..949,745.53 rows=34,699 width=818) (actual rows= loops=)
|
||
4. | 0.000 | 0.000 | ↓ 0.0 |
→
Sort (cost=948,878.05..948,964.80 rows=34,699 width=782) (actual rows= loops=)
|
||
5. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=65,060.65..934,280.79 rows=34,699 width=782) (actual rows= loops=)
|
||
6. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Semi Join (cost=43,150.01..830,061.16 rows=834,510 width=102) (actual rows= loops=)
|
||
7. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=23,257.25..254,917.94 rows=16,049,953 width=118) (actual rows= loops=)
|
||
8. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Right Join (cost=23,174.38..45,826.11 rows=167,998 width=94) (actual rows= loops=)
|
||
9. | 0.000 | 0.000 | ↓ 0.0 |
→
Merge Left Join (cost=0.84..16,150.91 rows=155,103 width=46) (actual rows= loops=)
|
||
10. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using uc_version_attachmentattachment_id_col on version_attachment vat (cost=0.42..5,389.11 rows=155,103 width=16) (actual rows= loops=) |
||
11. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using "attachmentPK" on attachment (cost=0.42..8,387.94 rows=174,026 width=46) (actual rows= loops=) |
||
12. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=19,432.56..19,432.56 rows=167,998 width=56) (actual rows= loops=) |
||
13. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=6,410.87..19,432.56 rows=167,998 width=56) (actual rows= loops=)
|
||
14. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on version (cost=0.00..7,104.98 rows=167,998 width=28) (actual rows= loops=) |
||
15. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=3,002.72..3,002.72 rows=167,772 width=36) (actual rows= loops=) |
||
16. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on workflow (cost=0.00..3,002.72 rows=167,772 width=36) (actual rows= loops=) |
||
17. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=50.72..50.72 rows=2,572 width=32) (actual rows= loops=) |
||
18. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on user_project up (cost=0.00..50.72 rows=2,572 width=32) (actual rows= loops=) |
||
19. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=19,764.71..19,764.71 rows=10,244 width=16) (actual rows= loops=) |
||
20. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on vcl (cost=246.83..19,764.71 rows=10,244 width=16) (actual rows= loops=)
|
||
21. | 0.000 | 0.000 | ↓ 0.0 |
→
BitmapOr (cost=246.83..246.83 rows=10,247 width=0) (actual rows= loops=) |
||
22. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on vcl_profile_id_version_id_idx (cost=0.00..219.34 rows=9,454 width=0) (actual rows= loops=)
|
||
23. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on vcl_profile_id_version_id_idx (cost=0.00..22.38 rows=793 width=0) (actual rows= loops=)
|
||
24. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=11,329.84..11,329.84 rows=99,584 width=742) (actual rows= loops=) |
||
25. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on document (cost=0.00..11,329.84 rows=99,584 width=742) (actual rows= loops=) |