explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m5He : 353245

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.026 ↑ 1.0 1 1

Aggregate (cost=1,115.60..1,115.61 rows=1 width=52) (actual time=0.026..0.026 rows=1 loops=1)

2. 0.001 0.023 ↓ 0.0 0 1

WindowAgg (cost=727.82..911.16 rows=649 width=52) (actual time=0.023..0.023 rows=0 loops=1)

3. 0.003 0.022 ↓ 0.0 0 1

Sort (cost=727.82..729.44 rows=649 width=64) (actual time=0.022..0.022 rows=0 loops=1)

  • Sort Key: urtrs.priority DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.001 0.019 ↓ 0.0 0 1

WindowAgg (cost=684.52..697.50 rows=649 width=64) (actual time=0.019..0.019 rows=0 loops=1)

5. 0.002 0.018 ↓ 0.0 0 1

Sort (cost=684.52..686.15 rows=649 width=52) (actual time=0.018..0.018 rows=0 loops=1)

  • Sort Key: urtrs.priority
  • Sort Method: quicksort Memory: 25kB
6. 0.016 0.016 ↓ 0.0 0 1

Index Scan using uzgps_routing_trip_route_station_trip_id_index on uzgps_routing_trip_route_station urtrs (cost=0.56..654.21 rows=649 width=52) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (trip_id = 3252435)