# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 13,446.262 | 72,666.363 | ↑ 219,824.4 | 30 | 1 |
→
Merge Left Join (cost=3,144,191.27..4,160,025.40 rows=6,594,733 width=72) (actual time=37,674.818..72,666.363 rows=30 loops=1)
|
2. | 2,673.455 | 28,166.476 | ↑ 1.0 | 6,565,601 | 1 |
→
Merge Left Join (cost=990,006.45..1,609,636.75 rows=6,594,733 width=260) (actual time=8,274.204..28,166.476 rows=6,565,601 loops=1)
|
3. | 9,210.920 | 9,210.920 | ↑ 1.0 | 6,565,601 | 1 |
→
Index Scan using pk_containers on containers oc (cost=0.43..392,646.24 rows=6,594,733 width=156) (actual time=0.027..9,210.920 rows=6,565,601 loops=1)
|
4. | 217.876 | 16,282.101 | ↓ 12.7 | 415,569 | 1 |
→
Materialize (cost=990,006.02..1,200,167.52 rows=32,772 width=112) (actual time=8,274.174..16,282.101 rows=415,569 loops=1) |
5. | 5,959.326 | 16,064.225 | ↓ 12.7 | 415,569 | 1 |
→
GroupAggregate (cost=990,006.02..1,199,757.87 rows=32,772 width=112) (actual time=8,274.168..16,064.225 rows=415,569 loops=1)
|
6. | 6,974.488 | 10,104.899 | ↑ 1.0 | 4,186,844 | 1 |
→
Sort (cost=990,006.02..1,000,473.13 rows=4,186,844 width=18) (actual time=8,273.999..10,104.899 rows=4,186,844 loops=1)
|
7. | 3,130.411 | 3,130.411 | ↑ 1.0 | 4,186,844 | 1 |
→
Seq Scan on files fi (cost=0.00..271,910.44 rows=4,186,844 width=18) (actual time=0.011..3,130.411 rows=4,186,844 loops=1) |
8. | 154.717 | 31,053.625 | ↓ 17.2 | 315,545 | 1 |
→
Materialize (cost=2,154,184.82..2,351,611.43 rows=18,343 width=112) (actual time=25,381.398..31,053.625 rows=315,545 loops=1) |
9. | 3,932.672 | 30,898.908 | ↓ 17.2 | 315,545 | 1 |
→
GroupAggregate (cost=2,154,184.82..2,351,382.14 rows=18,343 width=112) (actual time=25,381.392..30,898.908 rows=315,545 loops=1)
|
10. | 10,780.799 | 26,966.236 | ↑ 1.0 | 6,565,601 | 1 |
→
Sort (cost=2,154,184.82..2,170,598.82 rows=6,565,601 width=48) (actual time=25,381.347..26,966.236 rows=6,565,601 loops=1)
|
11. | 5,885.717 | 16,185.437 | ↑ 1.0 | 6,565,601 | 1 |
→
Merge Join (cost=150.38..804,832.55 rows=6,565,601 width=48) (actual time=0.055..16,185.437 rows=6,565,601 loops=1)
|
12. | 5,417.321 | 5,417.321 | ↑ 1.0 | 8,500,923 | 1 |
→
Index Scan using pk_containers on containers oc2 (cost=0.43..371,393.94 rows=8,500,923 width=48) (actual time=0.030..5,417.321 rows=8,500,923 loops=1) |
13. | 4,882.399 | 4,882.399 | ↑ 1.0 | 6,565,601 | 1 |
→
Index Scan using pk_folders on folders f (cost=0.43..330,151.55 rows=6,565,601 width=16) (actual time=0.017..4,882.399 rows=6,565,601 loops=1) |