explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q0dB

Settings
# exclusive inclusive rows x rows loops node
1. 241.245 336.367 ↑ 1.2 4,871 1

Bitmap Heap Scan on v_transit_roads_partitioned (cost=215.11..165,964.79 rows=6,042 width=220) (actual time=102.827..336.367 rows=4,871 loops=1)

  • Filter: st_intersects(geometry, '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry)
  • Heap Blocks: exact=534
  • Functions: 2
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 0.564 ms, Inlining 0.000 ms, Optimization 0.431 ms, Emission 3.940 ms, Total 4.936 ms"Execution Time: 337.330 ms
2. 95.122 95.122 ↑ 1.2 4,871 1

Bitmap Index Scan on v_transit_roads_geometry_geom_idx_partitioned (cost=0.00..213.60 rows=6,042 width=0) (actual time=95.122..95.122 rows=4,871 loops=1)

  • Index Cond: (geometry && '0103000020110F000001000000050000003333FF6E433C7041EC51F818D67B48C13333FF6E433C70417B140EFA45C848C185EB216BD14570417B140EFA45C848C185EB216BD1457041EC51F818D67B48C13333FF6E433C7041EC51F818D67B48C1'::geometry)