explain.depesz.com

PostgreSQL's explain analyze made readable

Result: njrK : sdf

Settings
# exclusive inclusive rows x rows loops node
1. 1,912.539 17,205.719 ↑ 3.5 1,228,798 1

Finalize GroupAggregate (cost=6,374,642.38..12,229,470.69 rows=4,299,340 width=72) (actual time=9,525.838..17,205.719 rows=1,228,798 loops=1)

  • Group Key: trip_id, trip_route_id, route_id
2. 0.000 15,293.180 ↑ 4.0 8,501,730 1

Gather Merge (cost=6,374,642.38..11,197,629.09 rows=34,394,720 width=88) (actual time=9,525.807..15,293.180 rows=8,501,730 loops=1)

  • Workers Planned: 8
  • Workers Launched: 8
3. 17,177.652 108,935.190 ↑ 4.6 944,637 9

Partial GroupAggregate (cost=6,373,642.24..6,954,053.14 rows=4,299,340 width=88) (actual time=9,421.264..12,103.910 rows=944,637 loops=9)

  • Group Key: trip_id, trip_route_id, route_id
4. 48,786.678 91,757.538 ↑ 1.1 4,766,536 9

Sort (cost=6,373,642.24..6,387,077.67 rows=5,374,175 width=52) (actual time=9,420.876..10,195.282 rows=4,766,536 loops=9)

  • Sort Key: trip_id, trip_route_id, route_id
  • Sort Method: external merge Disk: 291232kB
  • Worker 0: Sort Method: external merge Disk: 299264kB
  • Worker 1: Sort Method: external merge Disk: 285944kB
  • Worker 2: Sort Method: external merge Disk: 291064kB
  • Worker 3: Sort Method: external merge Disk: 282280kB
  • Worker 4: Sort Method: external merge Disk: 285520kB
  • Worker 5: Sort Method: external merge Disk: 286272kB
  • Worker 6: Sort Method: external merge Disk: 300552kB
  • Worker 7: Sort Method: external merge Disk: 296728kB
5. 42,970.860 42,970.860 ↑ 1.1 4,766,536 9

Parallel Seq Scan on uzgps_routing_trip_route_station (cost=0.00..5,450,103.19 rows=5,374,175 width=52) (actual time=0.053..4,774.540 rows=4,766,536 loops=9)

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