# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 3.770 | 68.280 | ↑ 1.0 | 10,586 | 1 |
→
"hash right join (cost=14,810.30..15,528.89 rows=10,586 width=54) (actual time=55.986..68.280 rows=10,586 loops=1)
|
2. | 7.887 | 62.155 | ↑ 2.3 | 10,586 | 1 |
→
groupaggregate (cost=14,488.41..14,894.93 rows=23,913 width=66) (actual time=53.576..62.155 rows=10,586 loops=1)
|
3. | 4.949 | 54.268 | ↑ 1.1 | 20,867 | 1 |
→
sort (cost=14,488.41..14,512.32 rows=23,913 width=39) (actual time=53.546..54.268 rows=20,867 loops=1)
|
4. | 14.100 | 49.319 | ↑ 1.1 | 20,867 | 1 |
→
hash semi join (cost=3,589.42..13,506.35 rows=23,913 width=39) (actual time=9.693..49.319 rows=20,867 loops=1)
|
5. | 25.712 | 33.031 | ↓ 1.5 | 118,243 | 1 |
→
bitmap heap scan on public. t3 (cost=3,278.11..12,859.73 rows=81,356 width=39) (actual time=7.452..33.031 rows=118,243 loops=1)
|
6. | 7.319 | 7.319 | ↓ 1.5 | 118,243 | 1 |
→
bitmap index scan on _1 (cost=0.00..3,269.98 rows=81,401 width=0) (actual time=7.319..7.319 rows=118,243 loops=1)
|
7. | 1.380 | 2.188 | ↑ 1.0 | 10,586 | 1 |
→
hash (cost=194.86..194.86 rows=10,586 width=17) (actual time=2.188..2.188 rows=10,586 loops=1)
|
8. | 0.808 | 0.808 | ↑ 1.0 | 10,586 | 1 |
→
seq scan on pg_temp_6.tt3 t4 (cost=0.00..194.86 rows=10,586 width=17) (actual time=0.010..0.808 rows=10,586 loops=1)
|
9. | 1.703 | 2.355 | ↑ 1.0 | 10,586 | 1 |
→
hash (cost=194.86..194.86 rows=10,586 width=39) (actual time=2.355..2.355 rows=10,586 loops=1)
|
10. | 0.652 | 0.652 | ↑ 1.0 | 10,586 | 1 |
→
seq scan on pg_temp_6.tt3 t1 (cost=0.00..194.86 rows=10,586 width=39) (actual time=0.011..0.652 rows=10,586 loops=1)
|
Planning time | : | 0.389 ms |
---|---|---|
Execution time | : | 69.337 ms |