explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E5hq

Settings
# exclusive inclusive rows x rows loops node
1. 0.095 0.143 ↓ 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.063..0.143 rows=460 loops=1)

  • Recheck Cond: (link_id = '753001307284180753'::bigint)
  • Heap Blocks: exact=9
2. 0.048 0.048 ↓ 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.048..0.048 rows=460 loops=1)

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