explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bBuY

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

Limit (cost=3.27..3.27 rows=1 width=2,530) (actual time=0.046..0.046 rows=0 loops=1)

  • +-Sort (cost=3.27..3.27 rows=1 width=2,530) (actual time=0.045..0.045 rows=0 loops=1) Sort Key: gmms.jt_comp_cd Sort Method: quicksort Memory: 25kB
  • +-Nested Loop Left Join (cost=1.21..3.26 rows=1 width=2,530) (actual time=0.038..0.038 rows=0 loops=1) Join Filter: ((gmebs.locale_id)::text = (gmms.locale_id)::text)
  • +-Hash Right Join (cost=1.07..2.33 rows=1 width=2,482) (actual time=0.038..0.038 rows=0 loops=1) Hash Cond: (((gmktrh.comp_cd)::text = (gmms.jt_comp_cd)::text) AND ((gmktrh.control_accounts_cd)::text = (gmms.control_accounts_cd)::text))
  • | +-Hash (cost=1.06..1.06 rows=1 width=2,264) (actual time=0.035..0.035 rows=0 loops=1) Buckets: 1,024 Batches: 1 Memory Usage: 8kB
  • | +-Seq Scan on gha_m_mdm_shs gmms (cost=0.00..1.06 rows=1 width=2,264) (actual time=0.035..0.035 rows=0 loops=1) Filter: (((sire_cd)::text = ''::text) AND ((del_flg)::text = '0'::text)) Rows Removed by Filter: 4
  • +-Index Scan using "PK_ghb_m_enqt_basis_set" on ghb_m_enqt_basis_set gmebs (cost=0.13..0.91 rows=1 width=204) (never executed) Index Cond: ((risk_hk_type_cd)::text = (gmktrh.risk_type)::text)
2. 0.000 0.000 ↓ 0.0 0

| +-Seq Scan on ghg_m_ks_tskj_rk_hz gmktrh (cost=0.00..1.17 rows=17 width=494) (never executed)

Planning time : 2.700 ms
Execution time : 0.075 ms