explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Mp

Settings
# exclusive inclusive rows x rows loops node
1. 1,993.179 10,584.779 ↑ 1,585.4 188 1

HashAggregate (cost=159,369.84..162,350.37 rows=298,053 width=92) (actual time=10,583.892..10,584.779 rows=188 loops=1)

  • Group Key: waterfall_job_ent.id, waterfall_job.id
2. 1,069.007 8,591.600 ↓ 1.3 1,908,576 1

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

  • Hash Cond: (waterfall_task.job_id = waterfall_job.id)
3. 7,490.585 7,490.585 ↑ 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.016..7,490.585 rows=394,096 loops=1)

4. 0.000 32.008 ↑ 2.7 188 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
5. 10.517 32.013 ↑ 2.7 188 1

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

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

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

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

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

  • Filter: (ent_id = 5112)
  • Rows Removed by Filter: 27244
8. 0.147 0.629 ↓ 1.0 591 1

Hash (cost=47.27..47.27 rows=581 width=46) (actual time=0.629..0.629 rows=591 loops=1)

9. 0.482 0.482 ↓ 1.0 591 1

Seq Scan on waterfall_job (cost=0.00..47.27 rows=581 width=46) (actual time=0.053..0.482 rows=591 loops=1)

  • Filter: (owner_id <> 7433)