explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kcvA

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 0.108 ↓ 2.4 460 1

Bitmap Heap Scan on road_segments_grid_partitioned_1246 (cost=5.93..622.01 rows=195 width=24) (actual time=0.049..0.108 rows=460 loops=1)

  • Recheck Cond: (link_id = '753001307284180753'::bigint)
  • Heap Blocks: exact=9
2. 0.038 0.038 ↓ 2.4 460 1

Bitmap Index Scan on road_segments_grid_partitioned_1246_link_id_idx (cost=0.00..5.89 rows=195 width=0) (actual time=0.038..0.038 rows=460 loops=1)

  • Index Cond: (link_id = '753001307284180753'::bigint)