explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kppm

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 7.586 ↓ 0.0 0 1

Delete on place (cost=6.34..1,036.97 rows=3,512 width=12) (actual time=7.586..7.586 rows=0 loops=1)

  • Buffers: shared hit=634
2. 1.550 7.568 ↓ 0.0 0 1

Hash Semi Join (cost=6.34..1,036.97 rows=3,512 width=12) (actual time=7.568..7.568 rows=0 loops=1)

  • Hash Cond: (place.format_id = format.id)
  • Buffers: shared hit=634
3. 5.982 5.982 ↑ 1.0 28,797 1

Seq Scan on place (cost=0.00..915.97 rows=28,797 width=14) (actual time=0.006..5.982 rows=28,797 loops=1)

  • Buffers: shared hit=628
4. 0.010 0.036 ↓ 4.1 41 1

Hash (cost=6.21..6.21 rows=10 width=14) (actual time=0.036..0.036 rows=41 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=3
5. 0.026 0.026 ↓ 4.1 41 1

Seq Scan on format (cost=0.00..6.21 rows=10 width=14) (actual time=0.008..0.026 rows=41 loops=1)

  • Filter: ((chain_id = 0) AND (channel_id = 35))
  • Rows Removed by Filter: 173
  • Buffers: shared hit=3
Planning time : 6.714 ms
Execution time : 7.644 ms