{"id":585,"date":"2026-11-16T20:37:07","date_gmt":"2026-11-16T18:37:07","guid":{"rendered":"https:\/\/synergia.website\/es_es\/?p=585"},"modified":"2026-11-16T20:37:07","modified_gmt":"2026-11-16T18:37:07","slug":"optimitzacio-de-consultes-de-postgresql","status":"publish","type":"post","link":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/","title":{"rendered":"Optimitzaci\u00f3 de consultes de PostgreSQL: \u00edndexs i plans d'execuci\u00f3"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Quan una vista d'Odoo triga vuit segons a carregar-se o un informe bloqueja l'equip d'administraci\u00f3, \u00e9s temptador crear un \u00edndex i esperar. Per optimitzar de manera efectiva les consultes de PostgreSQL, cal seguir un enfocament diferent: identificar la consulta que t\u00e9 el major impacte en la c\u00e0rrega real, examinar el seu pla d'execuci\u00f3, triar l'\u00edndex adequat i mesurar els resultats abans i despr\u00e9s.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Continuem aquesta visi\u00f3 general amb una consulta t\u00edpica d'Odoo, des de la seva detecci\u00f3 fins a la validaci\u00f3 de l'\u00edndex. Tamb\u00e9 analitzem el cost d'aquest \u00edndex en termes d'operacions d'escriptura i de manteniment, perqu\u00e8 l'objectiu \u00e9s millorar el rendiment global de l'empresa, no aconseguir una exploraci\u00f3 d'\u00edndex a qualsevol preu.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Punts clau:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>Prioritzeu pel temps total a pg_stat_statements, no pas per la consulta m\u00e9s lenta.<\/li>\n\n\n<li>El cost del pla s'expressa en unitats arbitr\u00e0ries, no en mil\u00b7lisegons.<\/li>\n\n\n<li>Una Seq Scan \u00e9s adequada per a taules petites o lectures massives.<\/li>\n\n\n<li>EXPLAIN ANALYZE executa la sent\u00e8ncia: protegeix les sent\u00e8ncies UPDATE i DELETE amb una transacci\u00f3.<\/li>\n\n\n<li>Cada nou \u00edndex fa que les operacions INSERT, UPDATE, DELETE i VACUUM siguin m\u00e9s costoses.<\/li>\n\n\n<li>Valida mitjan\u00e7ant m\u00faltiples execucions, una mem\u00f2ria cau controlada i un volum de dades del m\u00f3n real.<\/li>\n\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Quines consultes val la pena optimitzar primer?<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"1024\" class=\"wp-image-589 lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" alt=\"Optimitzaci\u00f3 de consultes PostgreSQL: fitxes blaves encallades contra un \u00edndex de llaut\u00f3, al costat d&#039;un cilindre met\u00e0l\u00b7lic.\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" data-src=\"https:\/\/synergia.website\/wp-content\/uploads\/que-consultas-merece-la-pena-optimizar-primero-v1.webp\" data-srcset=\"https:\/\/synergia.website\/wp-content\/uploads\/que-consultas-merece-la-pena-optimizar-primero-v1.webp 1024w, https:\/\/synergia.website\/wp-content\/uploads\/que-consultas-merece-la-pena-optimizar-primero-v1-980x980.webp 980w, https:\/\/synergia.website\/wp-content\/uploads\/que-consultas-merece-la-pena-optimizar-primero-v1-480x480.webp 480w\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Comen\u00e7a amb les consultes que representen la major part del temps total d'execuci\u00f3, no pas amb la m\u00e9s lenta a\u00eflladament. Una consulta de 40 ms que s'executa 200.000 vegades al dia requereix al voltant de 8.000 segons, mentre que un informe de 30 segons executat dues vegades nom\u00e9s en requereix 60. L'extensi\u00f3 pg_stat_statements us proporciona aquesta visi\u00f3 general.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Activa pg_stat_statements<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">L'extensi\u00f3 forma part dels m\u00f2duls contrib de PostgreSQL i s'ha de carregar quan el servidor s'inicia. En un <a href=\"https:\/\/synergia.website\/ca\/docker-en-produccio-bones-practiques-per-garantir-el-rendiment-i-lestabilitat\/\">Desplegament amb Docker<\/a>, afegiu `shared_preload_libraries = 'pg_stat_statements'` al fitxer `postgresql.conf` muntat al contenidor, o passeu aquest par\u00e0metre amb l'opci\u00f3 `-c` al comandament del servei. A continuaci\u00f3, reinicieu el contenidor i executeu `CREATE EXTENSION pg_stat_statements;` a la base de dades d'Odoo.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tingueu en compte que el canvi requereix reiniciar PostgreSQL, per tant \u00e9s aconsellable programar-lo fora de l'horari laboral. La sobrec\u00e0rrega de l'extensi\u00f3 \u00e9s baixa i queda m\u00e9s que compensada per les informacions que proporciona.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Ordena per impacte real<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Per veure quant contribueix cada consulta a la c\u00e0rrega, ordena per `total_exec_time` en lloc de nom\u00e9s per `mean_exec_time`:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">```sql```<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">instruccions SELECT,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">round(total_exec_time::numeric, 0) AS total_ms,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">round(mean_exec_time::numeric, 1) AS average_ms,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">fileres,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">shared_blks_hit, shared_blks_read,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">left(query, 120) AS query<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">DE pg_stat_statements<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ORDENAR PER total_exec_time descendent<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">L\u00edmit de 10;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">```<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">La relaci\u00f3 entre `shared_blks_hit` i `shared_blks_read` indica quina part es serveix des de la mem\u00f2ria cau de PostgreSQL i quina requereix lectura des del disc o de la mem\u00f2ria cau del sistema operatiu. Una consulta amb molts blocs llegits i poques files retornades \u00e9s un clar candidat per beneficiar-se d'un \u00edndex.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Com a exemple, imagina que la consulta que llan\u00e7a l'ORM d'Odoo en obrir la llista de factures d'un client apareix en primera posici\u00f3. T\u00e9 una mitjana de 180 ms i s'executa 45 000 vegades al dia, sumant un total d'uns 8 100 segons al dia \u2013 m\u00e9s de dues hores de temps de CPU. Aquesta \u00e9s la consulta en qu\u00e8 ens centrarem durant la resta d'aquest article.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Com genera aquestes consultes l'ORM d'Odoo?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">L'ORM tradueix cada `search()`, `read_group()` o vista de llista a SQL mitjan\u00e7ant un patr\u00f3 molt reconeixible. Si el pots llegir, sabr\u00e0s quin \u00edndex falta sense haver de mirar el codi Python. En el nostre exemple, `pg_stat_statements` mostra una cosa aix\u00ed, amb els par\u00e0metres normalitzats:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">```sql```<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT \"account_move\".\"id\" FROM \"account_move\"<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ON (\"account_move\".\"company_id\" IN ($1))<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I (\"account_move\".\"move_type\" IN ($2, $3))<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I (\"account_move\".\"state\" = $4)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I (\"account_move\".\"partner_id\" = $5)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ORDER BY \"account_move\".\"invoice_date\" DESC, \"account_move\".\"id\" DESC<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">L\u00edmit 80;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">```<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Hi ha diverses caracter\u00edstiques t\u00edpiques. El filtre per `company_id` apareix a causa de les regles multiempresa, fins i tot si nom\u00e9s tens una empresa. L'`ORDER BY` prov\u00e9 de l'`_order` del model o de la vista, i el `LIMIT 80` correspon a la paginaci\u00f3 per defecte de la vista de llista. L'ORM llavors fa una segona consulta per recuperar els camps visibles per a aquests 80 identificadors.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Cada camp declarat amb `index=True` al model genera un \u00edndex B-tree d'una sola columna. A `account_move`, `partner_id` i `state` normalment s'indexen per separat. El planificador pot utilitzar-ne un, per\u00f2 amb \u00edndexs separats no gestiona gaire b\u00e9 el filtratge i l'ordenaci\u00f3 simultanis. Per aix\u00f2 apareixen plans que llegeixen milers de registres per retornar nom\u00e9s 80.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Abans de fer cap canvi, comproveu tamb\u00e9 si la lentitud \u00e9s causada per un camp calculat amb `store=False` o per una regla d'\u00edndex complexa. Cap \u00edndex pot solucionar una regla que generi subconsultes a `res_partner` per a cada fila.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Com llegir un pla d'execuci\u00f3 amb EXPLAIN<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class='wpo_youtube_preview_container'><img data-src=\"https:\/\/synergia.website\/wp-content\/cache\/wpo-youtube-thumbnails\/IUJQVdYjHLY-maxresdefault.jpg\" class=\"wpo_youtube_preview lazyload\" data-video-url=\"https:\/\/www.youtube.com\/embed\/IUJQVdYjHLY?feature=oembed\" alt=\"Miniatura de YouTube\" data-iframe-attr=\"{&quot;title&quot;:&quot;How to Understand SQL EXPLAIN ANALYZE and BUFFERS&quot;,&quot;width&quot;:&quot;1080&quot;,&quot;height&quot;:&quot;608&quot;,&quot;src&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/embed\\\/IUJQVdYjHLY?feature=oembed&quot;,&quot;allow&quot;:&quot;accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share&quot;,&quot;referrerpolicy&quot;:&quot;strict-origin-when-cross-origin&quot;,&quot;allowfullscreen&quot;:&quot;&quot;}\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1280px; --smush-placeholder-aspect-ratio: 1280\/720;\" \/><span class=\"wpo_youtube_preview_overlay\"><img data-src=\"https:\/\/synergia.website\/wp-content\/plugins\/wp-optimize-premium\/images\/icon\/icons8-youtube-96.svg\" alt=\"Icona de YouTube\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 96px; --smush-placeholder-aspect-ratio: 96\/96;\" \/><\/span><\/div>\n<\/div><\/figure>\n\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Un pla \u00e9s un arbre de nodes: els fills produeixen files i els pares les consumeixen. Es llegeix de dins cap a fora. Per a cada node, es comparen les files estimades amb les reals i s'identifica on es concentra el temps i es llegeix el nombre m\u00e9s gran de blocs.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">EXPLAIN enfront d'EXPLAIN (ANALYZE, BUFFERS)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">`EXPLAIN` per si sol mostra el pla estimat sense executar res. Es basa en les estad\u00edstiques de la taula i \u00e9s instantani, per\u00f2 nom\u00e9s proporciona estimacions. `EXPLAIN (ANALYZE, BUFFERS)` executa realment la consulta i afegeix els temps d'execuci\u00f3 reals, el nombre real de files per node i el nombre de blocs llegits de la mem\u00f2ria cau (`shared hit`) o de fora d'ella (`read`).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Recorda que ANALYZE executa la instrucci\u00f3. Un EXPLAIN ANALYZE DELETE elimina registres, i un UPDATE modifica dades i activa disparadors. Per analitzar les operacions d'escriptura, inclou-les sempre dins d'una transacci\u00f3 d'aquesta manera:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">```sql```<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Comen\u00e7a;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">EXPLAIN (ANALYZE, BUFFERS) UPDATE account_move SET . WHERE .;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Retrocedir;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">```<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fins i tot amb ROLLBACK, la sent\u00e8ncia adquireix bloquejos mentre s'executa. Per tant, quan s'analitza una sent\u00e8ncia de producci\u00f3, \u00e9s aconsellable utilitzar una c\u00f2pia restaurada de la c\u00f2pia de seguretat m\u00e9s recent.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Cost, files i blocs<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Un node t\u00edpic t\u00e9 aquest aspecte:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">```<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Escaneig d'\u00edndex mitjan\u00e7ant l'`account_move_partner_id_index` a la taula `account_move`<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">(cost=0.43.9821.55 rows=310 width=8)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">(hora actual=0.05.171.20 files=4120 bucles=1)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Filtre: (estat = 'publicat' I tipus_despla\u00e7ament = QUALSEVOL (.))<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fileres eliminades pel filtre: 2.950<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Buffers: lectures compartides=1210, lectures=5340<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">```<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">El cost (`0.43.9821.55`) s'expressa en unitats arbitr\u00e0ries del planificador. Els dos valors indiquen els costos inicial i total en termes relatius; no s\u00f3n equivalents a mil\u00b7lisegons. S'utilitzen per comparar plans alternatius per a la mateixa consulta, no per predir els temps d'execuci\u00f3. El temps real es d\u00f3na en `temps real`.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Estigues atent a tres senyals. El primer \u00e9s que s'havien estimat 310 files, per\u00f2 se'n van retornar 4.120 \u2013 m\u00e9s de 13 vegades el nombre esperat \u2013 cosa que normalment indica estad\u00edstiques inexactes. El segon \u00e9s que `Rows Removed by Filter` mostra que l'\u00edndex localitza registres que posteriorment s'eliminen. El tercer \u00e9s que els 5.340 blocs llegits fora de la mem\u00f2ria cau, de 8 kB cadascun, sumen al voltant de 42 MB d'operacions de lectura per retornar 80 identificadors.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Per sobre d'aquest node, s'executar\u00e0 una operaci\u00f3 `Sort` sobre les 4.120 files per aplicar l'`ORDER BY invoice_date DESC` abans del `LIMIT`. Aqu\u00ed rau tot el coll d'ampolla: localitzar massa files, filtrar-les i ordenar-les a la mem\u00f2ria.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Per a consultes de llarga durada, exporta la consulta amb `FORMAT JSON` i enganxa-la a explain.dalibo.com, que dibuixa l'arbre i ressalta els nodes m\u00e9s costosos. Si utilitzeu PostgreSQL 18, llan\u00e7at el 25 de setembre de 2025, EXPLAIN tamb\u00e9 mostra m\u00e9s detalls sobre les operacions d'E\/S, les cerques d'\u00edndex i l'activitat WAL per node, la qual cosa accelera aquest diagn\u00f2stic.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00c9s l'escaneig seq\u00fcencial sempre un problema?<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"1024\" class=\"wp-image-590 lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" alt=\"Comparaci\u00f3 per optimitzar les consultes de PostgreSQL: escanejats seq\u00fcencials en taules petites i grans; un \u00edndex cobreix nom\u00e9s unes quantes files.\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" data-src=\"https:\/\/synergia.website\/wp-content\/uploads\/un-escaneo-secuencial-siempre-es-un-problema-v1.webp\" data-srcset=\"https:\/\/synergia.website\/wp-content\/uploads\/un-escaneo-secuencial-siempre-es-un-problema-v1.webp 1024w, https:\/\/synergia.website\/wp-content\/uploads\/un-escaneo-secuencial-siempre-es-un-problema-v1-980x980.webp 980w, https:\/\/synergia.website\/wp-content\/uploads\/un-escaneo-secuencial-siempre-es-un-problema-v1-480x480.webp 480w\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">No. Una exploraci\u00f3 seq\u00fcencial \u00e9s la millor opci\u00f3 quan la taula \u00e9s petita o la consulta requereix una gran proporci\u00f3 de les seves files. Llegir les p\u00e0gines en ordre \u00e9s molt m\u00e9s eficient que saltar aleat\u00f2riament entre l'\u00edndex i la taula.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">El planificador tria entre quatre estrat\u00e8gies principals:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>Seq Scan: escaneja tota la taula. \u00c9s adequat per a taules amb uns quants milers de registres, com ara `res_company` o `account_journal`, i per a informes que agrupen gaireb\u00e9 totes les dades.<\/li>\n\n\n<li>Escaneig d'\u00edndex: escaneja l'\u00edndex i accedeix a la taula (el heap) per a cada fila trobada. \u00c9s ideal per a un nombre redu\u00eft de files o per retornar-les en ordre ordenat.<\/li>\n\n\n<li>Bitmap Heap Scan: primer crea un mapa de les p\u00e0gines que contenen files v\u00e0lides i despr\u00e9s les llegeix en ordre f\u00edsic. \u00c9s adequat per a rangs de mida interm\u00e8dia, des de centenars fins a desenes de milers de files, i pot combinar diversos \u00edndexs mitjan\u00e7ant `BitmapAnd`.<\/li>\n\n\n<li>Escaneig nom\u00e9s d'\u00edndex: retorna els resultats utilitzant nom\u00e9s l'\u00edndex, sense accedir a la taula, sempre que el mapa de visibilitat estigui actualitzat. Aquest \u00e9s el m\u00e8tode m\u00e9s eficient.<\/li>\n\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Un Seq Scan indica un problema quan es produeix a `account_move_line`, `stock_move` o `mail_message` \u2013 taules que contenen milions de registres \u2013 i nom\u00e9s en retorna unes quantes dotzenes. En aquests casos, un valor de `Rows Removed by Filter` proper al nombre total de registres de la taula \u00e9s un senyal revelador.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tampoc no haur\u00edeu d'obligar a l'\u00fas d'un \u00edndex amb `SET enable_seqscan = off`, excepte com a experiment puntual dins d'una sessi\u00f3. Aix\u00f2 \u00e9s \u00fatil per veure quin cost estimaria el planificador amb l'\u00edndex, per\u00f2 mai no s'hauria de deixar com a configuraci\u00f3 permanent.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Per qu\u00e8 PostgreSQL ignora un \u00edndex existent?<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class='wpo_youtube_preview_container'><img data-src=\"https:\/\/synergia.website\/wp-content\/cache\/wpo-youtube-thumbnails\/molIQCx5uT4-maxresdefault.jpg\" class=\"wpo_youtube_preview lazyload\" data-video-url=\"https:\/\/www.youtube.com\/embed\/molIQCx5uT4?feature=oembed\" alt=\"Miniatura de YouTube\" data-iframe-attr=\"{&quot;title&quot;:&quot;\\u00cdndices en PostgreSQL, medidos: lo que aceleran, cu\\u00e1ndo no se usan y lo que cuestan al escribir&quot;,&quot;width&quot;:&quot;1080&quot;,&quot;height&quot;:&quot;608&quot;,&quot;src&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/embed\\\/molIQCx5uT4?feature=oembed&quot;,&quot;allow&quot;:&quot;accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share&quot;,&quot;referrerpolicy&quot;:&quot;strict-origin-when-cross-origin&quot;,&quot;allowfullscreen&quot;:&quot;&quot;}\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1280px; --smush-placeholder-aspect-ratio: 1280\/720;\" \/><span class=\"wpo_youtube_preview_overlay\"><img data-src=\"https:\/\/synergia.website\/wp-content\/plugins\/wp-optimize-premium\/images\/icon\/icons8-youtube-96.svg\" alt=\"Icona de YouTube\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 96px; --smush-placeholder-aspect-ratio: 96\/96;\" \/><\/span><\/div>\n<\/div><\/figure>\n\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">El planificador ignora un \u00edndex quan calcula que una altra ruta \u00e9s m\u00e9s barata. Les raons habituals inclouen estad\u00edstiques obsoletes, una condici\u00f3 que impedeix l'\u00fas de l'\u00edndex o una selectivitat tan baixa que resulta m\u00e9s rendible consultar tota la taula.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Estad\u00edstiques, ANALYZE i autovacuum<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Totes les estimacions de fila es deriven de les estad\u00edstiques recollides per `ANALYZE`: els valors m\u00e9s freq\u00fcents, els histogrames i la proporci\u00f3 de valors nuls per columna. Si, despr\u00e9s d'una importaci\u00f3 massiva o d'una migraci\u00f3 de dades, aquestes estad\u00edstiques encara descriuen la taula tal com era abans, el planificador prendr\u00e0 una decisi\u00f3 incorrecta. Executa `ANALYZE account_move;` despr\u00e9s de qualsevol c\u00e0rrega de dades gran.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Autovacuum executa autom\u00e0ticament ANALYZE quan al voltant del 10 per cent de les files han canviat (`autovacuum_analyze_scale_factor = 0.1`) i VACUUM quan al voltant del 20 per cent han canviat. Per a taules amb 20 milions de registres, aix\u00f2 significa esperar 2 milions de canvis. Per a taules grans d'Odoo, redueix aquests llindars per a cada taula:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">```sql```<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ALTER TABLE compte_moviment_l\u00ednia<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SET (autovacuum_analyze_scale_factor = 0.02,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">autovacuum_vacuum_scale_factor = 0.05);<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">```<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">VACUUM tamb\u00e9 \u00e9s important per al pla d'execuci\u00f3. Mant\u00e9 el mapa de visibilitat que permet les escanejades nom\u00e9s d'\u00edndex i elimina els tuples morts, que inflen les taules i els \u00edndexs. Comproveu `n_dead_tup` i `last_autoanalyze` a `pg_stat_user_tables` per veure si el manteniment s'est\u00e0 duent a terme a temps. Si una columna t\u00e9 una distribuci\u00f3 molt asim\u00e8trica, com ara `state`, amb un 95 per cent dels valors sent `posted`, augmenta la mida de la mostra amb `ALTER TABLE . ALTER COLUMN state SET STATISTICS 1000;`.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Circumst\u00e0ncies que t'impedeixen aprofitar l'\u00edndex<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Un \u00edndex B-tree sobre `name` no \u00e9s adequat per a `WHERE lower(name) = .`, ni per a `ILIKE '%text%'`, ni quan hi ha una conversi\u00f3 de tipus impl\u00edcita. Odoo genera moltes consultes `ILIKE` sobre els camps `name`. Per a aquestes consultes, l'\u00edndex adequat \u00e9s un \u00edndex GIN amb `pg_trgm`, que Odoo crea per als camps declarats amb `index='trigram'`.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">En un \u00edndex compost, l'ordre de les columnes tamb\u00e9 \u00e9s important. Un \u00edndex `(company_id, partner_id)` \u00e9s de poca utilitat per a una consulta que filtra nom\u00e9s per `partner_id`. PostgreSQL 18 va introduir l'escaneig per salt de l'arbre B (B-tree skip scan), que en alguns casos utilitza els \u00edndexs sense fer servir la seva primera columna, per\u00f2 aix\u00f2 nom\u00e9s \u00e9s efectiu quan aquesta columna t\u00e9 pocs valors diferents.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Com dissenyar un \u00edndex B-tree, compost o parcial<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Per a la nostra consulta de factures, l'opci\u00f3 correcta \u00e9s un \u00edndex compost B-tree parcial que cobreix tant les condicions d'igualtat del filtre com l'ordre de classificaci\u00f3 dels resultats. D'aquesta manera, PostgreSQL nom\u00e9s llegeix les primeres 80 entrades i no ordena res a la mem\u00f2ria.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">L'ordre de les columnes en un \u00edndex compost<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">En primer lloc, col\u00b7loqueu les columnes filtrades per igualtat, despr\u00e9s les que filtren per rang i, finalment, les de la cl\u00e0usula `ORDER BY`, totes en la mateixa direcci\u00f3. D'entre les columnes per igualtat, comenceu amb la que utilitzeu m\u00e9s sovint de manera a\u00efllada en altres consultes, perqu\u00e8 l'\u00edndex es pot utilitzar per a qualsevol prefix de les seves columnes. La documentaci\u00f3 de PostgreSQL il\u00b7lustra aquest concepte amb un \u00edndex `(major, minor)` per a consultes que filtren per ambd\u00f3s.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aplicat a l'exemple, `partner_id` apareix en primer lloc (es filtra per igualtat i \u00e9s molt selectiu), seguit de `invoice_date DESC` i `id DESC` per a l'ordenaci\u00f3:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">```sql```<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">CREATE INDEX CONCURRENTLY account_move_partner_invoice_idx<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ON account_move (partner_id, invoice_date DESC, id DESC)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ON estat = 'publicat'<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I move_type IN ('out_invoice', 'out_refund');<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">```<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">`company_id` s'omet perqu\u00e8, amb nom\u00e9s una empresa, no filtra res. Si est\u00e0s treballant amb diverses empreses i les dades estan realment separades per empresa, afegeix-lo immediatament despr\u00e9s de `partner_id`.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Quan triar un \u00edndex parcial<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Un \u00edndex parcial nom\u00e9s emmagatzema les files que satisfan la seva condici\u00f3 `WHERE`. Aix\u00f2 \u00e9s \u00fatil quan la consulta sempre filtra pel mateix valor i aquest subconjunt representa una part ben definida de la taula. Si les entrades de borrador, les entrades de diari i les factures de prove\u00efdor representen el 60 per cent de `account_move`, l'\u00edndex ocupa menys de la meitat de l'espai. A m\u00e9s, les transaccions que impliquin aquelles files excloses no el modifiquen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">El planificador nom\u00e9s l'utilitza si la consulta implica l\u00f2gicament la seva condici\u00f3. Si l'ORM envia `state = $4` com a par\u00e0metre gen\u00e8ric, pot no recon\u00e8ixer aquesta implicaci\u00f3 en els plans gen\u00e8rics. Verifica que l'\u00edndex aparegui en el pla final i utilitza `CONCURRENTLY` per evitar bloquejos en les escriptures mentre es construeix.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">El cost de registre i manteniment<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Cada \u00edndex s'actualitza amb cada INSERT i DELETE, i amb cada UPDATE que afecta les seves columnes o que no es pot resoldre com una actualitzaci\u00f3 HOT. A `account_move`, confirmar una factura canvia l'`state`, cosa que desencadena la inserci\u00f3 de l'entrada a l'\u00edndex parcial. Aix\u00f2 tamb\u00e9 augmenta la quantitat de WAL generada, la mida de les c\u00f2pies de seguretat i la c\u00e0rrega de treball per al VACUUM.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Un \u00edndex compost amb tres columnes sobre 3 milions de registres pot ocupar entre 100 i 150 MB. Si l'afegiu sense eliminar res, la mem\u00f2ria compartida acaba repartida entre m\u00e9s estructures. Comproveu `pg_stat_user_indexes` i suprimiu els \u00edndexs amb `idx_scan = 0` despr\u00e9s de diverses setmanes d'activitat normal, excepte els que garanteixen la unicitat.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Mesura abans i despr\u00e9s sense enganyar-te a tu mateix.<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"1024\" class=\"wp-image-591 lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" alt=\"Les taules transparents mostren les files de la base de dades abans i despr\u00e9s d&#039;optimitzar les consultes de PostgreSQL, amb etiquetes i pesos de calibratge id\u00e8ntics.\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" data-src=\"https:\/\/synergia.website\/wp-content\/uploads\/medir-antes-y-despues-sin-enganarte-v1.webp\" data-srcset=\"https:\/\/synergia.website\/wp-content\/uploads\/medir-antes-y-despues-sin-enganarte-v1.webp 1024w, https:\/\/synergia.website\/wp-content\/uploads\/medir-antes-y-despues-sin-enganarte-v1-980x980.webp 980w, https:\/\/synergia.website\/wp-content\/uploads\/medir-antes-y-despues-sin-enganarte-v1-480x480.webp 480w\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Valida cada \u00edndex mitjan\u00e7ant una mesura reprodu\u00efble de tota la c\u00e0rrega, no pas d'una sola execuci\u00f3. La segona execuci\u00f3 de qualsevol consulta sol ser m\u00e9s r\u00e0pida perqu\u00e8 els blocs ja s\u00f3n a la mem\u00f2ria cau. Si no ho teniu en compte, atribu\u00efreu a l'\u00edndex una millora que no es mereix.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Seguiu aquests passos:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n\n<li>Restabliu una c\u00f2pia de seguretat recent de producci\u00f3 en un entorn equivalent, amb el mateix volum de dades i la mateixa versi\u00f3 de PostgreSQL, i executeu `ANALYZE`.<\/li>\n\n\n<li>Executa la consulta cinc a deu vegades amb `EXPLAIN (ANALYZE, BUFFERS)`, utilitzant par\u00e0metres reals: un client amb 20 factures i un altre amb 30.000. Anota la mediana i el nombre de blocs llegits, no el millor temps.<\/li>\n\n\n<li>Tamb\u00e9 mesura les operacions d'escriptura afectades \u2013 per exemple, utilitzant `pgbench` i un script que insereix i confirma factures \u2013 i registra les transaccions per segon i el WAL generat.<\/li>\n\n\n<li>Crea l'\u00edndex, repeteix els passos 2 i 3 en les mateixes condicions i compara els resultats.<\/li>\n\n\n<li>En producci\u00f3, executa `SELECT pg_stat_statements_reset();` despr\u00e9s de desplegar l'\u00edndex i, al cap d'una setmana, compara el `total_exec_time` de les consultes principals amb el de la setmana anterior.<\/li>\n\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">En l'exemple, el nou pla hauria de mostrar un escaneig d'\u00edndex que s'atura en arribar a 80 registres, sense cap node de classificaci\u00f3 i amb unes quantes desenes de blocs llegits, en comparaci\u00f3 amb la xifra anterior de m\u00e9s de 6.500. Si el temps mitj\u00e0 cau de 180 ms a uns 2 ms, el temps total per a les 45.000 trucades di\u00e0ries baixa d'uns 8.100 segons a 90.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aquests estalvis es comparen amb les mesures del pas 3. Si la confirmaci\u00f3 de la factura resulta en una disminuci\u00f3 del 2 per cent en el rendiment, el resultat global \u00e9s clarament positiu. Si una importaci\u00f3 nocturna de 500.000 l\u00ednies triga una hora m\u00e9s, potser val la pena desactivar el proc\u00e9s i reconstruir l'\u00edndex despr\u00e9s. La decisi\u00f3 es pren tenint en compte la c\u00e0rrega de treball global de l'empresa.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Per on comen\u00e7ar<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Activa `pg_stat_statements` aquesta setmana i deixa que reculli set dies d'activitat normal. Aquesta llista, ordenada pel temps total, et permetr\u00e0 identificar les tres o quatre consultes que val la pena optimitzar i ignorar la resta sense crear \u00edndexs a l'atzar. Si preferissis disposar de suport t\u00e8cnic per al teu <a href=\"https:\/\/synergia.website\/ca\/implementacio-derp-odoo-docker-servidors-barcelona\/\">Instal\u00b7laci\u00f3 d'Odoo a Barcelona<\/a>, Synergia ofereix aix\u00f2 amb un SLA de resposta de dues hores.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Preguntes freq\u00fcents<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Quants \u00edndexos pot tenir una taula sense afectar el rendiment?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">No hi ha un nombre fix. El l\u00edmit el determina la relaci\u00f3 entre lectures i escriptures. En taules amb un alt volum d'escriptures, com ara `account_move_line` o `stock_move`, cada \u00edndex addicional t\u00e9 un impacte notable en els temps de commit, aix\u00ed que cal justificar-ne cadascun executant una consulta espec\u00edfica a `pg_stat_statements`.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u00c9s possible crear un \u00edndex en producci\u00f3 sense aturar Odoo?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">S\u00ed, utilitzant `CREATE INDEX CONCURRENTLY`, que no bloqueja les escriptures. Triga m\u00e9s i no es pot executar dins d'una transacci\u00f3. Si falla, deixa un \u00edndex marcat com a inv\u00e0lid, que has d'eliminar abans de tornar-ho a provar.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Amb quina freq\u00fc\u00e8ncia s'ha d'executar ANALYZE manualment?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Autovacuum sol ser suficient, configurat per a cada taula en el cas de taules m\u00e9s grans. Executa `ANALYZE` manualment despr\u00e9s d'importacions massives, migracions o supressions a gran escala, ja que, si no, l'optimitzador treballaria amb estad\u00edstiques que descriuen una taula diferent.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Augmentar `work_mem` ajuda a accelerar les consultes?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Aix\u00f2 \u00e9s \u00fatil quan el pla mostra operacions de classificaci\u00f3 o d'hash que superen la capacitat de mem\u00f2ria i que s'externalitzen al disc (`M\u00e8tode de classificaci\u00f3: fusi\u00f3 externa`). Utilitzeu aquesta funci\u00f3 amb precauci\u00f3: s'assigna per operaci\u00f3 i per connexi\u00f3, i amb molts processos de negoci d'Odoo en funcionament, pot esgotar la mem\u00f2ria del servidor.<\/p>","protected":false},"excerpt":{"rendered":"<p>Apr\u00e8n a optimitzar les consultes de PostgreSQL utilitzant pg_stat_statements, EXPLAIN ANALYZE i \u00edndexs ben escollits, alhora que mesures l'impacte en les lectures i les escriptures.<\/p>","protected":false},"author":1,"featured_media":588,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-585","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO Pro 5.0.2 - aioseo.com -->\n\t<meta name=\"description\" content=\"Aprende a optimizar consultas PostgreSQL con pg_stat_statements, EXPLAIN ANALYZE e \u00edndices bien elegidos, midiendo el impacto en lecturas y escrituras. (Versi\u00f3 en catal\u00e0)\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Synergia\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO Pro (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"ca_ES\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Synergia - Partner y Despliegue de Odoo ERP, Servidores y Docker en Barcelona\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n - Synergia | CA\" \/>\n\t\t<meta property=\"og:description\" content=\"Aprende a optimizar consultas PostgreSQL con pg_stat_statements, EXPLAIN ANALYZE e \u00edndices bien elegidos, midiendo el impacto en lecturas y escrituras. (Versi\u00f3 en catal\u00e0)\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-11-16T18:37:07+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-11-16T18:37:07+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=61575396873539&amp;locale=es_ES\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n - Synergia | CA\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Aprende a optimizar consultas PostgreSQL con pg_stat_statements, EXPLAIN ANALYZE e \u00edndices bien elegidos, midiendo el impacto en lecturas y escrituras. (Versi\u00f3 en catal\u00e0)\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#blogposting\",\"name\":\"Optimizar Consultas PostgreSQL: \\u00cdndices Y Planes De Ejecuci\\u00f3n - Synergia | CA\",\"headline\":\"Optimizar Consultas PostgreSQL: \\u00cdndices Y Planes De Ejecuci\\u00f3n\",\"author\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/author\\\/synergia\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/synergia.website\\\/wp-content\\\/uploads\\\/optimizar-consultas-postgresql-v1.webp\",\"width\":1024,\"height\":1024},\"datePublished\":\"2026-11-16T20:37:07+02:00\",\"dateModified\":\"2026-11-16T20:37:07+02:00\",\"inLanguage\":\"ca\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#webpage\"},\"articleSection\":\"Uncategorized\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/synergia.website\\\/ca\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/category\\\/uncategorized\\\/#listItem\",\"name\":\"Uncategorized\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/category\\\/uncategorized\\\/#listItem\",\"position\":2,\"name\":\"Uncategorized\",\"item\":\"https:\\\/\\\/synergia.website\\\/ca\\\/category\\\/uncategorized\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#listItem\",\"name\":\"Optimizar Consultas PostgreSQL: \\u00cdndices Y Planes De Ejecuci\\u00f3n\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#listItem\",\"position\":3,\"name\":\"Optimizar Consultas PostgreSQL: \\u00cdndices Y Planes De Ejecuci\\u00f3n\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/category\\\/uncategorized\\\/#listItem\",\"name\":\"Uncategorized\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/#organization\",\"name\":\"Synergia\",\"description\":\"Partner y Despliegue de Odoo ERP, Servidores y Docker en Barcelona\",\"url\":\"https:\\\/\\\/synergia.website\\\/ca\\\/\",\"email\":\"info@synergia.website\",\"telephone\":\"+34615794558\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/synergia.website\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/cropped-IMG-20230416-WA0071.png\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#organizationLogo\",\"width\":512,\"height\":512},\"image\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/profile.php?id=61575396873539&locale=es_ES\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/synergia-portal\"],\"address\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/#postaladdress\",\"@type\":\"PostalAddress\",\"streetAddress\":\"Prats 52\",\"postalCode\":\"08271\",\"addressLocality\":\"Art\\u00e9s\",\"addressRegion\":\"Barcelona\",\"addressCountry\":\"ES\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/author\\\/synergia\\\/#author\",\"url\":\"https:\\\/\\\/synergia.website\\\/ca\\\/author\\\/synergia\\\/\",\"name\":\"Synergia\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/605b256ec98041a2e6a99e1c7fa4eea3d27b7bc43a6e7330f04bc30cbe9bc144?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Synergia\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#webpage\",\"url\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/\",\"name\":\"Optimizar Consultas PostgreSQL: \\u00cdndices Y Planes De Ejecuci\\u00f3n - Synergia | CA\",\"description\":\"Aprende a optimizar consultas PostgreSQL con pg_stat_statements, EXPLAIN ANALYZE e \\u00edndices bien elegidos, midiendo el impacto en lecturas y escrituras. (Versi\\u00f3 en catal\\u00e0)\",\"inLanguage\":\"ca\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/author\\\/synergia\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/author\\\/synergia\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/synergia.website\\\/wp-content\\\/uploads\\\/optimizar-consultas-postgresql-v1.webp\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#mainImage\",\"width\":1024,\"height\":1024},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/optimizar-consultas-postgresql\\\/#mainImage\"},\"datePublished\":\"2026-11-16T20:37:07+02:00\",\"dateModified\":\"2026-11-16T20:37:07+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/#website\",\"url\":\"https:\\\/\\\/synergia.website\\\/ca\\\/\",\"name\":\"Synergia Partner y Despliegue de Odoo ERP, Servidores y Docker en Barcelona\",\"alternateName\":\"Synergia Odoo\",\"description\":\"Partner y Despliegue de Odoo ERP, Servidores y Docker en Barcelona\",\"inLanguage\":\"ca\",\"publisher\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/ca\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO Pro -->\r\n\t\t<title>Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n - Synergia | CA<\/title>\n\n","aioseo_head_json":{"title":"Optimitzaci\u00f3 de consultes de PostgreSQL: \u00edndexs i plans d'execuci\u00f3 - Synergia | CA","description":"Apr\u00e8n a optimitzar les consultes de PostgreSQL utilitzant pg_stat_statements, EXPLAIN ANALYZE i \u00edndexs ben escollits, alhora que mesures l'impacte en les lectures i les escriptures. (versi\u00f3 en catal\u00e0)","canonical_url":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#blogposting","name":"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n - Synergia | CA","headline":"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n","author":{"@id":"https:\/\/synergia.website\/ca\/author\/synergia\/#author"},"publisher":{"@id":"https:\/\/synergia.website\/ca\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp","width":1024,"height":1024},"datePublished":"2026-11-16T20:37:07+02:00","dateModified":"2026-11-16T20:37:07+02:00","inLanguage":"ca","mainEntityOfPage":{"@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#webpage"},"isPartOf":{"@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#webpage"},"articleSection":"Uncategorized"},{"@type":"BreadcrumbList","@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/synergia.website\/ca\/#listItem","position":1,"name":"Home","item":"https:\/\/synergia.website\/ca\/","nextItem":{"@type":"ListItem","@id":"https:\/\/synergia.website\/ca\/category\/uncategorized\/#listItem","name":"Uncategorized"}},{"@type":"ListItem","@id":"https:\/\/synergia.website\/ca\/category\/uncategorized\/#listItem","position":2,"name":"Uncategorized","item":"https:\/\/synergia.website\/ca\/category\/uncategorized\/","nextItem":{"@type":"ListItem","@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#listItem","name":"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n"},"previousItem":{"@type":"ListItem","@id":"https:\/\/synergia.website\/ca\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#listItem","position":3,"name":"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n","previousItem":{"@type":"ListItem","@id":"https:\/\/synergia.website\/ca\/category\/uncategorized\/#listItem","name":"Uncategorized"}}]},{"@type":"Organization","@id":"https:\/\/synergia.website\/ca\/#organization","name":"Synergia","description":"Partner y Despliegue de Odoo ERP, Servidores y Docker en Barcelona","url":"https:\/\/synergia.website\/ca\/","email":"info@synergia.website","telephone":"+34615794558","logo":{"@type":"ImageObject","url":"https:\/\/synergia.website\/wp-content\/uploads\/2023\/04\/cropped-IMG-20230416-WA0071.png","@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#organizationLogo","width":512,"height":512},"image":{"@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/profile.php?id=61575396873539&locale=es_ES","https:\/\/www.linkedin.com\/company\/synergia-portal"],"address":{"@id":"https:\/\/synergia.website\/ca\/#postaladdress","@type":"PostalAddress","streetAddress":"Prats 52","postalCode":"08271","addressLocality":"Art\u00e9s","addressRegion":"Barcelona","addressCountry":"ES"}},{"@type":"Person","@id":"https:\/\/synergia.website\/ca\/author\/synergia\/#author","url":"https:\/\/synergia.website\/ca\/author\/synergia\/","name":"Synergia","image":{"@type":"ImageObject","@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/605b256ec98041a2e6a99e1c7fa4eea3d27b7bc43a6e7330f04bc30cbe9bc144?s=96&d=mm&r=g","width":96,"height":96,"caption":"Synergia"}},{"@type":"WebPage","@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#webpage","url":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/","name":"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n - Synergia | CA","description":"Aprende a optimizar consultas PostgreSQL con pg_stat_statements, EXPLAIN ANALYZE e \u00edndices bien elegidos, midiendo el impacto en lecturas y escrituras. (Versi\u00f3 en catal\u00e0)","inLanguage":"ca","isPartOf":{"@id":"https:\/\/synergia.website\/ca\/#website"},"breadcrumb":{"@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#breadcrumblist"},"author":{"@id":"https:\/\/synergia.website\/ca\/author\/synergia\/#author"},"creator":{"@id":"https:\/\/synergia.website\/ca\/author\/synergia\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp","@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#mainImage","width":1024,"height":1024},"primaryImageOfPage":{"@id":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/#mainImage"},"datePublished":"2026-11-16T20:37:07+02:00","dateModified":"2026-11-16T20:37:07+02:00"},{"@type":"WebSite","@id":"https:\/\/synergia.website\/ca\/#website","url":"https:\/\/synergia.website\/ca\/","name":"Synergia Partner y Despliegue de Odoo ERP, Servidores y Docker en Barcelona","alternateName":"Synergia Odoo","description":"Partner y Despliegue de Odoo ERP, Servidores y Docker en Barcelona","inLanguage":"ca","publisher":{"@id":"https:\/\/synergia.website\/ca\/#organization"}}]},"og:locale":"ca_ES","og:site_name":"Synergia - Partner y Despliegue de Odoo ERP, Servidores y Docker en Barcelona","og:type":"article","og:title":"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n - Synergia | CA","og:description":"Aprende a optimizar consultas PostgreSQL con pg_stat_statements, EXPLAIN ANALYZE e \u00edndices bien elegidos, midiendo el impacto en lecturas y escrituras. (Versi\u00f3 en catal\u00e0)","og:url":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/","og:image":"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp","og:image:secure_url":"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp","article:published_time":"2026-11-16T18:37:07+00:00","article:modified_time":"2026-11-16T18:37:07+00:00","article:publisher":"https:\/\/www.facebook.com\/profile.php?id=61575396873539&locale=es_ES","twitter:card":"summary_large_image","twitter:title":"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n - Synergia | CA","twitter:description":"Aprende a optimizar consultas PostgreSQL con pg_stat_statements, EXPLAIN ANALYZE e \u00edndices bien elegidos, midiendo el impacto en lecturas y escrituras. (Versi\u00f3 en catal\u00e0)","twitter:image":"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp"},"aioseo_meta_data":{"post_id":"585","title":null,"description":"Apr\u00e8n a optimitzar les consultes de PostgreSQL utilitzant pg_stat_statements, EXPLAIN ANALYZE i \u00edndexs ben escollits, alhora que mesures l'impacte en les lectures i les escriptures.","keywords":null,"keyphrases":{"focus":{"keyphrase":"optimizar consultas postgresql","score":0},"additional":[{"keyphrase":"optimizar base de datos postgresql","score":0}]},"focus_keyword":"optimizar consultas postgresql","additional_keywords":[{"word":"optimizar base de datos postgresql","score":0}],"truseo_locale":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"featured","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp","og_image_width":"0","og_image_height":"0","og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":"2026-11-16 18:38:12","created":"2026-11-16 18:36:37","updated":"2026-11-16 19:36:07"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/synergia.website\/ca\/\" title=\"Home\">Home<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/synergia.website\/ca\/category\/uncategorized\/\" title=\"Uncategorized\">Uncategorized<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\tOptimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n\n<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/synergia.website\/ca\/"},{"label":"Uncategorized","link":"https:\/\/synergia.website\/ca\/category\/uncategorized\/"},{"label":"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n","link":"https:\/\/synergia.website\/ca\/optimizar-consultas-postgresql\/"}],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n - Synergia | CA<\/title>\n<meta name=\"description\" content=\"Aprende a optimizar consultas PostgreSQL con pg_stat_statements, EXPLAIN ANALYZE e \u00edndices bien elegidos, midiendo el impacto en lecturas y escrituras.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/synergia.website\/ca\/optimitzacio-de-consultes-de-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"ca_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n\" \/>\n<meta property=\"og:description\" content=\"Aprende a optimizar consultas PostgreSQL con pg_stat_statements, EXPLAIN ANALYZE e \u00edndices bien elegidos, midiendo el impacto en lecturas y escrituras.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/synergia.website\/ca\/optimitzacio-de-consultes-de-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Synergia\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-16T18:37:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Synergia\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrit per\" \/>\n\t<meta name=\"twitter:data1\" content=\"Synergia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Temps estimat de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 minuts\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/\"},\"author\":{\"name\":\"Synergia\",\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/#\\\/schema\\\/person\\\/665b8e8be0eb2e2d6cea5851dd906001\"},\"headline\":\"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n\",\"datePublished\":\"2026-11-16T18:37:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/\"},\"wordCount\":3062,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/synergia.website\\\/wp-content\\\/uploads\\\/optimizar-consultas-postgresql-v1.webp\",\"articleSection\":[\"Uncategorized\"],\"inLanguage\":\"ca\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/\",\"url\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/\",\"name\":\"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n - Synergia\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/synergia.website\\\/wp-content\\\/uploads\\\/optimizar-consultas-postgresql-v1.webp\",\"datePublished\":\"2026-11-16T18:37:07+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/#\\\/schema\\\/person\\\/665b8e8be0eb2e2d6cea5851dd906001\"},\"description\":\"Aprende a optimizar consultas PostgreSQL con pg_stat_statements, EXPLAIN ANALYZE e \u00edndices bien elegidos, midiendo el impacto en lecturas y escrituras.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/#breadcrumb\"},\"inLanguage\":\"ca\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ca\",\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/synergia.website\\\/wp-content\\\/uploads\\\/optimizar-consultas-postgresql-v1.webp\",\"contentUrl\":\"https:\\\/\\\/synergia.website\\\/wp-content\\\/uploads\\\/optimizar-consultas-postgresql-v1.webp\",\"width\":1024,\"height\":1024,\"caption\":\"#image_title\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/optimizar-consultas-postgresql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/#website\",\"url\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/\",\"name\":\"Synergia\",\"description\":\"Partner y Despliegue de Odoo ERP, Servidores y Docker en Barcelona\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ca\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/synergia.website\\\/es_es\\\/#\\\/schema\\\/person\\\/665b8e8be0eb2e2d6cea5851dd906001\",\"name\":\"Synergia\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ca\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/605b256ec98041a2e6a99e1c7fa4eea3d27b7bc43a6e7330f04bc30cbe9bc144?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/605b256ec98041a2e6a99e1c7fa4eea3d27b7bc43a6e7330f04bc30cbe9bc144?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/605b256ec98041a2e6a99e1c7fa4eea3d27b7bc43a6e7330f04bc30cbe9bc144?s=96&d=mm&r=g\",\"caption\":\"Synergia\"},\"sameAs\":[\"https:\\\/\\\/synergia.website\"],\"url\":\"https:\\\/\\\/synergia.website\\\/ca\\\/author\\\/synergia\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Optimitzaci\u00f3 de consultes de PostgreSQL: \u00edndexs i plans d'execuci\u00f3 - Synergia | CA","description":"Apr\u00e8n a optimitzar les consultes de PostgreSQL utilitzant pg_stat_statements, EXPLAIN ANALYZE i \u00edndexs ben escollits, alhora que mesures l'impacte en les lectures i les escriptures.","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:\/\/synergia.website\/ca\/optimitzacio-de-consultes-de-postgresql\/","og_locale":"ca_ES","og_type":"article","og_title":"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n","og_description":"Aprende a optimizar consultas PostgreSQL con pg_stat_statements, EXPLAIN ANALYZE e \u00edndices bien elegidos, midiendo el impacto en lecturas y escrituras.","og_url":"https:\/\/synergia.website\/ca\/optimitzacio-de-consultes-de-postgresql\/","og_site_name":"Synergia","article_published_time":"2026-11-16T18:37:07+00:00","og_image":[{"width":1024,"height":1024,"url":"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp","type":"image\/webp"}],"author":"Synergia","twitter_card":"summary_large_image","twitter_misc":{"Escrit per":"Synergia","Temps estimat de lectura":"15 minuts"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/#article","isPartOf":{"@id":"https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/"},"author":{"name":"Synergia","@id":"https:\/\/synergia.website\/es_es\/#\/schema\/person\/665b8e8be0eb2e2d6cea5851dd906001"},"headline":"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n","datePublished":"2026-11-16T18:37:07+00:00","mainEntityOfPage":{"@id":"https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/"},"wordCount":3062,"commentCount":0,"image":{"@id":"https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp","articleSection":["Uncategorized"],"inLanguage":"ca","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/","url":"https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/","name":"Optimitzaci\u00f3 de consultes PostgreSQL: \u00edndexs i plans d'execuci\u00f3 - Synergia","isPartOf":{"@id":"https:\/\/synergia.website\/es_es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp","datePublished":"2026-11-16T18:37:07+00:00","author":{"@id":"https:\/\/synergia.website\/es_es\/#\/schema\/person\/665b8e8be0eb2e2d6cea5851dd906001"},"description":"Apr\u00e8n a optimitzar les consultes de PostgreSQL utilitzant pg_stat_statements, EXPLAIN ANALYZE i \u00edndexs ben escollits, alhora que mesures l'impacte en les lectures i les escriptures.","breadcrumb":{"@id":"https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/#breadcrumb"},"inLanguage":"ca","potentialAction":[{"@type":"ReadAction","target":["https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"ca","@id":"https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/#primaryimage","url":"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp","contentUrl":"https:\/\/synergia.website\/wp-content\/uploads\/optimizar-consultas-postgresql-v1.webp","width":1024,"height":1024,"caption":"#image_title"},{"@type":"BreadcrumbList","@id":"https:\/\/synergia.website\/es_es\/optimizar-consultas-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/synergia.website\/es_es\/"},{"@type":"ListItem","position":2,"name":"Optimizar Consultas PostgreSQL: \u00cdndices Y Planes De Ejecuci\u00f3n"}]},{"@type":"WebSite","@id":"https:\/\/synergia.website\/es_es\/#website","url":"https:\/\/synergia.website\/es_es\/","name":"Sinergia","description":"Odoo ERP, Servidors i Docker: Soci i Desplegament a Barcelona","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/synergia.website\/es_es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ca"},{"@type":"Person","@id":"https:\/\/synergia.website\/es_es\/#\/schema\/person\/665b8e8be0eb2e2d6cea5851dd906001","name":"Sinergia","image":{"@type":"ImageObject","inLanguage":"ca","@id":"https:\/\/secure.gravatar.com\/avatar\/605b256ec98041a2e6a99e1c7fa4eea3d27b7bc43a6e7330f04bc30cbe9bc144?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/605b256ec98041a2e6a99e1c7fa4eea3d27b7bc43a6e7330f04bc30cbe9bc144?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/605b256ec98041a2e6a99e1c7fa4eea3d27b7bc43a6e7330f04bc30cbe9bc144?s=96&d=mm&r=g","caption":"Synergia"},"sameAs":["https:\/\/synergia.website"],"url":"https:\/\/synergia.website\/ca\/author\/synergia\/"}]}},"_links":{"self":[{"href":"https:\/\/synergia.website\/ca\/wp-json\/wp\/v2\/posts\/585","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/synergia.website\/ca\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/synergia.website\/ca\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/synergia.website\/ca\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/synergia.website\/ca\/wp-json\/wp\/v2\/comments?post=585"}],"version-history":[{"count":1,"href":"https:\/\/synergia.website\/ca\/wp-json\/wp\/v2\/posts\/585\/revisions"}],"predecessor-version":[{"id":592,"href":"https:\/\/synergia.website\/ca\/wp-json\/wp\/v2\/posts\/585\/revisions\/592"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/synergia.website\/ca\/wp-json\/wp\/v2\/media\/588"}],"wp:attachment":[{"href":"https:\/\/synergia.website\/ca\/wp-json\/wp\/v2\/media?parent=585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/synergia.website\/ca\/wp-json\/wp\/v2\/categories?post=585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/synergia.website\/ca\/wp-json\/wp\/v2\/tags?post=585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}