explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XwJu : testing

Settings
# exclusive inclusive rows x rows loops node
1. 0.554 0.632 ↑ 1.0 1,024 1

Bitmap Heap Scan on t1 (cost=24.22..69.02 rows=1,024 width=4) (actual time=0.089..0.632 rows=1,024 loops=1)

  • Recheck Cond: (id = 4)
  • Heap Blocks: exact=32
  • Buffers: shared hit=38
2. 0.078 0.078 ↑ 1.0 1,024 1

Bitmap Index Scan on idx_id (cost=0.00..23.96 rows=1,024 width=0) (actual time=0.077..0.078 rows=1,024 loops=1)

  • Index Cond: (id = 4)
  • Buffers: shared hit=6
Planning time : 0.127 ms
Execution time : 1.042 ms