explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IFht

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 0.454 ↑ 1.0 492 1

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

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

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

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