explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G9HT

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 8,598.388 ↑ 1.0 1 1

Finalize Aggregate (cost=707,140.01..707,140.02 rows=1 width=8) (actual time=8,598.387..8,598.388 rows=1 loops=1)

2. 34.603 8,601.532 ↓ 1.5 3 1

Gather (cost=707,139.80..707,140.01 rows=2 width=8) (actual time=8,570.336..8,601.532 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 510.852 8,566.929 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=706,139.80..706,139.81 rows=1 width=8) (actual time=8,566.928..8,566.929 rows=1 loops=3)

4. 1,438.734 8,056.077 ↓ 6.3 995,105 3 / 3

Hash Join (cost=259,147.27..705,743.63 rows=158,467 width=0) (actual time=4,768.874..8,056.077 rows=995,105 loops=3)

  • Hash Cond: (m.tblreturnmetaid = t_returnmeta_sequence.tblreturnmetaid)
5. 1,878.392 1,885.448 ↓ 1.6 995,105 3 / 3

Parallel Seq Scan on tblreturnmeta m (cost=60,162.39..501,234.82 rows=630,282 width=4) (actual time=15.330..1,885.448 rows=995,105 loops=3)

  • Filter: ((amendedbyobjectid IS NULL) AND (archived IS NULL) AND (NOT (hashed SubPlan 1)))
  • Rows Removed by Filter: 2964630
6.          

SubPlan (for Parallel Seq Scan)

7. 7.056 7.056 ↓ 0.0 0 3 / 3

Index Scan using ix2tblreparse on tblreparse (cost=0.43..59,563.40 rows=239,594 width=19) (actual time=7.055..7.056 rows=0 loops=3)

  • Index Cond: ((mainformcompletedate IS NULL) AND (mainformrequestdate IS NOT NULL))
8. 2,179.882 4,731.895 ↑ 1.0 3,002,963 3 / 3

Hash (cost=161,373.34..161,373.34 rows=3,008,923 width=4) (actual time=4,731.895..4,731.895 rows=3,002,963 loops=3)

  • Buckets: 4194304 Batches: 1 Memory Usage: 138341kB
9. 2,552.013 2,552.013 ↑ 1.0 3,002,963 3 / 3

Seq Scan on t_returnmeta_sequence (cost=0.00..161,373.34 rows=3,008,923 width=4) (actual time=0.877..2,552.013 rows=3,002,963 loops=3)

  • Filter: (archived IS NULL)
  • Rows Removed by Filter: 3002871
Planning time : 1.657 ms
Execution time : 8,612.309 ms