explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1cH1 : asdasd

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 0.157 ↑ 1.0 1 1

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

2. 0.001 0.126 ↑ 1.0 1 1

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

3. 0.003 0.125 ↑ 647.0 1 1

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

4. 0.008 0.122 ↑ 323.5 2 1

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

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

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

6. 0.020 0.089 ↑ 24.0 27 1

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

  • Sort Key: uzgps_routing_trip_route_station.priority DESC
  • Sort Method: quicksort Memory: 27kB
7. 0.069 0.069 ↑ 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.039..0.069 rows=27 loops=1)

  • Index Cond: (trip_id = 49)
  • Filter: (status = 'A'::bpchar)