explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BZX0 : 2345

Settings
# exclusive inclusive rows x rows loops node
1. 0.185 249.577 ↑ 76.9 27 1

Hash Join (cost=54.38..2,810.11 rows=2,075 width=418) (actual time=249.407..249.577 rows=27 loops=1)

  • Hash Cond: (uzgps_routing_trip_route_station.trip_station_id = get_trip_pass_track_points.otrip_station_id)
2. 1.046 1.458 ↑ 15.4 27 1

Bitmap Heap Scan on uzgps_routing_trip_route_station (cost=31.63..1,665.82 rows=415 width=334) (actual time=1.433..1.458 rows=27 loops=1)

  • Recheck Cond: (trip_id = $22)
  • Heap Blocks: exact=598
3. 0.412 0.412 ↓ 11.0 4,557 1

Bitmap Index Scan on uzgps_routing_trip_route_station_trip_id_idx (cost=0.00..31.53 rows=415 width=0) (actual time=0.412..0.412 rows=4,557 loops=1)

  • Index Cond: (trip_id = $22)
4. 247.934 247.934 ↑ 37.0 27 1

Hash (cost=10.25..10.25 rows=1,000 width=80) (actual time=247.934..247.934 rows=27 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • -> Function Scan on get_trip_pass_track_points (cost=0.25..10.25 rows=1000 width=80) (actual time=247.914..247.924 rows=27 loops=1)",,,,,"SQL statement ""UPDATE uzgps_routing_trip_route_station