explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hGTI

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.156 ↓ 0.0 0 1

Insert on tempe (cost=13,913.13..13,923.33 rows=371 width=8) (actual time=0.156..0.156 rows=0 loops=1)

2. 0.007 0.149 ↓ 0.0 0 1

GroupAggregate (cost=13,913.13..13,919.62 rows=371 width=8) (actual time=0.149..0.149 rows=0 loops=1)

  • Group Key: ak.idx_slot
3. 0.049 0.142 ↓ 0.0 0 1

Sort (cost=13,913.13..13,914.06 rows=371 width=8) (actual time=0.141..0.142 rows=0 loops=1)

  • Sort Key: ak.idx_slot
  • Sort Method: quicksort Memory: 25kB
4. 0.054 0.093 ↓ 0.0 0 1

Hash Join (cost=986.06..13,897.30 rows=371 width=8) (actual time=0.093..0.093 rows=0 loops=1)

  • Hash Cond: (dk.datefin = mivir.dateder)
5. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=918.68..13,813.69 rows=39 width=12) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=918.40..13,801.69 rows=39 width=8) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=917.98..4,256.17 rows=1 width=4) (never executed)

  • Hash Cond: (((ak.node)::text = (bk.node)::text) AND ((ak.slot)::text = (bk.slot)::text) AND ((ak.mktg_m)::text = (bk.mktg_m)::text) AND ((ak.serial_m)::text = (bk.serial_m)::text) AND ((ak.numero)::text = (bk.numero)::text) AND ((ak.module)::text = (bk.module)::text) AND ((ak.serial_f)::text = (bk.serial_f)::text) AND ((ak.mktg_f)::text = (bk.mktg_f)::text) AND ((ak.eng_num_f)::text = (bk.eng_num_f)::text) AND ((ak.codeq_f)::text = (bk.codeq_f)::text))
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on invent_msp_seep ak (cost=0.00..888.61 rows=32,661 width=102) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Hash (cost=401.55..401.55 rows=14,755 width=100) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on tempa bk (cost=0.00..401.55 rows=14,755 width=100) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using invent_msp_cliaisons_adx_iterc_adx_slot_idx on invent_msp_cliaisons ck (cost=0.43..9,545.06 rows=46 width=8) (never executed)

  • Index Cond: (adx_slot = ak.idx_slot)
  • Heap Fetches: 0
12. 0.000 0.000 ↓ 0.0 0

Index Scan using interval_mspc_idx_iterc_key on interval_mspc dk (cost=0.28..0.30 rows=1 width=8) (never executed)

  • Index Cond: (idx_iterc = ck.adx_iterc)
13. 0.000 0.039 ↓ 0.0 0 1

Hash (cost=35.50..35.50 rows=2,550 width=4) (actual time=0.039..0.039 rows=0 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 32kB
14. 0.039 0.039 ↓ 0.0 0 1

Seq Scan on mivir (cost=0.00..35.50 rows=2,550 width=4) (actual time=0.039..0.039 rows=0 loops=1)