explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VRhL

Settings
# exclusive inclusive rows x rows loops node
1. 284,813.074 495,447.144 ↓ 0.0 0 1

Insert on temp_clean_submission_copy (cost=172,895.22..5,784,503.82 rows=37,694,395 width=139) (actual time=495,447.144..495,447.144 rows=0 loops=1)

2. 73,005.881 210,634.070 ↓ 2.3 84,981,003 1

Hash Join (cost=172,895.22..5,784,503.82 rows=37,694,395 width=139) (actual time=1,774.583..210,634.070 rows=84,981,003 loops=1)

  • Hash Cond: (((temp.legacy_profile_id)::text = (prf.legacy_profile_id)::text) AND ((temp.legacy_instance)::text = (prf.legacy_instance)::text))
3. 135,863.543 135,863.543 ↑ 1.0 84,981,072 1

Seq Scan on temp_submission_copy temp (cost=0.00..1,835,165.72 rows=84,981,072 width=129) (actual time=1.838..135,863.543 rows=84,981,072 loops=1)

4. 480.196 1,764.646 ↓ 1.0 1,881,312 1

Hash (cost=134,741.21..134,741.21 rows=1,829,067 width=17) (actual time=1,764.645..1,764.646 rows=1,881,312 loops=1)

  • Buckets: 2,097,152 Batches: 2 Memory Usage: 59,033kB
5. 1,284.450 1,284.450 ↓ 1.0 1,881,312 1

Seq Scan on profile prf (cost=0.00..134,741.21 rows=1,829,067 width=17) (actual time=0.112..1,284.450 rows=1,881,312 loops=1)

  • Filter: ((NOT is_modified_in_new_system) AND ((legacy_instance)::bpchar = 'NY'::bpchar))