explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZS4X

Settings
# exclusive inclusive rows x rows loops node
1. 72.793 193.566 ↓ 1.6 107,358 1

Hash Join (cost=1,131.96..14,625.47 rows=66,746 width=1,408) (actual time=13.226..193.566 rows=107,358 loops=1)

  • Hash Cond: ("Extent1".permitownerorganisationid = "Extent2".id)
2. 107.617 107.617 ↓ 1.6 107,358 1

Seq Scan on permit "Extent1" (cost=0.00..12,650.93 rows=66,746 width=714) (actual time=0.014..107.617 rows=107,358 loops=1)

  • Filter: ((permitstatustypeid = 8) AND (approvedperiodto < LOCALTIMESTAMP))
  • Rows Removed by Filter: 68811
3. 5.129 13.156 ↑ 1.0 6,576 1

Hash (cost=1,049.76..1,049.76 rows=6,576 width=694) (actual time=13.156..13.156 rows=6,576 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 2219kB
4. 8.027 8.027 ↑ 1.0 6,576 1

Seq Scan on organisation "Extent2" (cost=0.00..1,049.76 rows=6,576 width=694) (actual time=0.010..8.027 rows=6,576 loops=1)

Planning time : 0.341 ms