explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ShYV

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 18.861 ↑ 51.0 1 1

Bitmap Heap Scan on naples (cost=282.39..503.55 rows=51 width=224) (actual time=18.861..18.861 rows=1 loops=1)

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

Bitmap Index Scan on naples_ref_index (cost=0.00..282.38 rows=51 width=0) (actual time=18.832..18.832 rows=1 loops=1)

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