explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z3U

Settings
# exclusive inclusive rows x rows loops node
1. 1,760.526 5,286.968 ↑ 1,585.4 188 1

HashAggregate (cost=159,369.84..162,350.37 rows=298,053 width=92) (actual time=5,286.078..5,286.968 rows=188 loops=1)

  • Group Key: waterfall_job_ent.id, waterfall_job.id
2. 919.343 3,526.442 ↓ 1.3 1,908,576 1

Hash Right Join (cost=5,638.17..133,941.55 rows=1,453,045 width=80) (actual time=88.489..3,526.442 rows=1,908,576 loops=1)

  • Hash Cond: (waterfall_task.job_id = waterfall_job.id)
3. 2,519.322 2,519.322 ↑ 4.2 394,096 1

Seq Scan on waterfall_task (cost=0.00..107,579.04 rows=1,651,704 width=16) (actual time=0.013..2,519.322 rows=394,096 loops=1)

4. 0.000 87.777 ↑ 2.7 188 1

Hash (cost=5,631.77..5,631.77 rows=512 width=68) (actual time=87.777..87.777 rows=188 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
5. 17.877 87.825 ↑ 2.7 188 1

Gather (cost=1,054.54..5,631.77 rows=512 width=68) (actual time=85.561..87.825 rows=188 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 0.000 69.948 ↑ 3.4 63 3

Hash Join (cost=54.54..4,580.57 rows=213 width=68) (actual time=64.103..69.948 rows=63 loops=3)

  • Hash Cond: (waterfall_job_ent.job_id = waterfall_job.id)
7. 37.424 37.424 ↑ 3.4 63 3

Parallel Seq Scan on waterfall_job_ent (cost=0.00..4,523.09 rows=214 width=22) (actual time=31.603..37.424 rows=63 loops=3)

  • Filter: (ent_id = 5112)
  • Rows Removed by Filter: 27244
8. 0.137 48.560 ↓ 1.0 591 2

Hash (cost=47.27..47.27 rows=581 width=46) (actual time=48.560..48.560 rows=591 loops=2)

9. 48.423 48.423 ↓ 1.0 591 2

Seq Scan on waterfall_job (cost=0.00..47.27 rows=581 width=46) (actual time=0.052..48.423 rows=591 loops=2)

  • Filter: (owner_id <> 7433)