{"id":26013,"date":"2023-02-03T21:58:12","date_gmt":"2023-02-03T21:58:12","guid":{"rendered":"https:\/\/building.nubank.com\/leveraging-datomic-query-stats-to-optimize-clause-ordering\/"},"modified":"2024-03-21T17:30:27","modified_gmt":"2024-03-21T17:30:27","slug":"como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas","status":"publish","type":"post","link":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/","title":{"rendered":"Como usar estat\u00edsticas de consulta do Datomic para Otimizar Ordem de Cl\u00e1usulas"},"content":{"rendered":"\n

Escrito por: Keith Harper<\/em>
Revisado por: Robert Randolph, Jarrod Taylor<\/em><\/p>\n\n\n\n

\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Como escritor de uma consulta Datomic<\/a>, voc\u00ea tem o controle sobre a ordem de cl\u00e1usulas de consulta, o que pode ser muito eficiente se voc\u00ea tiver informa\u00e7\u00f5es suficientes para ordenar cl\u00e1usulas de consulta com prioridade da maior para a menor. Algumas medidas de seletividade de cl\u00e1usulas s\u00e3o a quantidade de linhas fluindo para dentro e fora de cada cl\u00e1usula, assim como a finitude de vari\u00e1veis l\u00f3gicas usadas por cada cl\u00e1usula. As informa\u00e7\u00f5es retornadas pelas estat\u00edsticas de consulta podem apresentar essas medidas e serem usadas para tomar uma decis\u00e3o informada sobre a ordena\u00e7\u00e3o de cl\u00e1usulas.<\/p>\n\n\n\n

Usaremos o reposit\u00f3rio do banco de dados de exemplo do MusicBrainz<\/a> para todos os exemplos neste artigo. Para um breve tutorial sobre como executar o Datomic localmente com o banco de dados de exemplo do MusicBrainz<\/a>, clique em LEIA-ME<\/a>.<\/p>\n\n\n\n

Usaremos estat\u00edsticas de consulta para obter o estado \u201cdepois\u201d, representado na imagem acima, definindo o conjunto de resultados intermedi\u00e1rio como o menor poss\u00edvel entre as cl\u00e1usulas.<\/p>\n\n\n\n

Como solicitar estat\u00edsticas de consulta<\/h2>\n\n\n\n

Come\u00e7ando na vers\u00e3o v1.0.6610 do Datomic On-Prem<\/a>,que ser\u00e1 lan\u00e7ada em breve para o Datomic Cloud, os usu\u00e1rios agora podem solicitar estat\u00edsticas de consulta enquanto fazem uma consulta.<\/p>\n\n\n\n

Para executar uma consulta enquanto se acumula estat\u00edsticas de consulta, precisaremos usar datomic.api\/query<\/a> e fornecer \u201c:query-stats true\u201d no argumento de mapa de consulta.<\/p>\n\n\n\n

Algumas partes das estat\u00edsticas de consulta ser\u00e3o explicadas com mais detalhes nas pr\u00f3ximas se\u00e7\u00f5es. Para mais informa\u00e7\u00f5es, consulte a documenta\u00e7\u00e3o de usu\u00e1rio para estat\u00edsticas de consulta<\/a>.<\/p>\n\n\n\n

Cen\u00e1rio: usar estat\u00edsticas de consulta durante a otimiza\u00e7\u00e3o de ordem de cl\u00e1usulas<\/h2>\n\n\n\n

Neste cen\u00e1rio, vamos trabalhar com estat\u00edsticas de consulta para guiar nosso processo de avalia\u00e7\u00e3o enquanto buscamos uma ordena\u00e7\u00e3o ideal de cl\u00e1usulas.<\/p>\n\n\n\n

Vamos fazer uma consulta que encontrar\u00e1 \u00e1lbuns lan\u00e7ados antes de 1970, nos quais pelo menos um dos artistas seja o John Lennon<\/a>, e depois revelar o nome do \u00e1lbum e o ano de lan\u00e7amento.<\/p>\n\n\n\n

<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
{<\/span>:query       '<\/span>{<\/span>:find  <\/span>[<\/span>?album-name ?year<\/span>]<\/span><\/span>\n                :in    <\/span>[<\/span>$ ?artist-name<\/span>]<\/span><\/span>\n                :where <\/span>[[<\/span>?artist :artist\/name ?artist-name<\/span>]<\/span><\/span>\n                        <\/span>[<\/span>?release :release\/artists ?artist<\/span>]<\/span><\/span>\n                        <\/span>[<\/span>?release :release\/name ?album-name<\/span>]<\/span><\/span>\n                        <\/span>[<\/span>?release :release\/year ?year<\/span>]<\/span><\/span>\n                        <\/span>[(<\/span><<\/span> ?year <\/span>1970<\/span>)]]}<\/span><\/span>\n :args        <\/span>[<\/span>db <\/span>"<\/span>John Lennon<\/span>"<\/span>]<\/span><\/span>\n :query-stats <\/span>true<\/span>}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
:phases<\/h2>\n\n\n\n
Cada item abaixo de \u201c.phases\u201d representa um conjunto de cl\u00e1usulas que ser\u00e3o processadas como uma \u00fanica unidade de trabalho. Costuma existir apenas um \u00fanico item para a maioria das consultas, mas algumas delas ter\u00e3o v\u00e1rios itens sob \u201c:phases\u201d (por exemplo: os que usam regras de consulta<\/a>)<\/p>\n\n\n\n
:sched<\/h2>\n\n\n\n
\u201c:sched\u201d \u00e9 a abrevia\u00e7\u00e3o de \u201cschedule\u201d (cronograma, em ingl\u00eas), e representa o plano aproximado que a ferramenta de consulta usar\u00e1 ao processar esta consulta:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
(([(<\/span>ground<\/span> $__in__2<\/span>)<\/span> ?artist-name<\/span>]<\/span><\/span>\n  <\/span>[<\/span>?artist :artist\/name ?artist-name<\/span>]<\/span><\/span>\n  <\/span>[<\/span>?release :release\/artists ?artist<\/span>]<\/span><\/span>\n  <\/span>[<\/span>?release :release\/name ?album-name<\/span>]<\/span><\/span>\n  <\/span>[<\/span>?release :release\/year ?year<\/span>]<\/span><\/span>\n  <\/span>[(<\/span><<\/span> ?year <\/span>1970<\/span>)]))<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Perceba que h\u00e1 uma cl\u00e1usula de consulta extra no cronograma que n\u00e3o estava no conjunto de cl\u00e1usulas que fornecemos para \u201c.where\u201d. \u201c[(ground<\/em><\/strong> $__in__2<\/strong>) ?artist-name<\/strong>]\u201d \u00e9 como o valor (John Lennon) e a vari\u00e1vel l\u00f3gica (\u201c?artist-name\u201d) passados para \u201c:in\u201d se vinculam \u00e0 ferramenta de consulta.<\/p>\n\n\n\n
:clauses<\/h2>\n\n\n\n
\u201c:clauses\u201d cont\u00e9m as cl\u00e1usulas de consulta feitas para esta fase:<\/p>\n\n\n\n
clause<\/td>rows-in<\/td>rows-out<\/td>binds-in<\/td>binds-out<\/td>expansion<\/td>preds<\/td><\/tr>
[(ground<\/em><\/strong> $__in__2<\/strong>) ?artist-name<\/strong>]<\/td>0<\/strong><\/td>1<\/strong><\/td>()<\/td>[?artist-name<\/strong>]<\/td>1<\/strong><\/td><\/td><\/tr>
[?artist<\/strong> :artist\/name ?artist-name<\/strong>]<\/td>1<\/strong><\/td>1<\/strong><\/td>[?artist-name<\/strong>]<\/td>[?artist<\/strong>]<\/td><\/td><\/td><\/tr>
[?release <\/strong>:release\/artists ?artist<\/strong>]<\/td>1<\/strong><\/td>21<\/strong><\/td>[?artist<\/strong>]<\/td>[?release<\/strong>]<\/td>20<\/strong><\/td><\/td><\/tr>
[?release <\/strong>:release\/name ?album-name<\/strong>]<\/td>21<\/strong><\/td>21<\/strong><\/td>[?release<\/strong>]<\/td>[?album-name<\/strong> ?release<\/strong>]<\/td><\/td><\/td><\/tr>
[?release <\/strong>:release\/year ?year<\/strong>]<\/td>21<\/strong><\/td>3<\/strong><\/td>[?album-name<\/strong> ?release<\/strong>]<\/td>[?year<\/strong> ?album-name<\/strong>]<\/td><\/td>([(< ?year<\/strong> 1970<\/strong>)])<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
A tabela acima pode facilitar a interpreta\u00e7\u00e3o das estat\u00edsticas de consulta para cl\u00e1usulas. Perceba como \u201c:rows-in\u201d e \u201c:binds-in\u201d para uma cl\u00e1usula correspondem diretamente a \u201c:rows-out\u201d e \u201c:binds-out\u201d da cl\u00e1usula anterior.<\/p>\n\n\n\n
Cl\u00e1usula 1<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
{<\/span>:clause    <\/span>[(<\/span>ground<\/span> $__in__2<\/span>)<\/span> ?artist-name<\/span>]<\/span>,<\/span><\/span>\n :rows-in   <\/span>0<\/span>,<\/span><\/span>\n :rows-out  <\/span>1<\/span>,<\/span><\/span>\n :binds-in  <\/span>()<\/span>,<\/span><\/span>\n :binds-out <\/span>[<\/span>?artist-name<\/span>]<\/span>,<\/span><\/span>\n :expansion <\/span>1<\/span>}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
Ressaltando, essa cl\u00e1usula representa apenas o v\u00ednculo do valor e da vari\u00e1vel l\u00f3gica passados para \u201c.in\u201d.<\/p>\n\n\n\n
\u201c:rows-in 0\u201d indica que n\u00e3o havia linhas no resultado definido antes do processamento da cl\u00e1usula. <\/p>\n\n\n\n
\u201c:rows-out 1\u201d indica que o resultado definido agora tem 1 cl\u00e1usula presente, que cont\u00e9m o v\u00ednculo indicado por \u201c:binds-out [?artist-name]\u201d.
\u201c:expansion 1\u201d significa apenas que \u201c:rows-out\u201d aumentou de tamanho em 1 linha, ap\u00f3s o processamento dessa cl\u00e1usula.<\/p>\n\n\n\n
Cl\u00e1usula 2<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
{<\/span>:clause    <\/span>[<\/span>?artist :artist\/name ?artist-name<\/span>]<\/span>,<\/span><\/span>\n :rows-in   <\/span>1<\/span>,<\/span><\/span>\n :rows-out  <\/span>1<\/span>,<\/span><\/span>\n :binds-in  <\/span>[<\/span>?artist-name<\/span>]<\/span>,<\/span><\/span>\n :binds-out <\/span>[<\/span>?artist<\/span>]}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
Perceba que \u201c:binds-out\u201d n\u00e3o tem mais \u201c?artist-name\u201d, mas tem um novo v\u00ednculo de \u201c?artist\u201d. Isso acontece porque a ferramenta de consulta pode ver as cl\u00e1usulas que ser\u00e3o processadas depois dessa, e nenhuma delas usa \u201c?artist-name\u201d. Assim, ela pode ser removida dos resultados sem problemas.<\/p>\n\n\n\n
Cl\u00e1usula 3<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
{<\/span>:clause    <\/span>[<\/span>?release :release\/artists ?artist<\/span>]<\/span>,<\/span><\/span>\n :rows-in   <\/span>1<\/span>,<\/span><\/span>\n :rows-out  <\/span>21<\/span>,<\/span><\/span>\n :binds-in  <\/span>[<\/span>?artist<\/span>]<\/span>,<\/span><\/span>\n :binds-out <\/span>[<\/span>?release<\/span>]<\/span>,<\/span><\/span>\n :expansion <\/span>20<\/span>}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
Agora chegamos \u00e0 primeira cl\u00e1usula que apresenta uma expans\u00e3o real do conjunto de resultados. As estat\u00edsticas de consulta para esta cl\u00e1usula indicam que foram encontrados 21 lan\u00e7amentos, entre os quais John Lennon estava envolvido.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
Cl\u00e1usula 4<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
{<\/span>:clause    <\/span>[<\/span>?release :release\/name ?album-name<\/span>]<\/span>,<\/span><\/span>\n :rows-in   <\/span>21<\/span>,<\/span><\/span>\n :rows-out  <\/span>21<\/span>,<\/span><\/span>\n :binds-in  <\/span>[<\/span>?release<\/span>]<\/span>,<\/span><\/span>\n :binds-out <\/span>[<\/span>?album-name ?release<\/span>]}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
Esta cl\u00e1usula introduz novos valores ao conjunto de resultados, como indicado pela diferen\u00e7a entre os v\u00ednculos de entrada e de sa\u00edda. Apesar disso, a quantidade de linhas no conjunto de resultados n\u00e3o aumenta. O que voc\u00ea acha que aconteceria se transform\u00e1ssemos essa \u00faltima cl\u00e1usula em nossas cl\u00e1usulas \u201c.where\u201d?<\/p>\n\n\n\n
Cl\u00e1usula 5<\/h2>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
{<\/span>:clause    <\/span>[<\/span>?release :release\/year ?year<\/span>]<\/span>,<\/span><\/span>\n :rows-in   <\/span>21<\/span>,<\/span><\/span>\n :rows-out  <\/span>3<\/span>,<\/span><\/span>\n :binds-in  <\/span>[<\/span>?album-name ?release<\/span>]<\/span>,<\/span><\/span>\n :binds-out <\/span>[<\/span>?album-name ?year<\/span>]<\/span>,<\/span><\/span>\n :preds     <\/span>([(<\/span><<\/span> ?year <\/span>1970<\/span>)])}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
A \u00faltima cl\u00e1usula limita bastante o conjunto de resultados e mostra informa\u00e7\u00f5es que ainda n\u00e3o estavam presentes: \u201c:preds\u201d. A presen\u00e7a de uma entrada \u201c:preds\u201d indica que as cl\u00e1usulas correspondentes foram usadas como predicados de filtro enquanto buscavam respostas para \u201c[?release<\/strong> :release\/year ?year<\/strong>]\u201d.<\/p>\n\n\n\n
Agora vamos conferir o que aconteceria se mov\u00eassemos a cl\u00e1usula 4 at\u00e9 o fim das nossas cl\u00e1usulas \u201c:where\u201d.<\/p>\n\n\n\n
Cen\u00e1rio: Executar todas as uni\u00f5es necess\u00e1rias, depois projetar os valores<\/h2>\n\n\n\n
Vamos usar a mesma consulta de antes, mas desta vez observaremos o que acontece quando movemos \u201c[?release<\/strong> :release\/name ?album-name<\/strong>]\u201d para o fim das nossas cl\u00e1usulas \u201c:where\u201d.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
{<\/span>:query '<\/span>{<\/span>:find  <\/span>[<\/span>?album-name ?year<\/span>]<\/span><\/span>\n          :in    <\/span>[<\/span>$ ?artist-name<\/span>]<\/span><\/span>\n          :where <\/span>[[<\/span>?artist :artist\/name ?artist-name<\/span>]<\/span><\/span>\n                  <\/span>[<\/span>?release :release\/artists ?artist<\/span>]<\/span><\/span>\n                  <\/span>[<\/span>?release :release\/year ?year<\/span>]<\/span><\/span>\n                  <\/span>[(<\/span><<\/span> ?year <\/span>1970<\/span>)]<\/span><\/span>\n                  <\/span>[<\/span>?release :release\/name ?album-name<\/span>]]}<\/span><\/span>\n :args  <\/span>[<\/span>db <\/span>"<\/span>John Lennon<\/span>"<\/span>]}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
Acontece algo muito interessante quando executamos essa busca, embora n\u00e3o fique \u00f3bvio imediatamente. Os resultados da solicita\u00e7\u00e3o de estat\u00edsticas de consulta para esta consulta podem ser vistos aqui<\/a>.<\/p>\n\n\n\n
clause<\/td>rows-in<\/td>rows-out<\/td>binds-in<\/td>binds-out<\/td>expansion<\/td>preds<\/td><\/tr>
[(ground<\/em><\/strong> $__in__2<\/strong>) ?artist-name<\/strong>]<\/td>0<\/strong><\/td>1<\/strong><\/td>()<\/td>[?artist-name<\/strong>]<\/td>1<\/strong><\/td><\/td><\/tr>
[?artist<\/strong> :artist\/name ?artist-name<\/strong>]<\/td>1<\/strong><\/td>1<\/strong><\/td>[?artist-name<\/strong>]<\/td>[?artist<\/strong>]<\/td><\/td><\/td><\/tr>
[?release <\/strong>:release\/artists ?artist<\/strong>]<\/td>1<\/strong><\/td>21<\/strong><\/td>[?artist<\/strong>]<\/td>[?release<\/strong>]<\/td>20<\/strong><\/td><\/td><\/tr>
[?release <\/strong>:release\/year ?year<\/strong>]<\/td>21<\/strong><\/td>3<\/strong><\/td>[?release<\/strong>]<\/td>[?year<\/strong> ?release<\/strong>]<\/td><\/td>([(< ?year<\/strong> 1970<\/strong>)])<\/td><\/tr>
[?release <\/strong>:release\/name ?album-name<\/strong>]<\/td>3<\/strong><\/td>3<\/strong><\/td>[?year<\/strong> ?release<\/strong>]<\/td>[?album-name<\/strong> ?year<\/strong>]<\/td><\/td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Vamos rever a cl\u00e1usula 4 da primeira consulta:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
{<\/span>:clause    <\/span>[<\/span>?release :release\/name ?album-name<\/span>]<\/span>,<\/span><\/span>\n :rows-in   <\/span>21<\/span>,<\/span><\/span>\n :rows-out  <\/span>21<\/span>,<\/span><\/span>\n :binds-in  <\/span>[<\/span>?release<\/span>]<\/span>,<\/span><\/span>\n :binds-out <\/span>[<\/span>?album-name ?release<\/span>]}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
Podemos observar que o conjunto de resultados agora cont\u00e9m 21 itens, cada um com 2 valores. Como resultado, temos um total de 42 valores no conjunto de resultados.<\/p>\n\n\n\n
Agora vamos comparar isso com a segunda consulta:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
;; was clause #5, now clause #4<\/span><\/span>\n{<\/span>:clause    <\/span>[<\/span>?release :release\/year ?year<\/span>]<\/span>,<\/span><\/span>\n :rows-in   <\/span>21<\/span>,<\/span><\/span>\n :rows-out  <\/span>3<\/span>,<\/span><\/span>\n :binds-in  <\/span>[<\/span>?release<\/span>]<\/span>,<\/span><\/span>\n :binds-out <\/span>[<\/span>?year ?release<\/span>]<\/span>,<\/span><\/span>\n :preds     <\/span>([(<\/span><<\/span> ?year <\/span>1970<\/span>)])}<\/span><\/span>\n <\/span><\/span>\n;; was clause #4, now clause #5<\/span><\/span>\n{<\/span>:clause    <\/span>[<\/span>?release :release\/name ?album-name<\/span>]<\/span>,<\/span><\/span>\n :rows-in   <\/span>3<\/span>,<\/span><\/span>\n :rows-out  <\/span>3<\/span>,<\/span><\/span>\n :binds-in  <\/span>[<\/span>?year ?release<\/span>]<\/span>,<\/span><\/span>\n :binds-out <\/span>[<\/span>?album-name ?year<\/span>]}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
A cl\u00e1usula 4 na segunda consulta reduz nosso conjunto de resultados de 21 para 3, mas acrescenta outro valor nele. O conjunto de resultados atual cont\u00e9m 3 linhas, com 2 valores em cada uma, totalizando 6 valores.<\/p>\n\n\n\n
Agora, a cl\u00e1usula que encontra o nome do \u00e1lbum s\u00f3 precisa buscar em 3 \u00e1lbuns. Antes, era preciso buscar em 21 e excluir todos, exceto 3, ap\u00f3s limitar o ano de lan\u00e7amento. Como voc\u00ea pode imaginar, isso economiza bastante trabalho em escalas maiores.<\/p>\n\n\n\n
Conclus\u00e3o<\/h2>\n\n\n\n
Essa \u00e9 apenas uma das possibilidades de usar informa\u00e7\u00f5es retornadas por estat\u00edsticas de consulta para entender e aprimorar suas consultas. As estat\u00edsticas de consulta tamb\u00e9m podem ser \u00fateis para quando voc\u00ea se perguntar por que suas consultas agem diferente conforme uma distribui\u00e7\u00e3o diferente dos dados subjacentes, ou questionar regras recursivas de consultas etc.<\/p>\n","protected":false},"excerpt":{"rendered":"
As estat\u00edsticas de consulta s\u00e3o um novo recurso que permite que os usu\u00e1rios vejam as decis\u00f5es tomadas pela ferramenta de consulta durante o processo de busca.<\/p>\n","protected":false},"author":178110177,"featured_media":24846,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[2497,2586],"tags":[2673,2582,2672],"ppma_author":[2390],"class_list":["post-26013","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-engineering-pt-br","category-software-engineering-pt-br","tag-clause-ordering-pt-br","tag-datomic-pt-br","tag-query-stats-pt-br"],"acf":[],"yoast_head":"\nComo usar estat\u00edsticas de consulta do Datomic para Otimizar Ordem de Cl\u00e1usulas - Building Nubank<\/title>\n<meta name=\"description\" content=\"As estat\u00edsticas de consulta s\u00e3o um novo recurso que permite que os usu\u00e1rios vejam as decis\u00f5es tomadas pela ferramenta de consulta durante o processo de busca.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como usar estat\u00edsticas de consulta do Datomic para Otimizar Ordem de Cl\u00e1usulas - Building Nubank\" \/>\n<meta property=\"og:description\" content=\"As estat\u00edsticas de consulta s\u00e3o um novo recurso que permite que os usu\u00e1rios vejam as decis\u00f5es tomadas pela ferramenta de consulta durante o processo de busca.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/\" \/>\n<meta property=\"og:site_name\" content=\"Building Nubank\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-03T21:58:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T17:30:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/building.nubank.com\/wp-content\/uploads\/2023\/02\/optimizing-datomic-queries_Feature_1200x675-1.jpg?fit=1200%2C675&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Keith Harper - Staff Software Engineer at Nubank\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Keith Harper - Staff Software Engineer at Nubank\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/\"},\"author\":{\"name\":\"Keith Harper - Staff Software Engineer at Nubank\",\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/dee6b0c1f5f1cb2026efc53d473ad8c3\"},\"headline\":\"Como usar estat\u00edsticas de consulta do Datomic para Otimizar Ordem de Cl\u00e1usulas\",\"datePublished\":\"2023-02-03T21:58:12+00:00\",\"dateModified\":\"2024-03-21T17:30:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/\"},\"wordCount\":1196,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/building.nubank.com\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/optimizing-datomic-queries_Feature_1200x675-1.jpg?fit=1200%2C675&ssl=1\",\"keywords\":[\"Clause Ordering\",\"Datomic\",\"query-stats\"],\"articleSection\":[\"Engineering\",\"Software Engineering\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/\",\"url\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/\",\"name\":\"Como usar estat\u00edsticas de consulta do Datomic para Otimizar Ordem de Cl\u00e1usulas - Building Nubank\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/building.nubank.com\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/optimizing-datomic-queries_Feature_1200x675-1.jpg?fit=1200%2C675&ssl=1\",\"datePublished\":\"2023-02-03T21:58:12+00:00\",\"dateModified\":\"2024-03-21T17:30:27+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/dee6b0c1f5f1cb2026efc53d473ad8c3\"},\"description\":\"As estat\u00edsticas de consulta s\u00e3o um novo recurso que permite que os usu\u00e1rios vejam as decis\u00f5es tomadas pela ferramenta de consulta durante o processo de busca.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/building.nubank.com\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/optimizing-datomic-queries_Feature_1200x675-1.jpg?fit=1200%2C675&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/building.nubank.com\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/optimizing-datomic-queries_Feature_1200x675-1.jpg?fit=1200%2C675&ssl=1\",\"width\":1200,\"height\":675},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como usar estat\u00edsticas de consulta do Datomic para Otimizar Ordem de Cl\u00e1usulas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/#website\",\"url\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/\",\"name\":\"Building Nubank\",\"description\":\"We make the extraordinary happen\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/dee6b0c1f5f1cb2026efc53d473ad8c3\",\"name\":\"Keith Harper - Staff Software Engineer at Nubank\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/building.nubank.com.br\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/avatar_user_178110177_1675452580-96x96.png83cdfc2cf8cd76f20ff8c361479fd3ea\",\"url\":\"https:\\\/\\\/building.nubank.com.br\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/avatar_user_178110177_1675452580-96x96.png\",\"contentUrl\":\"https:\\\/\\\/building.nubank.com.br\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/avatar_user_178110177_1675452580-96x96.png\",\"caption\":\"Keith Harper - Staff Software Engineer at Nubank\"},\"description\":\"Keith Harper is responsible for developing and supporting Datomic, helping Nubank by educating and empowering engineering teams. He has a degree in Information Technology from Georgia Southern University. Keith joined Nubank in 2021 and has extensive experience developing software using Clojure and Datomic. He also is a fan of Hearthstone and other digital card games.\",\"url\":\"https:\\\/\\\/building.nubank.com\\\/pt-br\\\/author\\\/keith-harper\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como usar estat\u00edsticas de consulta do Datomic para Otimizar Ordem de Cl\u00e1usulas - Building Nubank","description":"As estat\u00edsticas de consulta s\u00e3o um novo recurso que permite que os usu\u00e1rios vejam as decis\u00f5es tomadas pela ferramenta de consulta durante o processo de busca.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/","og_locale":"pt_BR","og_type":"article","og_title":"Como usar estat\u00edsticas de consulta do Datomic para Otimizar Ordem de Cl\u00e1usulas - Building Nubank","og_description":"As estat\u00edsticas de consulta s\u00e3o um novo recurso que permite que os usu\u00e1rios vejam as decis\u00f5es tomadas pela ferramenta de consulta durante o processo de busca.","og_url":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/","og_site_name":"Building Nubank","article_published_time":"2023-02-03T21:58:12+00:00","article_modified_time":"2024-03-21T17:30:27+00:00","og_image":[{"width":1200,"height":675,"url":"https:\/\/i0.wp.com\/building.nubank.com\/wp-content\/uploads\/2023\/02\/optimizing-datomic-queries_Feature_1200x675-1.jpg?fit=1200%2C675&ssl=1","type":"image\/jpeg"}],"author":"Keith Harper - Staff Software Engineer at Nubank","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Keith Harper - Staff Software Engineer at Nubank","Est. tempo de leitura":"7 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/#article","isPartOf":{"@id":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/"},"author":{"name":"Keith Harper - Staff Software Engineer at Nubank","@id":"https:\/\/building.nubank.com\/pt-br\/#\/schema\/person\/dee6b0c1f5f1cb2026efc53d473ad8c3"},"headline":"Como usar estat\u00edsticas de consulta do Datomic para Otimizar Ordem de Cl\u00e1usulas","datePublished":"2023-02-03T21:58:12+00:00","dateModified":"2024-03-21T17:30:27+00:00","mainEntityOfPage":{"@id":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/"},"wordCount":1196,"commentCount":0,"image":{"@id":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/building.nubank.com\/wp-content\/uploads\/2023\/02\/optimizing-datomic-queries_Feature_1200x675-1.jpg?fit=1200%2C675&ssl=1","keywords":["Clause Ordering","Datomic","query-stats"],"articleSection":["Engineering","Software Engineering"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/","url":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/","name":"Como usar estat\u00edsticas de consulta do Datomic para Otimizar Ordem de Cl\u00e1usulas - Building Nubank","isPartOf":{"@id":"https:\/\/building.nubank.com\/pt-br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/#primaryimage"},"image":{"@id":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/building.nubank.com\/wp-content\/uploads\/2023\/02\/optimizing-datomic-queries_Feature_1200x675-1.jpg?fit=1200%2C675&ssl=1","datePublished":"2023-02-03T21:58:12+00:00","dateModified":"2024-03-21T17:30:27+00:00","author":{"@id":"https:\/\/building.nubank.com\/pt-br\/#\/schema\/person\/dee6b0c1f5f1cb2026efc53d473ad8c3"},"description":"As estat\u00edsticas de consulta s\u00e3o um novo recurso que permite que os usu\u00e1rios vejam as decis\u00f5es tomadas pela ferramenta de consulta durante o processo de busca.","breadcrumb":{"@id":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/#primaryimage","url":"https:\/\/i0.wp.com\/building.nubank.com\/wp-content\/uploads\/2023\/02\/optimizing-datomic-queries_Feature_1200x675-1.jpg?fit=1200%2C675&ssl=1","contentUrl":"https:\/\/i0.wp.com\/building.nubank.com\/wp-content\/uploads\/2023\/02\/optimizing-datomic-queries_Feature_1200x675-1.jpg?fit=1200%2C675&ssl=1","width":1200,"height":675},{"@type":"BreadcrumbList","@id":"https:\/\/building.nubank.com\/pt-br\/como-usar-estatisticas-de-consulta-do-datomic-para-otimizar-ordem-de-clausulas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/building.nubank.com\/pt-br\/"},{"@type":"ListItem","position":2,"name":"Como usar estat\u00edsticas de consulta do Datomic para Otimizar Ordem de Cl\u00e1usulas"}]},{"@type":"WebSite","@id":"https:\/\/building.nubank.com\/pt-br\/#website","url":"https:\/\/building.nubank.com\/pt-br\/","name":"Building Nubank","description":"We make the extraordinary happen","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/building.nubank.com\/pt-br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Person","@id":"https:\/\/building.nubank.com\/pt-br\/#\/schema\/person\/dee6b0c1f5f1cb2026efc53d473ad8c3","name":"Keith Harper - Staff Software Engineer at Nubank","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/building.nubank.com.br\/wp-content\/uploads\/2023\/02\/avatar_user_178110177_1675452580-96x96.png83cdfc2cf8cd76f20ff8c361479fd3ea","url":"https:\/\/building.nubank.com.br\/wp-content\/uploads\/2023\/02\/avatar_user_178110177_1675452580-96x96.png","contentUrl":"https:\/\/building.nubank.com.br\/wp-content\/uploads\/2023\/02\/avatar_user_178110177_1675452580-96x96.png","caption":"Keith Harper - Staff Software Engineer at Nubank"},"description":"Keith Harper is responsible for developing and supporting Datomic, helping Nubank by educating and empowering engineering teams. He has a degree in Information Technology from Georgia Southern University. Keith joined Nubank in 2021 and has extensive experience developing software using Clojure and Datomic. He also is a fan of Hearthstone and other digital card games.","url":"https:\/\/building.nubank.com\/pt-br\/author\/keith-harper\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/building.nubank.com\/wp-content\/uploads\/2023\/02\/optimizing-datomic-queries_Feature_1200x675-1.jpg?fit=1200%2C675&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/pbKBB5-6Lz","jetpack_sharing_enabled":true,"authors":[{"term_id":2390,"user_id":178110177,"is_guest":0,"slug":"keith-harper","display_name":"Keith Harper - Staff Software Engineer at Nubank","avatar_url":"https:\/\/building.nubank.com.br\/wp-content\/uploads\/2023\/02\/avatar_user_178110177_1675452580-96x96.png","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/building.nubank.com\/pt-br\/wp-json\/wp\/v2\/posts\/26013","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/building.nubank.com\/pt-br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/building.nubank.com\/pt-br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/building.nubank.com\/pt-br\/wp-json\/wp\/v2\/users\/178110177"}],"replies":[{"embeddable":true,"href":"https:\/\/building.nubank.com\/pt-br\/wp-json\/wp\/v2\/comments?post=26013"}],"version-history":[{"count":4,"href":"https:\/\/building.nubank.com\/pt-br\/wp-json\/wp\/v2\/posts\/26013\/revisions"}],"predecessor-version":[{"id":28860,"href":"https:\/\/building.nubank.com\/pt-br\/wp-json\/wp\/v2\/posts\/26013\/revisions\/28860"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/building.nubank.com\/pt-br\/wp-json\/wp\/v2\/media\/24846"}],"wp:attachment":[{"href":"https:\/\/building.nubank.com\/pt-br\/wp-json\/wp\/v2\/media?parent=26013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/building.nubank.com\/pt-br\/wp-json\/wp\/v2\/categories?post=26013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/building.nubank.com\/pt-br\/wp-json\/wp\/v2\/tags?post=26013"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/building.nubank.com\/pt-br\/wp-json\/wp\/v2\/ppma_author?post=26013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Os resultados da solicita\u00e7\u00e3o de estat\u00edsticas de consulta para esta consulta podem ser vistos aqui<\/a>.<\/p>\n\n\n\n