explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aOpG : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 3.150 613.239 ↓ 0.0 0 1

Update on uzgps_routing_trip_route_station (cost=691.31..705.57 rows=1 width=973) (actual time=613.239..613.239 rows=0 loops=1)

2. 1.131 610.089 ↓ 36.0 36 1

Hash Join (cost=691.31..705.57 rows=1 width=973) (actual time=609.601..610.089 rows=36 loops=1)

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

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

4. 0.052 0.176 ↑ 17.7 37 1

Hash (cost=682.87..682.87 rows=655 width=881) (actual time=0.176..0.176 rows=37 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
5. 0.124 0.124 ↑ 17.7 37 1

Index Scan using uzgps_routing_trip_route_station_trip_id_index on uzgps_routing_trip_route_station (cost=0.56..682.87 rows=655 width=881) (actual time=0.041..0.124 rows=37 loops=1)

  • Index Cond: (trip_id = 123123)
  • Filter: (id <> 123123)
Planning time : 0.800 ms
Execution time : 614.348 ms