explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MvxV

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

Finalize Aggregate (cost=706,957.46..706,957.47 rows=1 width=8) (actual time=8,707.406..8,707.407 rows=1 loops=1)

2. 34.229 8,710.835 ↓ 1.5 3 1

Gather (cost=706,957.24..706,957.45 rows=2 width=8) (actual time=8,679.943..8,710.835 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 505.566 8,676.606 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=705,957.24..705,957.25 rows=1 width=8) (actual time=8,676.605..8,676.606 rows=1 loops=3)

4. 1,425.938 8,171.040 ↓ 6.3 995,105 3 / 3

Hash Join (cost=258,968.35..705,561.80 rows=158,176 width=0) (actual time=4,925.691..8,171.040 rows=995,105 loops=3)

  • Hash Cond: (m.tblreturnmetaid = t_returnmeta_sequence.tblreturnmetaid)
5. 1,849.905 1,856.847 ↓ 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.489..1,856.847 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. 6.942 6.942 ↓ 0.0 0 3 / 3

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

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

Hash (cost=161,263.32..161,263.32 rows=3,003,411 width=4) (actual time=4,888.255..4,888.255 rows=3,002,963 loops=3)

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

Seq Scan on t_returnmeta_sequence (cost=0.00..161,263.32 rows=3,003,411 width=4) (actual time=1.808..2,674.673 rows=3,002,963 loops=3)

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