#	exclusive	inclusive	rows x	rows	loops	node
1.	105.427	305.539	↓ 8.1	129140	1	→ Nested Loop (cost=0.00..10272.35 rows=15990 width=49) (actual time=0.147..305.539 rows=129140 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	3311	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=3311 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))

"Nested Loop  (cost=0.00..10272.35 rows=15990 width=49) (actual time=0.147..305.539 rows=129140 loops=1)"
"  ->  Seq Scan on gkclstb  (cost=0.00..1.39 rows=39 width=53) (actual time=0.004..0.042 rows=39 loops=1)"
"  ->  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=3311 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))"
"Total runtime: 337.248 ms"

Per node type stats

node type	count	sum of times	% of query
Index Scan	1	200.070 ms	65.5 %
Nested Loop	1	105.427 ms	34.5 %
Seq Scan	1	0.042 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
gkclmtb	1	200.070 ms	65.5 %
Index Scan	1	200.070 ms	100.0 %
gkclstb	1	0.042 ms	0.0 %
Seq Scan	1	0.042 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: M7S

Colorize:

Columns visibility:

Per node type stats

Per table stats