explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LsmC : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 145.973 145.973 ↓ 0.0 0 1

Index Scan using uzgps_routing_trip_id_idx on uzgps_routing_trip urt (cost=0.43..53,085.47 rows=94 width=200) (actual time=145.973..145.973 rows=0 loops=1)

  • Index Cond: ((id >= 0) AND (id <= 77777))
  • Filter: ((trip_template_id < 0) AND (status = 'A'::bpchar) AND (time_start >= trip_routing_uzb.timetomillisecond((now() - '12:00:00'::interval))) AND ((time_end < trip_routing_uzb.timetomillisecond((now() + '12:00:00'::interval))) OR (time_end < 1) OR (time_end IS NULL)))
  • Rows Removed by Filter: 69242