explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bWV6 : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 0.111 0.267 ↑ 17.0 41 1

WindowAgg (cost=798.26..995.72 rows=699 width=52) (actual time=0.169..0.267 rows=41 loops=1)

2. 0.028 0.156 ↑ 17.0 41 1

Sort (cost=798.26..800.00 rows=699 width=64) (actual time=0.145..0.156 rows=41 loops=1)

  • Sort Key: priority DESC
  • Sort Method: quicksort Memory: 30kB
3. 0.083 0.128 ↑ 17.0 41 1

WindowAgg (cost=0.56..765.23 rows=699 width=64) (actual time=0.031..0.128 rows=41 loops=1)

4. 0.045 0.045 ↑ 17.0 41 1

Index Scan using uzgps_routing_trip_route_station_trip_id_priority_index on uzgps_routing_trip_route_station urtrs (cost=0.56..753.00 rows=699 width=52) (actual time=0.021..0.045 rows=41 loops=1)

  • Index Cond: (trip_id = 44444)
Planning time : 0.146 ms
Execution time : 0.320 ms