explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 00XW

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.012 ↑ 10,000.0 1 1

Bitmap Heap Scan on tblfun tblfun (cost=113.5..32,928.93 rows=10,000 width=123) (actual time=0.012..0.012 rows=1 loops=1)

  • Heap Blocks: exact=1
  • Buffers: shared hit=5
2. 0.007 0.007 ↑ 10,000.0 1 1

Bitmap Index Scan on tblfun_data_idx (cost=0..111 rows=10,000 width=0) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (tblfun.data @> '{"name": "12301.photo.blog"}'::jsonb)
  • Buffers: shared hit=4
Planning time : 0.055 ms
Execution time : 0.032 ms