explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eyxL : Optimization for: plan #vWOd

Settings

Optimization path:

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

Insert on submission_to_update (cost=0.57..17,422,538.29 rows=100,000 width=83) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Limit (cost=0.57..17,421,538.29 rows=100,000 width=83) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..1,725,781,359.92 rows=9,906,022 width=83) (actual rows= loops=)

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

Index Scan using ix_uq_temp_clean_submission on temp_clean_submission tcs (cost=0.57..5.53 rows=1 width=83) (actual rows= loops=)

  • Index Cond: ((role_id = s.role_id) AND (profile_id = s.profile_id))
  • Filter: ((s.submission_status_id IS DISTINCT FROM submission_status_id) OR (s.creator_account_id IS DISTINCT FROM creator_account_id) OR ((s.note)::text IS DISTINCT FROM (note)::text) OR (s.is_overscale IS DISTINCT FROM is_overscale) OR (s.tile_scheme_value_id IS DISTINCT FROM tile_scheme_value_id) OR (s.created IS DISTINCT FROM COALESCE(created, '1970-01-01 00:00:00+01'::timestamp with time zone)))