explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e6oa

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 0.038 ↑ 846.7 3 1

Hash Join (cost=30.00..144.78 rows=2,540 width=32) (actual time=0.034..0.038 rows=3 loops=1)

  • Hash Cond: (pet.ownid = ppl.id)
  • Buffers: shared hit=2
2. 0.008 0.008 ↑ 317.5 4 1

Seq Scan on pet (cost=0.00..22.70 rows=1,270 width=36) (actual time=0.007..0.008 rows=4 loops=1)

  • Buffers: shared hit=1
3. 0.004 0.013 ↑ 400.0 1 1

Hash (cost=25.00..25.00 rows=400 width=4) (actual time=0.013..0.013 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
4. 0.009 0.009 ↑ 400.0 1 1

Seq Scan on ppl (cost=0.00..25.00 rows=400 width=4) (actual time=0.007..0.009 rows=1 loops=1)

  • Filter: (age > 25)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=1
Planning time : 0.239 ms
Execution time : 0.147 ms