explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lTa5

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,407,602.376 ↓ 0.0 0 1

Insert on tsc_stage_id_ps (cost=1.13..9,200,284.45 rows=1 width=49) (actual time=2,407,602.376..2,407,602.376 rows=0 loops=1)

  • Merge Cond: ((a.id_bsngp = c.id_bsngp) AND (a.id_itm_ps_qfr = c.id_itm_ps_qfr) AND ((a.id_itm_ps)::text = (c.id_itm_ps)::text))
  • Heap Fetches: 0
2. 2,405,576.060 2,405,576.060 ↓ 170,553.0 170,553 1

Merge Anti Join (cost=1.13..9,200,284.45 rows=1 width=49) (actual time=630.801..2,405,576.060 rows=170,553 loops=1)

3. 2,297,652.263 2,297,652.263 ↓ 1.0 61,707,607 1

Index Scan using tsc_import_id_ps_pkey on tsc_import_id_ps a (cost=0.56..4,314,325.75 rows=61,706,792 width=33) (actual time=0.005..2,297,652.263 rows=61,707,607 loops=1)

4. 26,616.426 26,616.426 ↑ 1.0 88,147,151 1

Index Only Scan using id_ps_pkey on id_ps c (cost=0.57..3,117,476.81 rows=88,214,416 width=18) (actual time=0.023..26,616.426 rows=88,147,151 loops=1)

Planning time : 45.623 ms