explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3bty

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 0.572 ↓ 0.0 1 1

Aggregate (cost=0..0 rows=0 width=0) (actual time=0.572..0.572 rows=1 loops=1)

2. 0.479 0.543 ↓ 0.0 285 1

Bitmap Heap Scan on bookmarks (cost=0..0 rows=0 width=0) (actual time=0.101..0.543 rows=285 loops=1)

  • Recheck Cond: (jb @? '$."tags"[*]?(@."term" == "NYC")'::jsonpath)
  • Heap Blocks: exact=285
3. 0.064 0.064 ↓ 0.0 285 1

Bitmap Index Scan on bookmarks_jb_idx3 (cost=0..0 rows=0 width=0) (actual time=0.064..0.064 rows=285 loops=1)

  • Index Cond: (jb @? '$."tags"[*]?(@."term" == "NYC")'::jsonpath)
Planning time : 1.702 ms
Execution time : 0.612 ms