explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6wFh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 9,790.228 ↑ 1.0 1 1

Finalize Aggregate (cost=700,764.73..700,764.74 rows=1 width=8) (actual time=9,790.227..9,790.228 rows=1 loops=1)

2. 19.081 9,794.096 ↓ 1.5 3 1

Gather (cost=700,764.51..700,764.72 rows=2 width=8) (actual time=9,778.341..9,794.096 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 513.140 9,775.015 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=699,764.51..699,764.52 rows=1 width=8) (actual time=9,775.014..9,775.015 rows=1 loops=3)

4. 1,160.617 9,261.875 ↓ 3.4 995,105 3 / 3

Hash Anti Join (cost=255,621.01..699,039.02 rows=290,198 width=0) (actual time=4,788.398..9,261.875 rows=995,105 loops=3)

  • Hash Cond: ((m.objectid)::text = (tblreparse.objectid)::text)
5. 1,475.845 8,094.615 ↓ 3.1 995,105 3 / 3

Hash Join (cost=198,984.88..638,638.88 rows=316,933 width=19) (actual time=4,780.344..8,094.615 rows=995,105 loops=3)

  • Hash Cond: (m.tblreturnmetaid = t_returnmeta_sequence.tblreturnmetaid)
6. 1,860.719 1,860.719 ↑ 1.3 995,105 3 / 3

Parallel Seq Scan on tblreturnmeta m (cost=0.00..428,606.15 rows=1,260,565 width=23) (actual time=0.037..1,860.719 rows=995,105 loops=3)

  • Filter: ((amendedbyobjectid IS NULL) AND (archived IS NULL))
  • Rows Removed by Filter: 2964630
7. 2,202.024 4,758.051 ↑ 1.0 3,002,963 3 / 3

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

  • Buckets: 4194304 Batches: 1 Memory Usage: 138341kB
8. 2,556.027 2,556.027 ↑ 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.169..2,556.027 rows=3,002,963 loops=3)

  • Filter: (archived IS NULL)
  • Rows Removed by Filter: 3002871
9. 0.002 6.643 ↓ 0.0 0 3 / 3

Hash (cost=53,641.21..53,641.21 rows=239,594 width=19) (actual time=6.643..6.643 rows=0 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 2048kB
10. 0.005 6.641 ↓ 0.0 0 3 / 3

Bitmap Heap Scan on tblreparse (cost=8,091.27..53,641.21 rows=239,594 width=19) (actual time=6.641..6.641 rows=0 loops=3)

  • Recheck Cond: ((mainformcompletedate IS NULL) AND (mainformrequestdate IS NOT NULL))
11. 6.636 6.636 ↓ 0.0 0 3 / 3

Bitmap Index Scan on ix2tblreparse (cost=0.00..8,031.37 rows=239,594 width=0) (actual time=6.635..6.636 rows=0 loops=3)

  • Index Cond: ((mainformcompletedate IS NULL) AND (mainformrequestdate IS NOT NULL))
Planning time : 0.887 ms
Execution time : 9,805.634 ms