explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ckHU

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 0.263 ↑ 1.0 492 1

Limit (cost=0..39.5 rows=492 width=323) (actual time=0.007..0.263 rows=492 loops=1)

  • Buffers: shared hit=32
2. 0.224 0.224 ↑ 1.0 492 1

Seq Scan on Business Business (cost=0..39.5 rows=492 width=323) (actual time=0.006..0.224 rows=492 loops=1)

  • Filter: "Business".is_active
  • Buffers: shared hit=32
Planning time : 0.076 ms
Execution time : 0.301 ms