Enviado em 09/09/2019 - 09:48h
Bom dia,select paciente0_.i_paciente as col_0_0_,
paciente0_.cns as col_1_0_,
pessoa1_.nome as col_2_0_
from saude.pacientes paciente0_
left outer join
global.pessoas pessoa1_ on paciente0_.i_pessoa = pessoa1_.i_pessoa
left outer join
global.entidades entidade2_ on pessoa1_.i_entidade = entidade2_.i_entidade
where (
retira_acentuacao(lower(pessoa1_.nome)) like '%jh%'
)
and retira_acentuacao(lower(entidade2_.chave_publica)) = 'fb5t'
order by paciente0_.i_paciente
limit 10
[
{
"Plan": {
"Node Type": "Limit",
"Parallel Aware": false,
"Startup Cost": 0.84,
"Total Cost": 417.20,
"Plan Rows": 10,
"Plan Width": 46,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 0.84,
"Total Cost": 64870.16,
"Plan Rows": 1558,
"Plan Width": 46,
"Inner Unique": true,
"Join Filter": "(pessoa1_.i_entidade = entidade2_.i_entidade)",
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 0.84,
"Total Cost": 64471.47,
"Plan Rows": 26493,
"Plan Width": 54,
"Inner Unique": true,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "pacientes_pkey",
"Relation Name": "pacientes",
"Alias": "paciente0_",
"Startup Cost": 0.42,
"Total Cost": 3526.54,
"Plan Rows": 132466,
"Plan Width": 32
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "pessoas_pkey",
"Relation Name": "pessoas",
"Alias": "pessoa1_",
"Startup Cost": 0.42,
"Total Cost": 0.46,
"Plan Rows": 1,
"Plan Width": 38,
"Index Cond": "(i_pessoa = paciente0_.i_pessoa)",
"Filter": "(translate(lower((nome)::text), 'áàâãäåaaaÁÂÃÄÅAAAÀéèêëeeeee&EEEÉEEÈìíîïìiiiÌÍÎÏÌIIIóôõöoooòÒÓÔÕÖOOOùúûüuuuuÙÚÛÜUUUUçÇñÑýÝ'::text, 'aaaaaaaaaAAAAAAAAAeeeeeeeeeeEEEEEEEiiiiiiiiIIIIIIIIooooooooOOOOOOOOuuuuuuuuUUUUUUUUcCnNyY'::text) ~~ '%jh%'::text)"
}
]
},
{
"Node Type": "Materialize",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 0.00,
"Total Cost": 1.30,
"Plan Rows": 1,
"Plan Width": 8,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Relation Name": "entidades",
"Alias": "entidade2_",
"Startup Cost": 0.00,
"Total Cost": 1.30,
"Plan Rows": 1,
"Plan Width": 8,
"Filter": "(translate(lower((chave_publica)::text), 'áàâãäåaaaÁÂÃÄÅAAAÀéèêëeeeee&EEEÉEEÈìíîïìiiiÌÍÎÏÌIIIóôõöoooòÒÓÔÕÖOOOùúûüuuuuÙÚÛÜUUUUçÇñÑýÝ'::text, 'aaaaaaaaaAAAAAAAAAeeeeeeeeeeEEEEEEEiiiiiiiiIIIIIIIIooooooooOOOOOOOOuuuuuuuuUUUUUUUUcCnNyY'::text) = 'fb5t'::text)"
}
]
}
]
}
]
}
}
]
[
{
"Plan": {
"Node Type": "Sort",
"Parallel Aware": false,
"Startup Cost": 4593.96,
"Total Cost": 4597.86,
"Plan Rows": 1558,
"Plan Width": 46,
"Sort Key": ["paciente0_.i_paciente"],
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 2064.48,
"Total Cost": 4511.34,
"Plan Rows": 1558,
"Plan Width": 46,
"Inner Unique": true,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 2064.06,
"Total Cost": 3683.70,
"Plan Rows": 1671,
"Plan Width": 30,
"Inner Unique": false,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Relation Name": "entidades",
"Alias": "entidade2_",
"Startup Cost": 0.00,
"Total Cost": 1.30,
"Plan Rows": 1,
"Plan Width": 8,
"Filter": "(translate(lower((chave_publica)::text), 'áàâãäåaaaÁÂÃÄÅAAAÀéèêëeeeee&EEEÉEEÈìíîïìiiiÌÍÎÏÌIIIóôõöoooòÒÓÔÕÖOOOùúûüuuuuÙÚÛÜUUUUçÇñÑýÝ'::text, 'aaaaaaaaaAAAAAAAAAeeeeeeeeeeEEEEEEEiiiiiiiiIIIIIIIIooooooooOOOOOOOOuuuuuuuuUUUUUUUUcCnNyY'::text) = 'fb5t'::text)"
},
{
"Node Type": "Bitmap Heap Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Relation Name": "pessoas",
"Alias": "pessoa1_",
"Startup Cost": 2064.06,
"Total Cost": 3664.64,
"Plan Rows": 1776,
"Plan Width": 38,
"Recheck Cond": "(i_entidade = entidade2_.i_entidade)",
"Filter": "(translate(lower((nome)::text), 'áàâãäåaaaÁÂÃÄÅAAAÀéèêëeeeee&EEEÉEEÈìíîïìiiiÌÍÎÏÌIIIóôõöoooòÒÓÔÕÖOOOùúûüuuuuÙÚÛÜUUUUçÇñÑýÝ'::text, 'aaaaaaaaaAAAAAAAAAeeeeeeeeeeEEEEEEEiiiiiiiiIIIIIIIIooooooooOOOOOOOOuuuuuuuuUUUUUUUUcCnNyY'::text) ~~ '%jh%'::text)",
"Plans": [
{
"Node Type": "Bitmap Index Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Index Name": "idx_paciente_entidade_nome",
"Startup Cost": 0.00,
"Total Cost": 2063.61,
"Plan Rows": 8879,
"Plan Width": 0,
"Index Cond": "(i_entidade = entidade2_.i_entidade)"
}
]
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "uka5u1krnjq1ycjebf0j5vcac0b",
"Relation Name": "pacientes",
"Alias": "paciente0_",
"Startup Cost": 0.42,
"Total Cost": 0.50,
"Plan Rows": 1,
"Plan Width": 32,
"Index Cond": "(i_pessoa = pessoa1_.i_pessoa)"
}
]
}
]
}
}
]
DOOM clássico (quase) vanilla e um pouco melhorado
Mamãe, quero descompactar e também compactar arquivos no terminal!
Warped Tentacles para Doom Clássico
Conheça a extensão Just Perfection para mudar várias opções do Gnome
Desligando ou reiniciando o Gnome rapidinho
Dois Linux numa maquina só (6)
Como ter permissão para inserir ficheiros no nextcloud usando usuário ... (5)
ZORIN 17.1_MACBOOK PRO 2011 - Monitor secundário sem imagem/sem sinal ... (1)
Problemas ao atualizar Flatpak no Linux Mint [RESOLVIDO] (1)