explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M58H

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 0.073 ↑ 200.0 2 1

Bitmap Heap Scan on book (cost=7.25..22.25 rows=400 width=4) (actual time=0.037..0.073 rows=2 loops=1)

  • Recheck Cond: (id > 1)
  • Heap Blocks: exact=1
2. 0.024 0.024 ↑ 200.0 2 1

Bitmap Index Scan on book_pkey (cost=0.00..7.15 rows=400 width=0) (actual time=0.016..0.024 rows=2 loops=1)

  • Index Cond: (id > 1)
Planning time : 0.060 ms
Execution time : 0.138 ms