explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vagu : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 1.466 351.921 ↓ 0.0 0 1

Update on uzgps_routing_trip_route_station (cost=736.89..751.16 rows=1 width=973) (actual time=351.921..351.921 rows=0 loops=1)

2. 0.318 350.455 ↓ 36.0 36 1

Hash Join (cost=736.89..751.16 rows=1 width=973) (actual time=350.142..350.455 rows=36 loops=1)

  • Hash Cond: (get_trip_pass_track_points.otrip_station_id = uzgps_routing_trip_route_station.trip_station_id)
3. 349.994 349.994 ↑ 27.8 36 1

Function Scan on get_trip_pass_track_points (cost=0.25..10.25 rows=1,000 width=88) (actual time=349.962..349.994 rows=36 loops=1)

4. 0.027 0.143 ↑ 18.9 37 1

Hash (cost=727.90..727.90 rows=699 width=881) (actual time=0.143..0.143 rows=37 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
5. 0.116 0.116 ↑ 18.9 37 1

Index Scan using uzgps_routing_trip_route_station_trip_id_index on uzgps_routing_trip_route_station (cost=0.56..727.90 rows=699 width=881) (actual time=0.027..0.116 rows=37 loops=1)

  • Index Cond: (trip_id = 123123)
  • Filter: (id <> 123123)