explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f7iR

Settings
# exclusive inclusive rows x rows loops node
1. 12,738.480 275,278.885 ↓ 1.0 29,512,186 1

Gather (cost=750.56..8,628,419.52 rows=29,476,364 width=1,997) (actual time=3.212..275,278.885 rows=29,512,186 loops=1)

  • Workers Planned: 7
  • Workers Launched: 0
2. 236,785.148 262,540.405 ↓ 7.0 29,512,186 1

Nested Loop Left Join (cost=0.56..5,680,033.12 rows=4,210,909 width=1,997) (actual time=2.435..262,540.405 rows=29,512,186 loops=1)

3. 25,755.250 25,755.250 ↓ 7.0 29,512,186 1

Parallel Seq Scan on leads_standardized s (cost=0.00..1,807,303.09 rows=4,210,909 width=1,034) (actual time=0.005..25,755.250 rows=29,512,186 loops=1)

4. 0.007 0.007 ↑ 1.0 1 29,512,186

Index Scan using leads_raw_pkey on leads_raw r (cost=0.56..0.92 rows=1 width=963) (actual time=0.007..0.007 rows=1 loops=29,512,186)

  • Index Cond: (s.raw_lead_id = raw_lead_id)