E ai galera, estou com uma demora nesta consulta abaixa
Tenho alguma coisa que possa ser melhorado de acordo com o explain?
"Nested Loop (cost=0.00..114.69 rows=1 width=20) (actual
time=1.251..7335.952 rows=5493 loops=1)"
" -> Nested Loop (cost=0.00..27.23 rows=1 width=24) (actual
time=0.826..371.070 rows=5493 loops=1)"
" -> Nested Loop (cost=0.00..22.64 rows=1 width=31) (actual
time=0.689..162.554 rows=5493 loops=1)"
" -> Nested Loop (cost=0.00..16.52 rows=1 width=40) (actual
time=0.535..105.706 rows=5494 loops=1)"
" -> Nested Loop (cost=0.00..12.17 rows=1 width=30)
(actual time=0.372..34.648 rows=5494 loops=1)"
" -> Index Scan using basffcalculos_pkey on
basffcalculos basffc (cost=0.00..7.82 rows=1 width=20) (actual
time=0.214..5.705 rows=1001 loops=1)"
" Index Cond: ((seqexercicio = 2008) AND
(seqcontrolcalc = 16) AND (seqdecalculo <= 1000))"
" -> Index Scan using basffparcelasdocalculo_pkey
on basffparcelasdocalculo basffpc (cost=0.00..4.34 rows=1 width=20) (actual
time=0.013..0.023 rows=5 loops=1001)"
" Index Cond: ((2008 = basffpc.seqexercicio)
AND (basffpc.codsistema = "outer".codsistema) AND (16 =
basffpc.seqcontrolcalc) AND (basffpc.seqdecalculo = "outer".seqdecalculo))"
" -> Index Scan using basffsacadodocalculo_pkey on
basffsacadodocalculo basffsc (cost=0.00..4.34 rows=1 width=20) (actual
time=0.010..0.011 rows=1 loops=5494)"
" Index Cond: ((2008 = basffsc.seqexercicio) AND
(basffsc.codsistema = "outer".codsistema) AND (16 = basffsc.seqcontrolcalc)
AND (basffsc.seqdecalculo = "outer".seqdecalculo))"
" -> Index Scan using issffcalculo_pkey on issffcalculo issffc
(cost=0.00..6.08 rows=2 width=31) (actual time=0.008..0.008 rows=1
loops=5494)"
" Index Cond: ((2008 = issffc.seqexercicio) AND
(issffc.codsistema = "outer".codsistema) AND (16 = issffc.seqcontrolcalc)
AND (issffc.seqdecalculo = "outer".seqdecalculo))"
" -> Index Scan using idx_issinscricacaocadastral on
issinscricaocadastral issic (cost=0.00..4.58 rows=1 width=14) (actual
time=0.035..0.036 rows=1 loops=5493)"
" Index Cond: ((issic.numinscricaocadastral)::text =
("outer".inscrcadastral)::text)"
" Filter: (idexclusao = 0)"
" -> Index Scan using idx_isscadastrocontribuintes on
isscadastrocontribuintes isscc (cost=0.00..87.46 rows=1 width=4) (actual
time=0.499..1.266 rows=1 loops=5493)"
" Index Cond: (isscc.seqcontribuinte = "outer".seqcontribuinte)"
" Filter: (idexclusao = 0)"
"Total runtime: 7337.988 ms"
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
