explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WI7I

Settings
# exclusive inclusive rows x rows loops node
1. 9.861 13.000 ↑ 1.0 13,271 1

Hash Join (cost=32.37..845.56 rows=13,271 width=448) (actual time=0.431..13.000 rows=13,271 loops=1)

2. 2.726 2.726 ↑ 1.0 13,271 1

Seq Scan on job_job j (cost=0.00..630.71 rows=13,271 width=264) (actual time=0.007..2.726 rows=13,271 loops=1)

3. 0.253 0.413 ↓ 1.0 773 1

Hash (cost=22.72..22.72 rows=772 width=184) (actual time=0.413..0.413 rows=773 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 120kB
4. 0.160 0.160 ↓ 1.0 773 1

Seq Scan on organization_organization o (cost=0.00..22.72 rows=772 width=184) (actual time=0.004..0.160 rows=773 loops=1)

Planning time : 0.167 ms