explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vWOd

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Insert on submission_to_update (cost=14,635,077.00..14,920,219.80 rows=100,000 width=83) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Limit (cost=14,635,077.00..14,919,219.80 rows=100,000 width=83) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=14,635,077.00..42,782,325.71 rows=9,906,022 width=83) (actual rows= loops=)

  • Hash Cond: ((s.role_id = tcs.role_id) AND (s.profile_id = tcs.profile_id))
  • Join Filter: ((s.submission_status_id IS DISTINCT FROM tcs.submission_status_id) OR (s.creator_account_id IS DISTINCT FROM tcs.creator_account_id) OR ((s.note)::text IS DISTINCT FROM (tcs.note)::text) OR (s.is_overscale IS DISTINCT FROM tcs.is_overscale) OR (s.tile_scheme_value_id IS DISTINCT FROM tcs.tile_scheme_value_id) OR ((s.created IS DISTINCT FROM tcs.created) AND (tcs.created IS NOT NULL)))
4. 0.000 0.000 ↓ 0.0

Seq Scan on submission s (cost=0.00..13,377,471.68 rows=309,348,768 width=90) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=6,072,984.60..6,072,984.60 rows=298,623,360 width=83) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on temp_clean_submission tcs (cost=0.00..6,072,984.60 rows=298,623,360 width=83) (actual rows= loops=)