explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dSDO

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

Insert on inddev_para (cost=242,714.17..242,721.45 rows=1 width=56) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=242,714.17..242,721.45 rows=1 width=56) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Limit (cost=242,713.74..242,713.76 rows=1 width=56) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Group (cost=242,713.74..242,713.76 rows=1 width=56) (actual rows= loops=)

  • Group Key: ((md5(((c.mid_name)::text || (c.sex_mf)::text)))::uuid), p.new5
5. 0.000 0.000 ↓ 0.0

Sort (cost=242,713.74..242,713.75 rows=1 width=32) (actual rows= loops=)

  • Sort Key: ((md5(((c.mid_name)::text || (c.sex_mf)::text)))::uuid), p.new5
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=4.46..242,713.73 rows=1 width=32) (actual rows= loops=)

  • Hash Cond: ((md5(((c.mid_name)::text || (c.sex_mf)::text)))::uuid = p.old5)
  • Filter: (p.id IS NULL)
7. 0.000 0.000 ↓ 0.0

Seq Scan on s_contact c (cost=0.00..234,003.00 rows=995,000 width=28) (actual rows= loops=)

  • Filter: ((md5(((mid_name)::text || (sex_mf)::text)))::uuid IS NOT NULL)
8. 0.000 0.000 ↓ 0.0

Hash (cost=4.45..4.45 rows=1 width=40) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using indev_para_par5_idx on inddev_para p (cost=0.43..4.45 rows=1 width=40) (actual rows= loops=)

  • Index Cond: (par5 = '1679091c-5a88-0faf-6fb5-e6087eb1b2dc'::uuid)
10. 0.000 0.000 ↓ 0.0

Limit (cost=0.43..7.66 rows=1 width=180) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Append (cost=0.43..14.88 rows=2 width=180) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Limit (cost=0.43..7.43 rows=1 width=180) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Scan Backward using indev_zamena_ran_vid_id_ix on inddev_zamena c_1 (cost=0.43..99,653.46 rows=14,240 width=180) (actual rows= loops=)

  • Index Cond: ((ran <= (random())) AND (vid_id = 6))
  • Filter: (((md5(((c.mid_name)::text || (c.sex_mf)::text)))::uuid) <> md5_check)
14. 0.000 0.000 ↓ 0.0

Limit (cost=0.43..7.43 rows=1 width=180) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Scan using indev_zamena_ran_vid_id_ix on inddev_zamena c_2 (cost=0.43..99,653.46 rows=14,240 width=180) (actual rows= loops=)

  • Index Cond: ((ran > (random())) AND (vid_id = 6))
  • Filter: (((md5(((c.mid_name)::text || (c.sex_mf)::text)))::uuid) <> md5_check)