explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TD2X

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 7,661.987 ↓ 1.0 4,622,473 1

Gather Merge (cost=888,156.18..1,440,779.44 rows=4,615,400 width=446) (actual time=4,382.286..7,661.987 rows=4,622,473 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 8,694.900 23,879.240 ↑ 1.2 924,495 5

Sort (cost=887,156.12..890,040.74 rows=1,153,850 width=446) (actual time=4,335.710..4,775.848 rows=924,495 loops=5)

  • Sort Key: complaints.created_at DESC
  • Sort Method: external merge Disk: 353144kB
  • Worker 0: Sort Method: external merge Disk: 390216kB
  • Worker 1: Sort Method: external merge Disk: 361032kB
  • Worker 2: Sort Method: external merge Disk: 347368kB
  • Worker 3: Sort Method: external merge Disk: 340328kB
3. 1,096.300 15,184.340 ↑ 1.2 924,495 5

Hash Left Join (cost=131,086.80..538,287.82 rows=1,153,850 width=446) (actual time=1,802.918..3,036.868 rows=924,495 loops=5)

  • Hash Cond: (complaints.circle_id = circle.circle_id)
4. 8,716.970 14,087.750 ↑ 1.2 924,495 5

Parallel Hash Left Join (cost=131,084.60..523,050.70 rows=1,153,850 width=435) (actual time=1,802.773..2,817.550 rows=924,495 loops=5)

  • Hash Cond: (complaints.id = vehicle_details.complaint_id)
5. 2,904.965 2,904.965 ↑ 1.2 924,495 5

Parallel Seq Scan on complaints (cost=0.00..271,913.24 rows=1,153,850 width=314) (actual time=0.017..580.993 rows=924,495 loops=5)

  • Filter: (is_active = '1'::smallint)
  • Rows Removed by Filter: 64547
6. 1,450.060 2,465.815 ↑ 1.2 867,553 5

Parallel Hash (cost=97,413.49..97,413.49 rows=1,084,249 width=121) (actual time=493.162..493.163 rows=867,553 loops=5)

  • Buckets: 1048576 Batches: 8 Memory Usage: 89952kB
7. 1,015.755 1,015.755 ↑ 1.2 867,553 5

Parallel Seq Scan on vehicle_details (cost=0.00..97,413.49 rows=1,084,249 width=121) (actual time=0.020..203.151 rows=867,553 loops=5)

8. 0.050 0.290 ↑ 1.0 53 5

Hash (cost=1.53..1.53 rows=53 width=15) (actual time=0.058..0.058 rows=53 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
9. 0.240 0.240 ↑ 1.0 53 5

Seq Scan on circle (cost=0.00..1.53 rows=53 width=15) (actual time=0.042..0.048 rows=53 loops=5)

Planning time : 1.682 ms
Execution time : 8,064.379 ms