explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WPoy

Settings
# exclusive inclusive rows x rows loops node
1. 161.129 10,319.233 ↓ 11.8 494,077 1

Group (cost=1,674,833.62..1,684,837.39 rows=41,971 width=8) (actual time=9,669.478..10,319.233 rows=494,077 loops=1)

  • Group Key: booked_room_id
2. 396.504 10,158.104 ↓ 14.7 1,234,232 1

Gather Merge (cost=1,674,833.62..1,684,627.53 rows=83,942 width=8) (actual time=9,669.471..10,158.104 rows=1,234,232 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 401.076 9,761.600 ↓ 9.8 411,411 3 / 3

Sort (cost=1,673,833.59..1,673,938.52 rows=41,971 width=8) (actual time=9,601.684..9,761.600 rows=411,411 loops=3)

  • Sort Key: booked_room_id
  • Sort Method: external merge Disk: 7,528kB
  • Worker 0: Sort Method: external merge Disk: 6,856kB
  • Worker 1: Sort Method: external merge Disk: 7,400kB
4. 2,003.603 9,360.524 ↓ 9.8 411,411 3 / 3

Partial HashAggregate (cost=1,670,191.12..1,670,610.83 rows=41,971 width=8) (actual time=9,213.782..9,360.524 rows=411,411 loops=3)

  • Group Key: booked_room_id
5. 7,356.921 7,356.921 ↑ 1.2 5,321,576 3 / 3

Parallel Seq Scan on req_package2 rp2 (cost=0.00..1,653,672.79 rows=6,607,330 width=8) (actual time=0.173..7,356.921 rows=5,321,576 loops=3)

  • Filter: (state = 3)
  • Rows Removed by Filter: 731,453
Planning time : 0.527 ms
Execution time : 10,410.705 ms