explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1aJf

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 10,697.403 ↑ 1.0 1 1

Finalize Aggregate (cost=700,571.79..700,571.80 rows=1 width=8) (actual time=10,697.402..10,697.403 rows=1 loops=1)

2. 64.235 10,701.454 ↓ 1.5 3 1

Gather (cost=700,571.57..700,571.78 rows=2 width=8) (actual time=10,685.372..10,701.454 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 513.730 10,637.219 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=699,571.57..699,571.58 rows=1 width=8) (actual time=10,637.218..10,637.219 rows=1 loops=3)

4. 1,168.483 10,123.489 ↓ 3.4 995,105 3 / 3

Hash Anti Join (cost=255,442.09..698,847.41 rows=289,666 width=0) (actual time=5,608.547..10,123.489 rows=995,105 loops=3)

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

Hash Join (cost=198,805.96..638,454.16 rows=316,353 width=19) (actual time=5,599.384..8,947.271 rows=995,105 loops=3)

  • Hash Cond: (m.tblreturnmetaid = t_returnmeta_sequence.tblreturnmetaid)
6. 1,870.888 1,870.888 ↑ 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.065..1,870.888 rows=995,105 loops=3)

  • Filter: ((amendedbyobjectid IS NULL) AND (archived IS NULL))
  • Rows Removed by Filter: 2,964,630
7. 2,524.502 5,462.639 ↑ 1.0 3,002,963 3 / 3

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

  • Buckets: 4,194,304 Batches: 1 Memory Usage: 138,341kB
8. 2,938.137 2,938.137 ↑ 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=13.577..2,938.137 rows=3,002,963 loops=3)

  • Filter: (archived IS NULL)
  • Rows Removed by Filter: 3,002,871
9. 0.002 7.735 ↓ 0.0 0 3 / 3

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

  • Buckets: 262,144 Batches: 1 Memory Usage: 2,048kB
10. 0.005 7.733 ↓ 0.0 0 3 / 3

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

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

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

  • Index Cond: ((mainformcompletedate IS NULL) AND (mainformrequestdate IS NOT NULL))
Planning time : 177.728 ms
Execution time : 10,749.416 ms