explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yfXN

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

Insert on inddev_para (cost=203,070.50..203,120.78 rows=1 width=56) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=203,070.50..203,120.78 rows=1 width=56) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Limit (cost=203,070.07..203,070.12 rows=1 width=59) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Group (cost=203,070.07..203,070.12 rows=1 width=59) (actual rows= loops=)

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

Sort (cost=203,070.07..203,070.08 rows=1 width=35) (actual rows= loops=)

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

Hash Left Join (cost=21,562.00..203,070.06 rows=1 width=35) (actual rows= loops=)

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

Seq Scan on s_ps_credential c (cost=0.00..129,983.10 rows=1,669,864 width=11) (actual rows= loops=)

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

Hash (cost=11,405.00..11,405.00 rows=500,000 width=40) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on inddev_para p (cost=0.00..11,405.00 rows=500,000 width=40) (actual rows= loops=)

  • Filter: (par5 = 'c4ca4238-a0b9-2382-0dcc-509a6f75849b'::uuid)
10. 0.000 0.000 ↓ 0.0

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

11. 0.000 0.000 ↓ 0.0

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

12. 0.000 0.000 ↓ 0.0

Limit (cost=0.43..98.54 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..629,453.11 rows=6,416 width=180) (actual rows= loops=)

  • Index Cond: ((ran <= ((((((((random() * '10'::double precision) * random()) * '10'::double precision) * random()) * '10'::double precision) * random()) * random()))) AND (vid_id = 1))
  • Filter: ((((md5(((c.credential_num)::text || (c.category_cd)::text)))::uuid) <> md5_check) AND (val_group = (c.category_cd)::text))
14. 0.000 0.000 ↓ 0.0

Limit (cost=0.43..2.25 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..628,587.82 rows=346,115 width=180) (actual rows= loops=)

  • Index Cond: ((ran > ((((((((random() * '10'::double precision) * random()) * '10'::double precision) * random()) * '10'::double precision) * random()) * random()))) AND (vid_id = 1))
  • Filter: (((md5(((c.credential_num)::text || (c.category_cd)::text)))::uuid) <> md5_check)