explain.depesz.com

A tool for finding a real cause for slow queries.

Result: M7S

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 105.427 305.539 ↓ 8.1 129,140 1

Nested Loop (cost=0.00..10,272.35 rows=15,990 width=49) (actual time=0.147..305.539 rows=129,140 loops=1)

2. 0.042 0.042 ↑ 1.0 39 1

Seq Scan on gkclstb (cost=0.00..1.39 rows=39 width=53) (actual time=0.004..0.042 rows=39 loops=1)

3. 200.070 200.070 ↓ 4.8 3,311 39

Index Scan using gkclmtb_cazi_ccmp_ciden_ccat_clscodi on gkclmtb (cost=0.00..245.76 rows=691 width=56) (actual time=0.075..5.130 rows=3,311 loops=39)

  • Index Cond: (((gkclmtb.clm_cazicazi)::text = (gkclstb.cls_cazicazi)::text) AND ((gkclmtb.clm_ccmpccmp)::text = (gkclstb.cls_ccmpccmp)::text) AND (gkclmtb.clm_npdciden = gkclstb.cls_npdciden) AND ((gkclmtb.clm_ccatccat)::text = (gkclstb.cls_ccatccat)::text) AND ((gkclmtb.clm_cclscodi)::text = (gkclstb.cls_cclscodi)::text))