explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MrHH

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 16,792.593 ↓ 0.0 0 1

Hash Join (cost=1,277,851.68..1,528,187.25 rows=8,669,555 width=63) (actual time=16,792.593..16,792.593 rows=0 loops=1)

2. 68.050 68.050 ↑ 344,624.0 1 1

Seq Scan on ce_task_characteristics ctc1 (cost=0.00..17,546.38 rows=344,624 width=21) (actual time=68.050..68.050 rows=1 loops=1)

3. 16,724.130 16,724.130 ↓ 0.0 0 1

Hash (cost=1,210,149.47..1,210,149.47 rows=2,586,817 width=84) (actual time=16,724.130..16,724.130 rows=0 loops=1)

4. 16,724.398 16,724.398 ↓ 0.0 0 1

Gather (cost=347,735.87..1,210,149.47 rows=2,586,817 width=84) (actual time=16,724.129..16,724.398 rows=0 loops=1)

5. 48,692.658 48,692.658 ↓ 0.0 0 3

Hash Join (cost=346,735.87..950,467.77 rows=1,077,840 width=84) (actual time=16,230.886..16,230.886 rows=0 loops=3)

6. 27,316.161 27,316.161 ↑ 20.3 53,008 3

Hash Join (cost=185,480.91..700,119.00 rows=1,077,840 width=199) (actual time=6,805.339..9,105.387 rows=53,008 loops=3)

7. 9,986.910 9,986.910 ↑ 20.3 53,008 3

Hash Join (cost=24,225.95..469,626.74 rows=1,077,840 width=73) (actual time=1,316.584..3,328.970 rows=53,008 loops=3)

8. 4,500.639 4,500.639 ↑ 9.0 189,160 3

Parallel Seq Scan on ce_activity cea (cost=0.00..202,173.59 rows=1,703,360 width=42) (actual time=0.029..1,500.213 rows=189,160 loops=3)

9. 3,922.206 3,922.206 ↑ 1.0 345,015 3

Hash (cost=17,546.38..17,546.38 rows=345,406 width=31) (actual time=1,307.402..1,307.402 rows=345,015 loops=3)

10. 3,022.452 3,022.452 ↑ 1.0 345,015 3

Seq Scan on ce_task_characteristics ctc2 (cost=0.00..17,546.38 rows=345,406 width=31) (actual time=0.041..1,007.484 rows=345,015 loops=3)

11. 15,425.625 15,425.625 ↑ 1.0 1,258,881 3

Hash (cost=118,468.76..118,468.76 rows=1,258,976 width=147) (actual time=5,141.875..5,141.875 rows=1,258,881 loops=3)

12. 8,612.622 8,612.622 ↑ 1.0 1,258,881 3

Seq Scan on projects mp (cost=0.00..118,468.76 rows=1,258,976 width=147) (actual time=0.019..2,870.874 rows=1,258,881 loops=3)

13. 17,902.407 17,902.407 ↑ 1.0 1,258,881 3

Hash (cost=118,468.76..118,468.76 rows=1,258,976 width=147) (actual time=5,967.469..5,967.469 rows=1,258,881 loops=3)

14. 10,630.308 10,630.308 ↑ 1.0 1,258,881 3

Seq Scan on projects p (cost=0.00..118,468.76 rows=1,258,976 width=147) (actual time=3.806..3,543.436 rows=1,258,881 loops=3)

Planning time : 233.268 ms
Execution time : 16,793.417 ms