explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C0ik

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

Insert on inddev_para (cost=317,796.34..317,803.62 rows=1 width=56) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=317,796.34..317,803.62 rows=1 width=56) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Limit (cost=317,795.91..317,795.93 rows=1 width=56) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Group (cost=317,795.91..317,795.93 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=317,795.91..317,795.91 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=75,086.63..317,795.90 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=75,086.61..75,086.61 rows=1 width=40) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on inddev_para p (cost=0.00..75,086.61 rows=1 width=40) (actual rows= loops=)

  • Filter: (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)