Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqK57-0003tg-5H for pgsql-general@arkaria.postgresql.org; Sun, 03 Feb 2019 15:53:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gqK54-0005YD-Dm for pgsql-general@arkaria.postgresql.org; Sun, 03 Feb 2019 15:53:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqK54-0005Y6-2a for pgsql-general@lists.postgresql.org; Sun, 03 Feb 2019 15:53:14 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gqK4u-0006p0-MW for pgsql-general@postgresql.org; Sun, 03 Feb 2019 15:53:12 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 4AE9211CACEEC for ; Sun, 3 Feb 2019 08:53:02 -0700 (MST) Date: Sun, 3 Feb 2019 08:53:02 -0700 (MST) From: PegoraroF10 To: pgsql-general@postgresql.org Message-ID: <1549209182255-0.post@n3.nabble.com> Subject: Server goes to Recovery Mode when run a SQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_82285_471057956.1549209182255" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_82285_471057956.1549209182255 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I have a complex query which puts my server in recovery mode every time I r= un it. I don=C2=B4t need to say that recovery mode is a situation you don=C2= =B4t want your server goes to.*If I=C2=B4m using some subselects I=C2=B4ll get that situation*with StatusTrabalhando(Intkey) as (select Intkey from sys_Lookup where Grupo =3D $$StatusDigitacao$$ and Intkey in (select unnest(string_to_array(substring(VarValue from 3),$$,$$)) from sys_Var wher= e Name =3D $$/Company/StatusDigitacaoReceptivoTrabalhando$$)),=20 StatusAgendados(Intkey) as (select Intkey from sys_Lookup where Grupo =3D $$StatusVisita$$ and Intkey in (select unnest(string_to_array(substring(VarValue from 3),$$,$$)) from sys_Var wher= e Name =3D $$/Company/StatusDigitacaoReceptivoAgendados$$) and Intkey not= in (select unnest(string_to_array(substring(VarValue from 3),$$,$$)) from sys_Var where Name =3D $$/Company/StatusDigitacaoReceptivoDescartarAgendados$$)),=20 Todos(Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesquisador_ID, Telemarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sexo, Escolaridade, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoLetivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesquisador, =20 lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado, CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Comercial= , Midia, Prioridade, DataHoraAlteracao, Fluxo)...*but if I run those subselects previously, get those values and put the results to my statement= , then it works. *with StatusDigitacaoReceptivoDescartarAgendados(Intkey) a= s (select unnest(string_to_array(substring(VarValue from 3),$$,$$)) from sys_Var where Name =3D $$/Company/StatusDigitacaoReceptivoDescartarAgendados$$), =20 StatusDigitacaoReceptivoAgendados(IntKey) as (select unnest(string_to_array(substring(VarValue from 3),$$,$$)) from sys_Var wher= e Name =3D $$/Company/StatusDigitacaoReceptivoAgendados$$), =20 StatusDigitacaoReceptivoTrabalhando(IntKey) as (select unnest(string_to_array(substring(VarValue from 3),$$,$$)) from sys_Var wher= e Name =3D $$/Company/StatusDigitacaoReceptivoTrabalhando$$)select (select IntKey from StatusDigitacaoReceptivoDescartarAgendados), (select IntKey fro= m StatusDigitacaoReceptivoAgendados), (select IntKey from StatusDigitacaoReceptivoTrabalhando);*Then i get these results (8, 14 and 17) and replace those subselects with these values and run, now it runs fine.*with StatusTrabalhando(Intkey) as (select Intkey from sys_Lookup where Grupo =3D $$StatusDigitacao$$ and Intkey in (*8*)),=20 StatusAgendados(Intkey) as (select Intkey from sys_Lookup where Grupo =3D $$StatusVisita$$ and Intkey in (*14*) and Intkey not in (*17*)),=20 Todos(Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesquisador_ID, Telemarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sexo, Escolaridade, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoLetivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesquisador, =20 lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado, CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Comercial= , Midia, Prioridade, DataHoraAlteracao, Fluxo)*My original query, which worke= d for some days and then went to recovery mode was ...*with=20 StatusTrabalhando(Intkey) as (select Intkey from sys_Lookup where Grupo =3D $$StatusDigitacao$$ and Intkey in (select unnest(string_to_array(substring(VarValue from 3),$$,$$)) from sys_Var wher= e Name =3D $$/Company/StatusDigitacaoReceptivoTrabalhando$$)),=20 StatusAgendados(Intkey) as (select Intkey from sys_Lookup where Grupo =3D $$StatusVisita$$ and Intkey in (select unnest(string_to_array(substring(VarValue from 3),$$,$$)) from sys_Var wher= e Name =3D $$/Company/StatusDigitacaoReceptivoAgendados$$) and Intkey not = in (select unnest(string_to_array(substring(VarValue from 3),$$,$$)) from sys_Var where Name =3D $$/Company/StatusDigitacaoReceptivoDescartarAgendados$$)),=20 Todos(Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesquisador_ID, Telemarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sexo, Escolaridade, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoLetivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesquisador, =20 lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado, CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Comercial= , Midia, Prioridade, DataHoraAlteracao, Fluxo);=09=09as (select D.Digitacao_I= D, D.Fonte_ID, D.Curso_ID, Digitador_ID, D.Pesquisador_ID, D.Telemarketing_ID, D.Nome, Curso.Descricao Curso, D.Telefone, D.Celular, D.Nascimento, D.Sexo, D.Escolaridade, D.Cadastro, D.Email, D.Idade, D.Obs, D.Extra1, D.Extra2= , D.Extra3, D.Extra4, D.Colegio, D.Serie, D.Turma, D.Turno, D.AnoLetivo, D.Pai, D.Mae, D.Sequencia, D.Status, Status.Descricao lkStatus, Fonte.Fonte lkFonte, DigitadorPessoa.Apelido lkDigitador, Pesquisador.Apelido lkPesquisador, Telemarketing.Login lkTelemarketing, Escolaridade.Descricao lkEscolaridade, D.Endereco, D.Bairro, D.Cidade, D.Estado, D.CEP, D.Repetido= , D.Impresso, D.Etiqueta, D.WhatsApp, PessoaNome.Nome VisitaNome, VisitaStatus.Descricao VisitaStatus, D.Comercial, Midia.Descricao, Midia.LetterKey, D.DataHoraAlteracao, case when Telemarketing_ID is Nul= l then $$N=C3=A3o Atribuido$$ when D.Status is null then $$Atribuido= $$ =20 when D.Status in (select IntKey from StatusTrabalhando) then $$Trabalhando$= $ =20 when VisitaNome.Status in (select IntKey from StatusAgendados) then $$Agendados$$ else $$Descartados$$ end Fluxofrom cad_Digitacao Dinner join cad_Fonte Fonte on Fonte.Fonte_ID =3D D.Fonte_IDinner join sys_lookup TipoFonte on TipoFonte.intkey =3D Fonte.TipoFonteleft join sys_Account Telemarketing on Telemarketing.Pessoa_ID =3D D.Telemarketing_IDleft join sys_Account Digitador on Digitador.Account_ID =3D D.Digitador_IDleft join cad_Pessoa DigitadorPessoa on Digitador.Pessoa_ID =3D DigitadorPessoa.Pessoa_IDleft join cad_Pessoa Pesquisador on Pesquisador.Pessoa_ID =3D D.Pesquisador_IDleft join col_Curso Curso on Curso.Curso_ID =3D D.Curso_IDleft join sys_Lookup Midia on Midia.Grupo =3D $$Midia$$ and Midia.IntKey =3D Fonte.Midialeft join sys_Lookup Escolaridade= on Escolaridade.Grupo =3D $$Escolaridade$$ and Escolaridade.IntKey =3D D.Escolaridadeleft join sys_Lookup Status on Status.Grupo =3D $$StatusDigitacao$$ and Status.IntKey =3D D.Statusleft join cad_visita VisitaNome on VisitaNome.Digitacao_ID =3D D.Digitacao_IDleft join sys_Looku= p VisitaStatus on VisitaStatus.Grupo =3D $$StatusVisita$$ and VisitaStatus.IntKey =3D VisitaNome.Statusleft join cad_Pessoa PessoaNome on PessoaNome.Pessoa_ID =3D VisitaNome.Pessoa_ID where TipoFonte.descricao =3D $$Campanhas$$ and Fonte.Ativo =3D 1 ), NaoAtribuidos as (select * from Tod= os where Fluxo =3D $$N=C3=A3o Atribuido$$), Atribuidos as (select * from Todo= s where Fluxo =3D $$Atribuido$$), Trabalhando as (select * from todos where Fluxo = =3D $$Trabalhando$$), Agendados as (select * from todos where Fluxo =3D $$Agendados$$), Descartados as (select * from todos where Fluxo =3D $$Descartados$$) select * from (select 1 as Ordem, Digitacao_ID, cast(Null as I32) Fonte_ID, cast(Null as I32) Curso_ID, cast(Null as I32) Digitador_ID, cast(Null as I32) Pesquisador_ID, Telemarketing_ID, Nome, cast(Null as T100) Curso, Cast(Null as Telefone) Telefone, Cast(Nul= l as Telefone) Celular, Cast(Null as Data) Nascimento, cast(Null as Sexo) as Sexo, Cast(Null as I16) Escolaridade, Cadastro, Cast(Null as T50) Email, Cast(Null as I16) Idade, Cast(Null as Memo) Obs, Cast(Null as T50) Extra1, Cast(Null as T50) Extra2, Cast(Null as T50) Extra3, Cast(Null as T50) Extra4, Cast(Null as T50) Colegio, Cast(Null as T50) Serie, Cast(Null as T50) Turma, Cast(Null as C1) Turno, Cast(Null as I16) AnoLetivo, Cast(Null as T50) Pai, Cast(Null as T50) Mae, Sequencia, Cast(Null as I16) Status, lkStatus, lkFonte, Cast(Null as T50) lkDigitador, Cast(Null as T50) lkPesquisador, lkTelemarketing, Cast(Null as T50) lkEscolaridade, Cast(Null as T50) Endereco, Cast(Null as T30) Bairro, Cast(Null as T30) Cidade, Cast(Null as Estado) Estado, Cast(Null as T10) CEP, Cast(Null as I16) Repetido, Cast(Null as DataHora) Impresso, Cast(Null as DataHora) Etiqueta, Cast(Null as I16) WhatsApp, Cast(Null as T250) VisitaNome, Cast(Null as T50) VisitaStatus, Cast(Null as Telefone) Comercial, Midia, Fluxo from NaoAtribuidos order by Ordem, Prioridade desc, Cadastro) NA union all select 2 as Ordem, Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesquisador_ID, Telemarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sexo, Escolaridade, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoLetivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesquisador, lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado, CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Comercial, Midia, Fluxo from Atribuidos union all select 3 as Ordem, Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesquisador_ID, Telemarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sexo, Escolaridade, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoLetivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesquisador, =20 lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado, CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Comercial= , Midia, Fluxo from Trabalhando union all select 4 as Ordem, Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesquisador_ID, Telemarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sexo, Escolaridade, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoLetivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesquisador, lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado, CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Comercial, Midia, Fluxo from Agendados union allselect 5 as Ordem, Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesquisador_ID, Telemarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sexo, Escolaridade, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoLetivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesquisador, =20 lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado, CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Comercial= , Midia, Fluxofrom Descartados order by Ordem;*And the explain of that query was ...*QUERY PLANSort (cost=3D2640.68..2640.84 rows=3D65 width=3D1128) S= ort Key: "*SELECT* 1".ordem CTE statustrabalhando -> Hash Semi Join=20 (cost=3D15.44..30.40 rows=3D7 width=3D4) Hash Cond: ((sys_lookup.intkey)::text =3D (unnest(string_to_array("substring"((sys_var.varvalue)::text, 3), ','::text)))) -> Bitmap Heap Scan on sys_lookup (cost=3D4.39..19= .21 rows=3D14 width=3D4) Recheck Cond: ((grupo)::text =3D 'StatusDigitacao'::text) -> Bitmap Index Scan on idxsyslookupgrupointkey (cost=3D0.00..4.38 rows=3D14 width=3D0) = =20 Index Cond: ((grupo)::text =3D 'StatusDigitacao'::text) -> Hash= =20 (cost=3D9.81..9.81 rows=3D100 width=3D32) -> ProjectSet=20 (cost=3D0.28..8.81 rows=3D100 width=3D32) -> Index Sc= an using idxsysvarname on sys_var (cost=3D0.28..8.29 rows=3D1 width=3D9) = =20 Index Cond: ((name)::text =3D '/Company/StatusDigitacaoReceptivoTrabalhando'::text) CTE statusagendados = =20 -> Hash Semi Join (cost=3D24.51..39.66 rows=3D4 width=3D4) Hash = Cond: ((sys_lookup_1.intkey)::text =3D (unnest(string_to_array("substring"((sys_var_2.varvalue)::text, 3), ','::text)))) -> Bitmap Heap Scan on sys_lookup sys_lookup_1=20 (cost=3D13.46..28.53 rows=3D8 width=3D4) Recheck Cond: ((grupo)::text =3D 'StatusVisita'::text) Filter: (NOT (hashe= d SubPlan 2)) -> Bitmap Index Scan on idxsyslookupgrupointkey= =20 (cost=3D0.00..4.40 rows=3D16 width=3D0) Index Cond: ((grupo)::text =3D 'StatusVisita'::text) SubPlan 2 = =20 -> ProjectSet (cost=3D0.28..8.81 rows=3D100 width=3D32) = =20 -> Index Scan using idxsysvarname on sys_var sys_var_1 (cost=3D0.28..8.29 rows=3D1 width=3D9) Index Cond: ((name)::text = =3D '/Company/StatusDigitacaoReceptivoDescartarAgendados'::text) ->=20 Hash (cost=3D9.81..9.81 rows=3D100 width=3D32) -> ProjectS= et=20 (cost=3D0.28..8.81 rows=3D100 width=3D32) -> Index Sc= an using idxsysvarname on sys_var sys_var_2 (cost=3D0.28..8.29 rows=3D1 width= =3D9) =20 Index Cond: ((name)::text =3D '/Company/StatusDigitacaoReceptivoAgendados'::text) CTE todos -> Merge Right Join (cost=3D2152.17..2282.99 rows=3D2504 width=3D828) Merg= e Cond: ((visitanome.digitacao_id)::integer =3D (d.digitacao_id)::integer) = ->=20 Nested Loop Left Join (cost=3D4.99..56111.59 rows=3D77463 width=3D46) = =20 -> Nested Loop Left Join (cost=3D4.69..22162.21 rows=3D77463 width=3D27) = =20 Join Filter: ((visitastatus.intkey)::integer =3D (visitanome.status)::smallint) -> Index Scan using idxvisitadigitacao on cad_visita visitanome (cost=3D0.29..3551.70 rows=3D7= 7463 width=3D10) -> Materialize (cost=3D4.40..19.43 rows= =3D16 width=3D21) -> Bitmap Heap Scan on sys_lookup visitastatus (cost=3D4.40..19.35 rows=3D16 width=3D21) = =20 Recheck Cond: ((grupo)::text =3D 'StatusVisita'::text) = =20 -> Bitmap Index Scan on idxsyslookupgrupointkey (cost=3D0.00..4.40 rows= =3D16 width=3D0) Index Cond: ((grupo)::tex= t =3D 'StatusVisita'::text) -> Index Scan using pkpessoa on cad_pessoa pessoanome (cost=3D0.29..0.44 rows=3D1 width=3D27) = =20 Index Cond: ((pessoa_id)::integer =3D (visitanome.pessoa_id)::integer) = =20 -> Sort (cost=3D2146.94..2148.64 rows=3D682 width=3D756) S= ort Key: d.digitacao_id -> Hash Left Join=20 (cost=3D1301.36..2114.84 rows=3D682 width=3D756) Hash = Cond: ((d.status)::smallint =3D (status.intkey)::integer) ->= =20 Hash Left Join (cost=3D1281.98..2081.79 rows=3D682 width=3D739) = =20 Hash Cond: ((d.escolaridade)::smallint =3D (escolaridade.intkey)::integer) = =20 -> Hash Left Join (cost=3D1263.51..2053.08 rows=3D682 width=3D722) = =20 Hash Cond: ((fonte.midia)::smallint =3D (midia.intkey)::integer) = =20 -> Hash Left Join (cost=3D1233.51..1959.83 rows=3D682 width=3D705) = =20 Hash Cond: ((d.curso_id)::integer =3D (curso.curso_id)::integer) = =20 -> Nested Loop Left Join (cost=3D1219.91..1944.43 rows=3D682 width=3D673)= =20 -> Hash Left Join (cost=3D1219.62..1411.81 rows=3D682 width=3D650) = =20 Hash Cond: ((d.telemarketing_id)::integer =3D (telemarketing.pessoa_id)::integer) = =20 -> Hash Left Join (cost=3D1213.06..1401.72 rows=3D682 width=3D639) = =20 Hash Cond: ((d.digitador_id)::integer =3D (digitador.account_id)::integer) = =20 -> Nested Loop (cost=3D29.52..215.51 rows=3D682 width=3D616) = =20 -> Hash Join (cost=3D29.24..54.61 rows=3D7 width=3D17) = =20 Hash Cond: ((fonte.tipofonte)::smallint =3D (tipofonte.intkey)::integer) = =20 -> Seq Scan on cad_fonte fonte (cost=3D0.00..24.62 rows=3D136 width=3D19)= = =20 Filter: ((ativo)::smallint =3D 1) = =20 -> Hash (cost=3D29.21..29.21 rows=3D2 width=3D4) = =20 -> Seq Scan on sys_lookup tipofonte (cost=3D0.00..29.21 rows=3D2 width=3D= 4) = =20 Filter: ((descricao)::text =3D 'Campanhas'::text) = =20 -> Index Scan using idxdigitacaofonte on cad_digitacao d (cost=3D0.29..20= .72 rows=3D227 width=3D603) = =20 Index Cond: ((fonte_id)::integer =3D (fonte.fonte_id)::integer) = =20 -> Hash (cost=3D1181.56..1181.56 rows=3D158 width=3D27) = =20 -> Nested Loop Left Join (cost=3D0.29..1181.56 rows=3D158 width=3D27) = =20 -> Seq Scan on sys_account digitador (cost=3D0.00..4.58 rows=3D158 width= =3D8) = =20 -> Index Scan using pkpessoa on cad_pessoa digitadorpessoa=20 (cost=3D0.29..7.45 rows=3D1 width=3D27) = =20 Index Cond: ((digitador.pessoa_id)::integer =3D (pessoa_id)::integer) = =20 -> Hash (cost=3D4.58..4.58 rows=3D158 width=3D15) = =20 -> Seq Scan on sys_account telemarketing (cost=3D0.00..4.58 rows=3D158 width=3D15) -> Index Scan usi= ng pkpessoa on cad_pessoa pesquisador (cost=3D0.29..0.78 rows=3D1 width=3D27)= =20 Index Cond: ((pessoa_id)::integer =3D (d.pesquisador_id)::integer) = =20 -> Hash (cost=3D11.60..11.60 rows=3D160 width=3D36) = =20 -> Seq Scan on col_curso curso (cost=3D0.00..11.60 rows=3D160 width=3D36)= =20 -> Hash (cost=3D27.06..27.06 rows=3D236 width=3D23) = =20 -> Bitmap Heap Scan on sys_lookup midia (cost=3D10.11..27.06 rows=3D236 width=3D23) Recheck Cond: ((grupo)::text =3D 'Midia'::text) = =20 -> Bitmap Index Scan on idxsyslookupgrupointkey (cost=3D0.00..10.05 rows= =3D236 width=3D0) Index Cond: ((grupo)::text =3D 'Midia'::text) -> Hash=20 (cost=3D18.34..18.34 rows=3D10 width=3D21) = ->=20 Bitmap Heap Scan on sys_lookup escolaridade (cost=3D4.36..18.34 rows=3D10 width=3D21) Recheck Cond: ((grupo)::text =3D 'Escolaridade'::text) = =20 -> Bitmap Index Scan on idxsyslookupgrupointkey (cost=3D0.00..4.35 rows= =3D10 width=3D0) Index Cond: ((grupo)::text =3D 'Escolaridade'::text) -> Hash=20 (cost=3D19.21..19.21 rows=3D14 width=3D21) -> B= itmap Heap Scan on sys_lookup status (cost=3D4.39..19.21 rows=3D14 width=3D21) = =20 Recheck Cond: ((grupo)::text =3D 'StatusDigitacao'::text) = =20 -> Bitmap Index Scan on idxsyslookupgrupointkey (cost=3D0.00..4.38 rows= =3D14 width=3D0) Index Cond: ((grupo)::tex= t =3D 'StatusDigitacao'::text) SubPlan 4 -> CTE Scan on statustrabalhando (cost=3D0.00..0.14 rows=3D7 width=3D4) SubPlan = 5 =20 -> CTE Scan on statusagendados (cost=3D0.00..0.08 rows=3D4 width=3D4) CT= E naoatribuidos -> CTE Scan on todos (cost=3D0.00..56.34 rows=3D13 width=3D1164) Filter: (fluxo =3D 'N=C3=A3o Atribuido'::text) CTE = atribuidos =20 -> CTE Scan on todos todos_1 (cost=3D0.00..56.34 rows=3D13 width=3D1164) = =20 Filter: (fluxo =3D 'Atribuido'::text) CTE trabalhando -> CTE Scan on todos todos_2 (cost=3D0.00..56.34 rows=3D13 width=3D1164) Filter:= (fluxo =3D 'Trabalhando'::text) CTE agendados -> CTE Scan on todos todos_3=20 (cost=3D0.00..56.34 rows=3D13 width=3D1164) Filter: (fluxo =3D 'Agendados'::text) CTE descartados -> CTE Scan on todos todos_4=20 (cost=3D0.00..56.34 rows=3D13 width=3D1164) Filter: (fluxo =3D 'Descartados'::text) -> Append (cost=3D1.80..3.98 rows=3D65 width=3D1128= ) =20 -> Subquery Scan on "*SELECT* 1" (cost=3D1.80..2.09 rows=3D13 width=3D112= 8) =20 -> Subquery Scan on na (cost=3D1.80..1.96 rows=3D13 width=3D1128) = =20 -> Sort (cost=3D1.80..1.83 rows=3D13 width=3D1160) = Sort Key: naoatribuidos.prioridade DESC, naoatribuidos.cadastro = =20 -> CTE Scan on naoatribuidos (cost=3D0.00..1.56 rows=3D13 width=3D1160) = =20 -> Subquery Scan on "*SELECT* 2" (cost=3D0.00..0.39 rows=3D13 width=3D112= 8) =20 -> CTE Scan on atribuidos (cost=3D0.00..0.26 rows=3D13 width=3D1128) = ->=20 Subquery Scan on "*SELECT* 3" (cost=3D0.00..0.39 rows=3D13 width=3D1128) = =20 -> CTE Scan on trabalhando (cost=3D0.00..0.26 rows=3D13 width=3D1128) = ->=20 Subquery Scan on "*SELECT* 4" (cost=3D0.00..0.39 rows=3D13 width=3D1128) = =20 -> CTE Scan on agendados (cost=3D0.00..0.26 rows=3D13 width=3D1128) = ->=20 Subquery Scan on "*SELECT* 5" (cost=3D0.00..0.39 rows=3D13 width=3D1128) = =20 -> CTE Scan on descartados (cost=3D0.00..0.26 rows=3D13 width=3D1128)*So,= how to solve that and mainly how to don=C2=B4t get this recovery mode just running= a query ?* -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.ht= ml ------=_Part_82285_471057956.1549209182255 Content-Type: text/html; charset=UTF8 Content-Transfer-Encoding: quoted-printable I have a complex query which puts my server in recovery mode every time I r= un it. I don=C2=B4t need to say that recovery mode is a situation you don= =C2=B4t want your server goes to. If I=C2=B4m using some subselects I=C2=B4ll get that situation with StatusTrabalhando(Intkey) as (select Intkey from sys_Lookup where Grupo = =3D $$StatusDigitacao$$ and=20 Intkey in (select unnest(string_to_array(substring(VarValue from 3),$$,= $$)) from sys_Var where Name =3D $$/Company/StatusDigitacaoReceptivoTrabalh= ando$$)), StatusAgendados(Intkey) as (select Intkey from sys_Lookup where Grupo =3D= $$StatusVisita$$ and=20 Intkey in (select unnest(string_to_array(substring(VarValue from 3),$$,= $$)) from sys_Var where Name =3D $$/Company/StatusDigitacaoReceptivoAgendad= os$$) and=20 Intkey not in (select unnest(string_to_array(substring(VarValue from 3)= ,$$,$$)) from sys_Var where Name =3D $$/Company/StatusDigitacaoReceptivoDes= cartarAgendados$$)), Todos(Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesquisador_ID, Tel= emarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sexo, Escolarida= de, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoLe= tivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesqui= sador, lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado, = CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Come= rcial, Midia, Prioridade, DataHoraAlteracao, Fluxo) ... but if I run those subselects previously, get those values and put the r= esults to my statement, then it works. with StatusDigitacaoReceptivoDescartarAgendados(Intkey) as (select unnest(str= ing_to_array(substring(VarValue from 3),$$,$$)) from sys_Var where Name =3D= $$/Company/StatusDigitacaoReceptivoDescartarAgendados$$), StatusDigitacaoReceptivoAgendados(IntKey) as (select unnest(string_to_ar= ray(substring(VarValue from 3),$$,$$)) from sys_Var where Name =3D $$/Compa= ny/StatusDigitacaoReceptivoAgendados$$), StatusDigitacaoReceptivoTrabalhando(IntKey) as (select unnest(string_to_= array(substring(VarValue from 3),$$,$$)) from sys_Var where Name =3D $$/Com= pany/StatusDigitacaoReceptivoTrabalhando$$) select (select IntKey from StatusDigitacaoReceptivoDescartarAgendados), (se= lect IntKey from StatusDigitacaoReceptivoAgendados), (select IntKey from St= atusDigitacaoReceptivoTrabalhando); Then i get these results (8, 14 and 17) and replace those subselects wit= h these values and run, now it runs fine. with StatusTrabalhando(Intkey) as (select Intkey from sys_Lookup where Grupo = =3D $$StatusDigitacao$$ and Intkey in (8)), StatusAgendados(Intkey) as (select Intkey from sys_Lookup where Grupo =3D= $$StatusVisita$$ and Intkey in (14) and Intkey not in (17)), Todos(Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesquisador_ID, Tel= emarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sexo, Escolarida= de, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoLe= tivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesqui= sador, lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado, = CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Come= rcial, Midia, Prioridade, DataHoraAlteracao, Fluxo) My original query, which worked for some days and then went to recovery = mode was ... with StatusTrabalhando(Intkey) as (select Intkey from sys_Lookup where Grupo = =3D $$StatusDigitacao$$ and Intkey in (select unnest(string_to_array(substring(VarValue from 3),$$,= $$)) from sys_Var where Name =3D $$/Company/StatusDigitacaoReceptivoTrabalh= ando$$)), StatusAgendados(Intkey) as (select Intkey from sys_Lookup where Grupo =3D= $$StatusVisita$$ and Intkey in (select unnest(string_to_array(substring(VarValue from 3),$$,= $$)) from sys_Var where Name =3D $$/Company/StatusDigitacaoReceptivoAgendad= os$$) and Intkey not in (select unnest(string_to_array(substring(VarValue from 3)= ,$$,$$)) from sys_Var where Name =3D $$/Company/StatusDigitacaoReceptivoDes= cartarAgendados$$)), Todos(Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesquisador_ID, Tel= emarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sexo, Escolarida= de, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoLe= tivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesqui= sador, lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado, = CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Come= rcial, Midia, Prioridade, DataHoraAlteracao, Fluxo); =09=09as (select D.Digitacao_ID, D.Fonte_ID, D.Curso_ID, Digitador_ID, D.Pe= squisador_ID, D.Telemarketing_ID, D.Nome, Curso.Descricao Curso, D.Telefone= , D.Celular, D.Nascimento, D.Sexo, D.Escolaridade, D.Cadastro, D.Email, D.I= dade, D.Obs, D.Extra1, D.Extra2, D.Extra3, D.Extra4, D.Colegio, D.Serie, D.Turma, D= .Turno, D.AnoLetivo, D.Pai, D.Mae, D.Sequencia, D.Status, Status.Descricao = lkStatus, Fonte.Fonte lkFonte, DigitadorPessoa.Apelido lkDigitador, Pesquisador.Apelido lkPesquisador, Telemarketing.Login lkTelemarketing= , Escolaridade.Descricao lkEscolaridade, D.Endereco, D.Bairro, D.Cidade, D.= Estado, D.CEP, D.Repetido, D.Impresso, D.Etiqueta, D.WhatsApp, PessoaNome.Nome VisitaNome, VisitaStatus.Descricao VisitaStatus, D.Com= ercial, Midia.Descricao, Midia.LetterKey, D.DataHoraAlteracao, case when Telemarketing_ID is Null then $$N=C3=A3o Atribuido$$ when D.Status is null then $$Atribuido$$ when D.Status in (select IntKey from StatusTrabalhando) then $$Tr= abalhando$$ when VisitaNome.Status in (select IntKey from StatusAgendados) th= en $$Agendados$$ else $$Descartados$$ end Fluxo from cad_Digitacao D inner join cad_Fonte Fonte on Fonte.Fonte_ID =3D D.Fonte_ID inner join sys_lookup TipoFonte on TipoFonte.intkey =3D Fonte.TipoFonte left join sys_Account Telemarketing on Telemarketing.Pessoa_ID =3D D.Telema= rketing_ID left join sys_Account Digitador on Digitador.Account_ID =3D D.Digitador_ID left join cad_Pessoa DigitadorPessoa on Digitador.Pessoa_ID =3D DigitadorPe= ssoa.Pessoa_ID left join cad_Pessoa Pesquisador on Pesquisador.Pessoa_ID =3D D.Pesquisador= _ID left join col_Curso Curso on Curso.Curso_ID =3D D.Curso_ID left join sys_Lookup Midia on Midia.Grupo =3D $$Midia$$ and Midia.IntKey = =3D Fonte.Midia left join sys_Lookup Escolaridade on Escolaridade.Grupo =3D $$Escolaridade$= $ and Escolaridade.IntKey =3D D.Escolaridade left join sys_Lookup Status on Status.Grupo =3D $$StatusDigitacao$$ and Sta= tus.IntKey =3D D.Status left join cad_visita VisitaNome on VisitaNome.Digitacao_ID =3D D.Digitacao_= ID left join sys_Lookup VisitaStatus on VisitaStatus.Grupo =3D $$StatusVisita$= $ and VisitaStatus.IntKey =3D VisitaNome.Status left join cad_Pessoa PessoaNome on PessoaNome.Pessoa_ID =3D VisitaNome.Pess= oa_ID where TipoFonte.descricao =3D $$Campanhas$$ and Fonte.Ativo =3D 1 ), NaoAtribuidos as (select * from Todos where Fluxo =3D $$N=C3=A3o Atribuid= o$$), Atribuidos as (select * from Todos where Fluxo =3D $$Atribuido$$), Trabalhando as (select * from todos where Fluxo =3D $$Trabalhando$$), Agendados as (select * from todos where Fluxo =3D $$Agendados$$), Descartados as (select * from todos where Fluxo =3D $$Descartados$$) select * from (select 1 as Ordem, Digitacao_ID, cast(Null as I32) Fonte_I= D, cast(Null as I32) Curso_ID, cast(Null as I32) Digitador_ID, cast(Null as= I32) Pesquisador_ID, Telemarketing_ID, Nome, cast(Null as T100) Curso, Cas= t(Null as Telefone) Telefone, Cast(Null as Telefone) Celular, Cast(Null as Data) Nascimento, cas= t(Null as Sexo) as Sexo, Cast(Null as I16) Escolaridade, Cadastro, Cast(Nul= l as T50) Email, Cast(Null as I16) Idade, Cast(Null as Memo) Obs, Cast(Null as T50) Extra1, Cast(Null as T50) Extra2, Cast(Null as T= 50) Extra3, Cast(Null as T50) Extra4, Cast(Null as T50) Colegio, Cast(Null = as T50) Serie, Cast(Null as T50) Turma, Cast(Null as C1) Turno, Cast(Null as I16) AnoLetivo, Cast(Null as T50) Pai, Cast(Null as T= 50) Mae, Sequencia, Cast(Null as I16) Status, lkStatus, lkFonte, Cast(Null = as T50) lkDigitador, Cast(Null as T50) lkPesquisador, lkTelemarketing, Cast(Null as T50) lkEscolaridade, Cast(Null as T5= 0) Endereco, Cast(Null as T30) Bairro, Cast(Null as T30) Cidade, Cast(Null = as Estado) Estado, Cast(Null as T10) CEP, Cast(Null as I16) Repetido, Cast(Null as DataHora) Impresso, Cast(Null as DataHora) Etiqueta, = Cast(Null as I16) WhatsApp, Cast(Null as T250) VisitaNome, Cast(Null as T50= ) VisitaStatus, Cast(Null as Telefone) Comercial, Midia, Fluxo from NaoAtribuidos order by Ordem, Prioridade desc, Cadastro) NA union all select 2 as Ordem, Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesqui= sador_ID, Telemarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sex= o, Escolaridade, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoL= etivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesqu= isador, lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado,= CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Com= ercial, Midia, Fluxo from Atribuidos union all select 3 as Ordem, Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesqui= sador_ID, Telemarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sex= o, Escolaridade, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoL= etivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesqu= isador, lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado,= CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Com= ercial, Midia, Fluxo from Trabalhando union all select 4 as Ordem, Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesqui= sador_ID, Telemarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sex= o, Escolaridade, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoL= etivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesqu= isador, lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado,= CEP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Com= ercial, Midia, Fluxo from Agendados union all select 5 as Ordem, Digitacao_ID, Fonte_ID, Curso_ID, Digitador_ID, Pesquisa= dor_ID, Telemarketing_ID, Nome, Curso, Telefone, Celular, Nascimento, Sexo,= Escolaridade, Cadastro, Email, Idade, Obs, Extra1, Extra2, Extra3, Extra4, Colegio, Serie, Turma, Turno, AnoLet= ivo, Pai, Mae, Sequencia, Status, lkStatus, lkFonte, lkDigitador, lkPesquis= ador, lkTelemarketing, lkEscolaridade, Endereco, Bairro, Cidade, Estado, C= EP, Repetido, Impresso, Etiqueta, WhatsApp, VisitaNome, VisitaStatus, Comer= cial, Midia, Fluxo from Descartados order by Ordem; And the explain of that query was ... QUERY PLAN Sort (cost=3D2640.68..2640.84 rows=3D65 width=3D1128) Sort Key: "*SELECT* 1".ordem CTE statustrabalhando -> Hash Semi Join (cost=3D15.44..30.40 rows=3D7 width=3D4) Hash Cond: ((sys_lookup.intkey)::text =3D (unnest(string_to_array= ("substring"((sys_var.varvalue)::text, 3), ','::text)))) -> Bitmap Heap Scan on sys_lookup (cost=3D4.39..19.21 rows=3D14= width=3D4) Recheck Cond: ((grupo)::text =3D 'StatusDigitacao'::text) -> Bitmap Index Scan on idxsyslookupgrupointkey (cost=3D0= .00..4.38 rows=3D14 width=3D0) Index Cond: ((grupo)::text =3D 'StatusDigitacao'::tex= t) -> Hash (cost=3D9.81..9.81 rows=3D100 width=3D32) -> ProjectSet (cost=3D0.28..8.81 rows=3D100 width=3D32) -> Index Scan using idxsysvarname on sys_var (cost= =3D0.28..8.29 rows=3D1 width=3D9) Index Cond: ((name)::text =3D '/Company/StatusD= igitacaoReceptivoTrabalhando'::text) CTE statusagendados -> Hash Semi Join (cost=3D24.51..39.66 rows=3D4 width=3D4) Hash Cond: ((sys_lookup_1.intkey)::text =3D (unnest(string_to_arr= ay("substring"((sys_var_2.varvalue)::text, 3), ','::text)))) -> Bitmap Heap Scan on sys_lookup sys_lookup_1 (cost=3D13.46..2= 8.53 rows=3D8 width=3D4) Recheck Cond: ((grupo)::text =3D 'StatusVisita'::text) Filter: (NOT (hashed SubPlan 2)) -> Bitmap Index Scan on idxsyslookupgrupointkey (cost=3D0= .00..4.40 rows=3D16 width=3D0) Index Cond: ((grupo)::text =3D 'StatusVisita'::text) SubPlan 2 -> ProjectSet (cost=3D0.28..8.81 rows=3D100 width=3D32) -> Index Scan using idxsysvarname on sys_var sys_v= ar_1 (cost=3D0.28..8.29 rows=3D1 width=3D9) Index Cond: ((name)::text =3D '/Company/Statu= sDigitacaoReceptivoDescartarAgendados'::text) -> Hash (cost=3D9.81..9.81 rows=3D100 width=3D32) -> ProjectSet (cost=3D0.28..8.81 rows=3D100 width=3D32) -> Index Scan using idxsysvarname on sys_var sys_var= _2 (cost=3D0.28..8.29 rows=3D1 width=3D9) Index Cond: ((name)::text =3D '/Company/StatusD= igitacaoReceptivoAgendados'::text) CTE todos -> Merge Right Join (cost=3D2152.17..2282.99 rows=3D2504 width=3D828) Merge Cond: ((visitanome.digitacao_id)::integer =3D (d.digitacao_= id)::integer) -> Nested Loop Left Join (cost=3D4.99..56111.59 rows=3D77463 wi= dth=3D46) -> Nested Loop Left Join (cost=3D4.69..22162.21 rows=3D77= 463 width=3D27) Join Filter: ((visitastatus.intkey)::integer =3D (vis= itanome.status)::smallint) -> Index Scan using idxvisitadigitacao on cad_visita= visitanome (cost=3D0.29..3551.70 rows=3D77463 width=3D10) -> Materialize (cost=3D4.40..19.43 rows=3D16 width= =3D21) -> Bitmap Heap Scan on sys_lookup visitastatus= (cost=3D4.40..19.35 rows=3D16 width=3D21) Recheck Cond: ((grupo)::text =3D 'StatusV= isita'::text) -> Bitmap Index Scan on idxsyslookupgrup= ointkey (cost=3D0.00..4.40 rows=3D16 width=3D0) Index Cond: ((grupo)::text =3D 'Sta= tusVisita'::text) -> Index Scan using pkpessoa on cad_pessoa pessoanome (co= st=3D0.29..0.44 rows=3D1 width=3D27) Index Cond: ((pessoa_id)::integer =3D (visitanome.pes= soa_id)::integer) -> Sort (cost=3D2146.94..2148.64 rows=3D682 width=3D756) Sort Key: d.digitacao_id -> Hash Left Join (cost=3D1301.36..2114.84 rows=3D682 wid= th=3D756) Hash Cond: ((d.status)::smallint =3D (status.intkey):= :integer) -> Hash Left Join (cost=3D1281.98..2081.79 rows=3D6= 82 width=3D739) Hash Cond: ((d.escolaridade)::smallint =3D (esc= olaridade.intkey)::integer) -> Hash Left Join (cost=3D1263.51..2053.08 ro= ws=3D682 width=3D722) Hash Cond: ((fonte.midia)::smallint =3D (= midia.intkey)::integer) -> Hash Left Join (cost=3D1233.51..1959= .83 rows=3D682 width=3D705) Hash Cond: ((d.curso_id)::integer = =3D (curso.curso_id)::integer) -> Nested Loop Left Join (cost=3D= 1219.91..1944.43 rows=3D682 width=3D673) -> Hash Left Join (cost=3D1= 219.62..1411.81 rows=3D682 width=3D650) Hash Cond: ((d.telemark= eting_id)::integer =3D (telemarketing.pessoa_id)::integer) -> Hash Left Join (co= st=3D1213.06..1401.72 rows=3D682 width=3D639) Hash Cond: ((d.di= gitador_id)::integer =3D (digitador.account_id)::integer) -> Nested Loop = (cost=3D29.52..215.51 rows=3D682 width=3D616) -> Hash Jo= in (cost=3D29.24..54.61 rows=3D7 width=3D17) Hash = Cond: ((fonte.tipofonte)::smallint =3D (tipofonte.intkey)::integer) -> S= eq Scan on cad_fonte fonte (cost=3D0.00..24.62 rows=3D136 width=3D19) = Filter: ((ativo)::smallint =3D 1) -> H= ash (cost=3D29.21..29.21 rows=3D2 width=3D4) = -> Seq Scan on sys_lookup tipofonte (cost=3D0.00..29.21 rows=3D2 width= =3D4) = Filter: ((descricao)::text =3D 'Campanhas'::text) -> Index S= can using idxdigitacaofonte on cad_digitacao d (cost=3D0.29..20.72 rows=3D= 227 width=3D603) Index= Cond: ((fonte_id)::integer =3D (fonte.fonte_id)::integer) -> Hash (cost= =3D1181.56..1181.56 rows=3D158 width=3D27) -> Nested = Loop Left Join (cost=3D0.29..1181.56 rows=3D158 width=3D27) -> S= eq Scan on sys_account digitador (cost=3D0.00..4.58 rows=3D158 width=3D8) -> I= ndex Scan using pkpessoa on cad_pessoa digitadorpessoa (cost=3D0.29..7.45 = rows=3D1 width=3D27) = Index Cond: ((digitador.pessoa_id)::integer =3D (pessoa_id)::integer) -> Hash (cost=3D4.58.= .4.58 rows=3D158 width=3D15) -> Seq Scan on s= ys_account telemarketing (cost=3D0.00..4.58 rows=3D158 width=3D15) -> Index Scan using pkpessoa= on cad_pessoa pesquisador (cost=3D0.29..0.78 rows=3D1 width=3D27) Index Cond: ((pessoa_id= )::integer =3D (d.pesquisador_id)::integer) -> Hash (cost=3D11.60..11.60 rows= =3D160 width=3D36) -> Seq Scan on col_curso cur= so (cost=3D0.00..11.60 rows=3D160 width=3D36) -> Hash (cost=3D27.06..27.06 rows=3D236= width=3D23) -> Bitmap Heap Scan on sys_lookup = midia (cost=3D10.11..27.06 rows=3D236 width=3D23) Recheck Cond: ((grupo)::text = =3D 'Midia'::text) -> Bitmap Index Scan on idxs= yslookupgrupointkey (cost=3D0.00..10.05 rows=3D236 width=3D0) Index Cond: ((grupo)::t= ext =3D 'Midia'::text) -> Hash (cost=3D18.34..18.34 rows=3D10 width= =3D21) -> Bitmap Heap Scan on sys_lookup escola= ridade (cost=3D4.36..18.34 rows=3D10 width=3D21) Recheck Cond: ((grupo)::text =3D 'E= scolaridade'::text) -> Bitmap Index Scan on idxsyslook= upgrupointkey (cost=3D0.00..4.35 rows=3D10 width=3D0) Index Cond: ((grupo)::text = =3D 'Escolaridade'::text) -> Hash (cost=3D19.21..19.21 rows=3D14 width=3D21) -> Bitmap Heap Scan on sys_lookup status (cos= t=3D4.39..19.21 rows=3D14 width=3D21) Recheck Cond: ((grupo)::text =3D 'StatusD= igitacao'::text) -> Bitmap Index Scan on idxsyslookupgrup= ointkey (cost=3D0.00..4.38 rows=3D14 width=3D0) Index Cond: ((grupo)::text =3D 'Sta= tusDigitacao'::text) SubPlan 4 -> CTE Scan on statustrabalhando (cost=3D0.00..0.14 rows=3D7 = width=3D4) SubPlan 5 -> CTE Scan on statusagendados (cost=3D0.00..0.08 rows=3D4 wi= dth=3D4) CTE naoatribuidos -> CTE Scan on todos (cost=3D0.00..56.34 rows=3D13 width=3D1164) Filter: (fluxo =3D 'N=C3=A3o Atribuido'::text) CTE atribuidos -> CTE Scan on todos todos_1 (cost=3D0.00..56.34 rows=3D13 width=3D11= 64) Filter: (fluxo =3D 'Atribuido'::text) CTE trabalhando -> CTE Scan on todos todos_2 (cost=3D0.00..56.34 rows=3D13 width=3D11= 64) Filter: (fluxo =3D 'Trabalhando'::text) CTE agendados -> CTE Scan on todos todos_3 (cost=3D0.00..56.34 rows=3D13 width=3D11= 64) Filter: (fluxo =3D 'Agendados'::text) CTE descartados -> CTE Scan on todos todos_4 (cost=3D0.00..56.34 rows=3D13 width=3D11= 64) Filter: (fluxo =3D 'Descartados'::text) -> Append (cost=3D1.80..3.98 rows=3D65 width=3D1128) -> Subquery Scan on "*SELECT* 1" (cost=3D1.80..2.09 rows=3D13 wid= th=3D1128) -> Subquery Scan on na (cost=3D1.80..1.96 rows=3D13 width= =3D1128) -> Sort (cost=3D1.80..1.83 rows=3D13 width=3D1160) Sort Key: naoatribuidos.prioridade DESC, naoatrib= uidos.cadastro -> CTE Scan on naoatribuidos (cost=3D0.00..1.56= rows=3D13 width=3D1160) -> Subquery Scan on "*SELECT* 2" (cost=3D0.00..0.39 rows=3D13 wid= th=3D1128) -> CTE Scan on atribuidos (cost=3D0.00..0.26 rows=3D13 widt= h=3D1128) -> Subquery Scan on "*SELECT* 3" (cost=3D0.00..0.39 rows=3D13 wid= th=3D1128) -> CTE Scan on trabalhando (cost=3D0.00..0.26 rows=3D13 wid= th=3D1128) -> Subquery Scan on "*SELECT* 4" (cost=3D0.00..0.39 rows=3D13 wid= th=3D1128) -> CTE Scan on agendados (cost=3D0.00..0.26 rows=3D13 width= =3D1128) -> Subquery Scan on "*SELECT* 5" (cost=3D0.00..0.39 rows=3D13 wid= th=3D1128) -> CTE Scan on descartados (cost=3D0.00..0.26 rows=3D13 wid= th=3D1128) So, how to solve that and mainly how to don=C2=B4t get this recovery mod= e just running a query ? =09 =09 =09
Sent from the PostgreSQL - general mailing list archive at Nabble.c= om.
------=_Part_82285_471057956.1549209182255--