explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hliY

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 0.075 ↑ 19.0 1 1

Bitmap Heap Scan on naples (cost=10.15..94.10 rows=19 width=459) (actual time=0.074..0.075 rows=1 loops=1)

  • Recheck Cond: (ref @> '{osm: n197461846}'::jsonb)
  • Heap Blocks: exact=1
2. 0.045 0.045 ↑ 19.0 1 1

Bitmap Index Scan on naples_ref_index (cost=0.00..10.14 rows=19 width=0) (actual time=0.045..0.045 rows=1 loops=1)

  • Index Cond: (ref @> '{osm: n197461846}'::jsonb)