explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WqfJ : sdfsdf

Settings
# exclusive inclusive rows x rows loops node
1. 19,625.627 96,309.685 ↑ 3.5 1,228,859 1

GroupAggregate (cost=0.56..11,147,215.67 rows=4,291,581 width=72) (actual time=0.117..96,309.685 rows=1,228,859 loops=1)

  • Group Key: trip_id, trip_route_id, route_id
2. 76,684.058 76,684.058 ↑ 1.0 42,900,982 1

Index Scan using uzgps_routing_trip_route_station_trip_id_trip_route_id_route_id on uzgps_routing_trip_route_station (cost=0.56..6,877,092.19 rows=42,915,814 width=52) (actual time=0.038..76,684.058 rows=42,900,982 loops=1)

  • Filter: (status = 'A'::bpchar)