explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yXpO : asdsad

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 0.140 ↑ 1.0 1 1

Subquery Scan on t1 (cost=726.85..727.14 rows=1 width=4) (actual time=0.139..0.140 rows=1 loops=1)

2. 0.002 0.115 ↑ 1.0 1 1

Limit (cost=726.85..726.87 rows=1 width=28) (actual time=0.114..0.115 rows=1 loops=1)

3. 0.002 0.113 ↑ 647.0 1 1

WindowAgg (cost=726.85..738.17 rows=647 width=28) (actual time=0.113..0.113 rows=1 loops=1)

4. 0.011 0.111 ↑ 323.5 2 1

Sort (cost=726.85..728.47 rows=647 width=44) (actual time=0.111..0.111 rows=2 loops=1)

  • Sort Method: quicksort Memory: 27kB
  • Sort Key: uzgps_routing_trip_route_station.priority
5. 0.026 0.100 ↑ 24.0 27 1

WindowAgg (cost=683.70..696.64 rows=647 width=44) (actual time=0.080..0.100 rows=27 loops=1)

6. 0.017 0.074 ↑ 24.0 27 1

Sort (cost=683.70..685.32 rows=647 width=28) (actual time=0.073..0.074 rows=27 loops=1)

  • Sort Method: quicksort Memory: 27kB
  • Sort Key: uzgps_routing_trip_route_station.priority DESC
7. 0.057 0.057 ↑ 24.0 27 1

Index Scan using uzgps_routing_trip_route_station_trip_id_idx on uzgps_routing_trip_route_station (cost=0.56..653.50 rows=647 width=28) (actual time=0.027..0.057 rows=27 loops=1)

  • Index Cond: (trip_id = 49)
  • Filter: (status = 'A'::bpchar)
Planning time : 0.160 ms
Execution time : 0.185 ms