explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XvGZ

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

Insert on tsc_stage_as_bsngp_itm (cost=2.56..6,546,563.15 rows=1 width=120) (actual rows= loops=)

  • Merge Cond: ((a.id_bsngp = c.id_bsngp) AND ((a.id_itm)::text = (c.id_itm)::text) AND (a.ts_ef = c.ts_ef))
  • Join Filter: (a.id_gp_tx = c.id_gp_tx)
  • Index Cond: ((a.id_bsngp = id_bsngp) AND ((a.id_itm)::text = (id_itm)::text) AND (a.ts_ef = ts_ef))
  • Index Cond: ((a.id_bsngp = id_bsngp) AND ((a.id_itm)::text = (id_itm)::text))
  • Index Cond: ((a.id_bsngp = id_bsngp) AND ((a.id_itm)::text = (id_itm)::text))
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.56..6,546,563.15 rows=1 width=120) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.12..6,546,562.68 rows=1 width=39) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.69..6,546,562.19 rows=1 width=35) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=1.13..6,546,561.49 rows=1 width=23) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using tsc_import_as_bsngp_itm_pkey on tsc_import_as_bsngp_itm a (cost=0.56..2,166,784.98 rows=27,718,456 width=23) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using as_bsngp_itm_pkey on as_bsngp_itm c (cost=0.56..3,537,186.03 rows=40,622,288 width=23) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using as_bsngp_itm_pkey on as_bsngp_itm b (cost=0.56..0.69 rows=1 width=27) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using tsc_stage_ru_itm_sl_prc_pkey on tsc_stage_ru_itm_sl_prc p (cost=0.43..0.47 rows=1 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using tsc_stage_ru_itm_sl_pkey on tsc_stage_ru_itm_sl s (cost=0.43..0.46 rows=1 width=16) (actual rows= loops=)