explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RGbF : 23423

Settings
# exclusive inclusive rows x rows loops node
1. 0.454 0.579 ↑ 1.0 1 1

Subquery Scan on t1 (cost=730.56..730.85 rows=1 width=4) (actual time=0.577..0.579 rows=1 loops=1)

2. 0.003 0.125 ↑ 1.0 1 1

Limit (cost=730.56..730.58 rows=1 width=28) (actual time=0.123..0.125 rows=1 loops=1)

3. 0.003 0.122 ↑ 650.0 1 1

WindowAgg (cost=730.56..741.93 rows=650 width=28) (actual time=0.122..0.122 rows=1 loops=1)

4. 0.019 0.119 ↑ 325.0 2 1

Sort (cost=730.56..732.18 rows=650 width=44) (actual time=0.119..0.119 rows=2 loops=1)

  • Sort Key: uzgps_routing_trip_route_station.priority
  • Sort Method: quicksort Memory: 26kB
5. 0.028 0.100 ↑ 26.0 25 1

WindowAgg (cost=687.19..700.19 rows=650 width=44) (actual time=0.082..0.100 rows=25 loops=1)

6. 0.013 0.072 ↑ 26.0 25 1

Sort (cost=687.19..688.82 rows=650 width=28) (actual time=0.070..0.072 rows=25 loops=1)

  • Sort Key: uzgps_routing_trip_route_station.priority DESC
  • Sort Method: quicksort Memory: 26kB
7. 0.059 0.059 ↑ 26.0 25 1

Index Scan using uzgps_routing_trip_route_station_trip_id_index on uzgps_routing_trip_route_station (cost=0.56..656.82 rows=650 width=28) (actual time=0.035..0.059 rows=25 loops=1)

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