explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KVre

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

Insert on tsc_stage_as_bsngp_itm_ext (cost=1.69..5,711,473.60 rows=1 width=33) (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_alt)::text = (c.id_gp_tx_alt)::text)
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.69..5,711,473.60 rows=1 width=33) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=1.13..5,711,472.95 rows=1 width=25) (actual rows= loops=)

4. 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=25) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using as_bsngp_itm_ext_pkey on as_bsngp_itm_ext c (cost=0.56..2,719,928.04 rows=40,478,692 width=25) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Only Scan using as_bsngp_itm_pkey on as_bsngp_itm b (cost=0.56..0.63 rows=1 width=19) (actual rows= loops=)