explain.depesz.com

PostgreSQL's explain analyze made readable

Result: amWV : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 4.403 286.872 ↓ 2.4 4,859 1

Sort (cost=105,204.39..105,209.54 rows=2,063 width=200) (actual time=286.111..286.872 rows=4,859 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 1453kB
2. 282.469 282.469 ↓ 2.4 4,859 1

Index Scan using uzgps_routing_trip_mobject_id_time_start_time_end_status_idx on uzgps_routing_trip urt (cost=0.81..105,090.81 rows=2,063 width=200) (actual time=0.632..282.469 rows=4,859 loops=1)

  • Index Cond: (time_start >= trip_routing_uzb.timetomillisecond((now() - '12:00:00'::interval)))
  • Filter: ((trip_template_id < 0) AND (id > 3) AND (status = 'A'::bpchar) AND ((time_end < trip_routing_uzb.timetomillisecond((now() - '06:00:00'::interval))) OR (time_end < 1) OR (time_end IS NULL)))
  • Rows Removed by Filter: 5595
Planning time : 1.059 ms
Execution time : 287.237 ms