{"id":7568,"date":"2019-09-04T11:48:42","date_gmt":"2019-09-04T18:48:42","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=7568"},"modified":"2025-06-13T19:27:39","modified_gmt":"2025-06-14T02:27:39","slug":"analytics-explain-plan-part-1","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/es\/analytics-explain-plan-part-1\/","title":{"rendered":"Analytics Explain Plan - Parte 1"},"content":{"rendered":"<p><span style=\"font-weight: 400\">Coautor:  Till Westmann, Director de Ingenier\u00eda<\/span><\/p>\n<h2><span style=\"font-weight: 400\">Introducci\u00f3n<\/span><\/h2>\n<p><span style=\"font-weight: 400\">Couchbase Analytics es el \"chico m\u00e1s nuevo del barrio\" entre todos los servicios disponibles en Couchbase Server. El nuevo servicio proporciona una r\u00e1pida comprensi\u00f3n de muchos casos de uso, como el env\u00edo a la costa, el an\u00e1lisis de carritos de la compra, la colocaci\u00f3n de productos en tiendas, las reservas de billetes de avi\u00f3n, el inventario de hoteles y muchos m\u00e1s. Couchbase Server ofrece un rendimiento inigualable en algunos de los casos de uso m\u00e1s exigentes, y las expectativas del servicio Analytics no son diferentes. En los \u00faltimos meses, hemos optimizado las consultas N1QL (SQL para JSON) para clientes que han desplegado Analytics en una variedad de topolog\u00edas de despliegue diferentes. \"\u00bfC\u00f3mo puedo interpretar el plan de consulta de Analytics?\" es una petici\u00f3n recurrente y voy a desmitificar el plan de consulta de Analytics en una serie de entradas de blog.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400\">En esta entrada del blog, parte 1, proporcionar\u00e9 informaci\u00f3n general sobre el marco de ejecuci\u00f3n y, a continuaci\u00f3n, explicar\u00e9 el plan para una consulta sencilla. En el siguiente blog de esta serie explicar\u00e9 el plan para consultas m\u00e1s complejas, incluidas las uniones, los accesos a \u00edndices y las agregaciones.<\/span><\/p>\n<h2><span style=\"font-weight: 400\">Fondo<\/span><\/h2>\n<p><span style=\"font-weight: 400\">Couchbase Analytics a\u00f1ade gesti\u00f3n paralela de datos a Couchbase Server para complementar las capacidades ofrecidas por los servicios de consulta e \u00edndice. Couchbase Analytics tiene un procesador de consultas basado en MPP (procesamiento paralelo masivo) que divide el trabajo de procesar una sola consulta entre todos los nodos de Analytics en un cl\u00faster de plataforma de datos Couchbase. Como resultado, puedes ejecutar consultas anal\u00edticas complejas -uniones ad-hoc, agregaci\u00f3n de conjuntos y operaciones de agrupaci\u00f3n- de forma r\u00e1pida y escalable.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400\">La siguiente imagen es una representaci\u00f3n conceptual simplificada de c\u00f3mo el motor Analytics procesa una consulta. La imagen representa lo que ocurre en un \u00fanico nodo y oculta los detalles de los aspectos MPP del motor de consulta.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-7569 size-full\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/image7.png\" alt=\"\" width=\"962\" height=\"914\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/image7.png 962w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/image7-300x285.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/image7-768x730.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/image7-20x20.png 20w\" sizes=\"auto, (max-width: 962px) 100vw, 962px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Se env\u00eda una solicitud al servicio Analytics y, una vez autenticada, la cadena de consulta se pasa al compilador de consultas.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">El compilador de consultas analiza y traduce la consulta y produce un plan de consulta optimizado. Un plan de consulta es un \u00e1rbol (o DAG) de operadores y conectores. Estos operadores son similares a los del \u00e1lgebra relacional de las bases de datos relacionales. La diferencia clave aqu\u00ed es que los operadores en Couchbase Analytics tambi\u00e9n son capaces de manejar datos JSON anidados y sin esquema. Los detalles est\u00e1n fuera del alcance de esta entrada del blog, pero se puede obtener bajo el cap\u00f3 en este <\/span><a href=\"https:\/\/www.youtube.com\/watch?v=1dN11TUj58c\"><span style=\"font-weight: 400\">presentaci\u00f3n en v\u00eddeo<\/span><\/a><span style=\"font-weight: 400\"> del profesor Mike Carey, arquitecto jefe de Couchbase Analytics.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">El plan de consulta se entrega al motor de ejecuci\u00f3n, que eval\u00faa los operadores del plan de consulta. <\/span><span style=\"font-weight: 400\">Analytics est\u00e1 dise\u00f1ado para grandes vol\u00famenes de datos y puede manejar con soltura <\/span><span style=\"font-weight: 400\">datos de la memoria al disco seg\u00fan sea necesario.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">El motor de ejecuci\u00f3n utiliza la cach\u00e9 del b\u00fafer para leer los datos almacenados en el disco y almacenarlos en la memoria para acceder a ellos m\u00e1s r\u00e1pidamente cuando sea necesario.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Los resultados de la ejecuci\u00f3n se pasan al manejador de respuesta.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">A continuaci\u00f3n, el gestor de respuestas devuelve los resultados al cliente.<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400\">Plan de consulta<\/span><\/h2>\n<p><span style=\"font-weight: 400\">A<\/span><span style=\"font-weight: 400\"> El plan de consulta describe la ruta de un documento a trav\u00e9s del motor de ejecuci\u00f3n. Las operaciones del plan se ejecutar\u00e1n para cada documento calificado.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Perm\u00edtanme ilustrar esto con una consulta muy simple a continuaci\u00f3n, que selecciona el nombre es todas las f\u00e1bricas de cerveza en California.<\/span><\/p>\n<pre class=\"lang:default decode:true\">select name \r\nfrom breweries \r\nwhere state=\u201dCalifornia\u201d<\/pre>\n<p><em><strong>La mejor forma de leer el plan ser\u00eda de abajo arriba. Te dar\u00eda una visi\u00f3n de c\u00f3mo se accede a los datos y los pasos que siguen para la ejecuci\u00f3n de la consulta.<\/strong><\/em><\/p>\n<p><b>\u00a0 \u00a0<span style=\"color: #0000ff\">Operadores del plan de consulta<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <span style=\"color: #0000ff\">Explicaci\u00f3n<\/span><\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-7570\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/image3.png\" alt=\"\" width=\"300\" height=\"134\" \/><span style=\"font-weight: 400\">Distribuir-resultado: Es la ra\u00edz del plan que recibe el resultado de la consulta. Cuando un cliente solicita los resultados (de forma sincr\u00f3nica o asincr\u00f3nica), los resultados se recuperan de cada nodo y se env\u00edan al cliente.<\/span><\/p>\n<p><i><span style=\"font-weight: 400\">Se trata de una operaci\u00f3n paralela que se reparte entre todos los nodos del cl\u00faster.<\/span><\/i><\/p>\n<hr \/>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-7572\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/image6.png\" alt=\"\" width=\"300\" height=\"134\" \/><\/p>\n<p><span style=\"font-weight: 400\">Proyecto: Expulsa el campo $$cervecer\u00edas y se queda con $$15 (que contiene el nombre de la cervecer\u00eda).<\/span><\/p>\n<p><i><span style=\"font-weight: 400\">Se trata de una operaci\u00f3n paralela que se reparte entre todos los nodos del cl\u00faster.<\/span><\/i><\/p>\n<hr \/>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-7573 size-medium\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/image1-1-300x134.png\" alt=\"\" width=\"300\" height=\"134\" \/><\/p>\n<p><strong>Asignar: <\/strong><span style=\"font-weight: 400\">Este operador eval\u00faa una o varias expresiones <\/span><span style=\"font-weight: 400\">y asigna los resultados a nuevas variables. En este caso, el valor de la clave \"nombre\" se asigna a la variable $15.<br \/>\n<\/span><i><\/i><\/p>\n<p><i><span style=\"font-weight: 400\">Se trata de una operaci\u00f3n paralela que se reparte entre todos los nodos del cl\u00faster.<\/span><\/i><\/p>\n<hr \/>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-7574 size-couchbase-grid-thumb\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/image2-400x149.png\" alt=\"\" width=\"300\" height=\"134\" \/><\/p>\n<p><span style=\"font-weight: 400\">Seleccionar: Selecciona los registros coincidentes bas\u00e1ndose en el predicado definido en la consulta. En este caso se seleccionan los registros de cervecer\u00edas que pertenecen a \"California\" y se filtra el resto.<br \/>\n<\/span><i><span style=\"font-weight: 400\">Se trata de una operaci\u00f3n paralela que se reparte entre todos los nodos del cl\u00faster.<\/span><\/i><\/p>\n<hr \/>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-7575 size-full\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/image5-e1566580669806.png\" alt=\"\" width=\"300\" height=\"134\" \/><\/p>\n<p><span style=\"font-weight: 400\"><strong><br \/>\nProyecto:<\/strong> Proyecta todas las $$16 y $$17 y mantiene las $$breweries.<\/span><\/p>\n<p><i><span style=\"font-weight: 400\"><br \/>\nSe trata de una operaci\u00f3n paralela que se reparte entre todos los nodos del cl\u00faster. <\/span><\/i><\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-7576\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/image4.png\" alt=\"\" width=\"300\" height=\"134\" \/><span style=\"font-weight: 400\">Exploraci\u00f3n de datos: Lee cada registro del conjunto de datos \"cervecer\u00edas\". \"vars\" es la lista de variables que se crean como resultado de esta operaci\u00f3n. La primera clave de cada registro se asigna a $$16, el registro completo se asigna a $$breweries y algunos metadatos del registro se asignan a $$17.<br \/>\n<\/span><i>Se trata de una operaci\u00f3n paralela que se reparte entre todos los nodos del cl\u00faster.<\/i><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>El plan explain es una gran herramienta para optimizar las consultas anal\u00edticas que se ejecutan en Couchbase Server y esta introducci\u00f3n deber\u00eda ayudar a desmitificar el plan e interpretarlo. Puedes probarlo t\u00fa mismo descargando la \u00faltima versi\u00f3n <a href=\"https:\/\/www.couchbase.com\/blog\/es\/downloads\/\">Servidor Couchbase 6.5<\/a> y participa con nosotros en<a href=\"https:\/\/www.couchbase.com\/blog\/es\/forums\/c\/analytics\/\"> foros<\/a> para obtener respuesta a sus preguntas.<\/p>","protected":false},"excerpt":{"rendered":"<p>Co-author:\u00a0 Till Westmann,\u00a0 Senior Director, Engineering Introduction Couchbase Analytics is the \u201cnewest kid on the block\u201d amongst all the services available in Couchbase Server. The new service is providing rapid time to insight in many use cases like ship to [&hellip;]<\/p>","protected":false},"author":559,"featured_media":7475,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1815,2294,1821,1816,1812],"tags":[1829,1725],"ppma_author":[9052],"class_list":["post-7568","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-best-practices-and-tutorials","category-analytics","category-couchbase-architecture","category-couchbase-server","category-n1ql-query","tag-bi","tag-nosql-database"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.7.1 (Yoast SEO v25.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Analytics Explain Plan - Part 1 - The Couchbase Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/es\/analytics-explain-plan-part-1\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Analytics Explain Plan - Part 1\" \/>\n<meta property=\"og:description\" content=\"Co-author:\u00a0 Till Westmann,\u00a0 Senior Director, Engineering Introduction Couchbase Analytics is the \u201cnewest kid on the block\u201d amongst all the services available in Couchbase Server. The new service is providing rapid time to insight in many use cases like ship to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/es\/analytics-explain-plan-part-1\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-04T18:48:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T02:27:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png\" \/>\n\t<meta property=\"og:image:width\" content=\"893\" \/>\n\t<meta property=\"og:image:height\" content=\"332\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sachin Smotra, Director Product Management, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@smotras\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sachin Smotra, Director Product Management, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/\"},\"author\":{\"name\":\"Sachin Smotra, Director Product Management, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/b0afdfaea6775eaf75096b65e7791f9a\"},\"headline\":\"Analytics Explain Plan &#8211; Part 1\",\"datePublished\":\"2019-09-04T18:48:42+00:00\",\"dateModified\":\"2025-06-14T02:27:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/\"},\"wordCount\":872,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png\",\"keywords\":[\"BI\",\"NoSQL Database\"],\"articleSection\":[\"Best Practices and Tutorials\",\"Couchbase Analytics\",\"Couchbase Architecture\",\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/\",\"name\":\"Analytics Explain Plan - Part 1 - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png\",\"datePublished\":\"2019-09-04T18:48:42+00:00\",\"dateModified\":\"2025-06-14T02:27:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png\",\"width\":893,\"height\":332},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analytics Explain Plan &#8211; Part 1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/b0afdfaea6775eaf75096b65e7791f9a\",\"name\":\"Sachin Smotra, Director Product Management, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/e0fd86aac479bbde276340e2945bbd5c\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/351d2ab52ac22b2cfdfc83ff4a2dc0b377d8316ecb298656b8c1a5f9e70a141b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/351d2ab52ac22b2cfdfc83ff4a2dc0b377d8316ecb298656b8c1a5f9e70a141b?s=96&d=mm&r=g\",\"caption\":\"Sachin Smotra, Director Product Management, Couchbase\"},\"description\":\"Sachin Smotra\u2019s career spans more than 15 years building software products across various domains including Java Enterprise software, DRM Solutions for mobile games and web conferencing. As Director Product Management at Couchbase, he is a hands-on product leader responsible for Couchbase Mobile, IOT and Analytics product lines including evangelizing the product strategy and vision with customers, partners, developers and analysts. Before joining Couchbase, Sachin was a Senior Manager, Product Management, at Cisco WebEx where he led the product team responsible for transforming the end to end Customer Experience across the WebEx product lifecycle - consideration, purchase, usage and renewals. Prior to his time at Cisco, Sachin worked at different startups in a multitude of roles across engineering, architecture, product management and alliances.\",\"sameAs\":[\"https:\/\/x.com\/smotras\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/es\/author\/ssmotra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Analytics Explain Plan - Part 1 - The Couchbase Blog","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:\/\/www.couchbase.com\/blog\/es\/analytics-explain-plan-part-1\/","og_locale":"es_MX","og_type":"article","og_title":"Analytics Explain Plan - Part 1","og_description":"Co-author:\u00a0 Till Westmann,\u00a0 Senior Director, Engineering Introduction Couchbase Analytics is the \u201cnewest kid on the block\u201d amongst all the services available in Couchbase Server. The new service is providing rapid time to insight in many use cases like ship to [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/es\/analytics-explain-plan-part-1\/","og_site_name":"The Couchbase Blog","article_published_time":"2019-09-04T18:48:42+00:00","article_modified_time":"2025-06-14T02:27:39+00:00","og_image":[{"width":893,"height":332,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png","type":"image\/png"}],"author":"Sachin Smotra, Director Product Management, Couchbase","twitter_card":"summary_large_image","twitter_creator":"@smotras","twitter_misc":{"Written by":"Sachin Smotra, Director Product Management, Couchbase","Est. reading time":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/"},"author":{"name":"Sachin Smotra, Director Product Management, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/b0afdfaea6775eaf75096b65e7791f9a"},"headline":"Analytics Explain Plan &#8211; Part 1","datePublished":"2019-09-04T18:48:42+00:00","dateModified":"2025-06-14T02:27:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/"},"wordCount":872,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png","keywords":["BI","NoSQL Database"],"articleSection":["Best Practices and Tutorials","Couchbase Analytics","Couchbase Architecture","Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/","url":"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/","name":"Analytics Explain Plan - Part 1 - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png","datePublished":"2019-09-04T18:48:42+00:00","dateModified":"2025-06-14T02:27:39+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png","width":893,"height":332},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/analytics-explain-plan-part-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Analytics Explain Plan &#8211; Part 1"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"El blog de Couchbase","description":"Couchbase, la base de datos NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"El blog de Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/b0afdfaea6775eaf75096b65e7791f9a","name":"Sachin Smotra, Director de Gesti\u00f3n de Productos, Couchbase","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/e0fd86aac479bbde276340e2945bbd5c","url":"https:\/\/secure.gravatar.com\/avatar\/351d2ab52ac22b2cfdfc83ff4a2dc0b377d8316ecb298656b8c1a5f9e70a141b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/351d2ab52ac22b2cfdfc83ff4a2dc0b377d8316ecb298656b8c1a5f9e70a141b?s=96&d=mm&r=g","caption":"Sachin Smotra, Director Product Management, Couchbase"},"description":"La carrera de Sachin Smotra abarca m\u00e1s de 15 a\u00f1os construyendo productos de software a trav\u00e9s de varios dominios incluyendo software Java Enterprise, Soluciones DRM para juegos m\u00f3viles y conferencias web. Como Director de Gesti\u00f3n de Producto en Couchbase, es un l\u00edder de producto responsable de las l\u00edneas de producto Couchbase Mobile, IOT y Analytics, incluyendo la evangelizaci\u00f3n de la estrategia de producto y la visi\u00f3n con los clientes, socios, desarrolladores y analistas. Antes de unirse a Couchbase, Sachin fue Gerente Senior, Gesti\u00f3n de Producto, en Cisco WebEx, donde dirigi\u00f3 el equipo de producto responsable de transformar la experiencia del cliente de extremo a extremo a trav\u00e9s del ciclo de vida del producto WebEx - consideraci\u00f3n, compra, uso y renovaciones. Antes de su etapa en Cisco, Sachin trabaj\u00f3 en diferentes startups en multitud de puestos relacionados con la ingenier\u00eda, la arquitectura, la gesti\u00f3n de productos y las alianzas.","sameAs":["https:\/\/x.com\/smotras"],"url":"https:\/\/www.couchbase.com\/blog\/es\/author\/ssmotra\/"}]}},"authors":[{"term_id":9052,"user_id":559,"is_guest":0,"slug":"ssmotra","display_name":"Sachin Smotra, Director Product Management, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/351d2ab52ac22b2cfdfc83ff4a2dc0b377d8316ecb298656b8c1a5f9e70a141b?s=96&d=mm&r=g","first_name":"Sachin","last_name":"Smotra, Director Product Management, Couchbase","user_url":"","author_category":"","description":"La carrera de Sachin Smotra abarca m\u00e1s de 15 a\u00f1os construyendo productos de software a trav\u00e9s de varios dominios incluyendo software Java Enterprise, Soluciones DRM para juegos m\u00f3viles y conferencias web. Como Director de Gesti\u00f3n de Producto en Couchbase, es un l\u00edder de producto responsable de las l\u00edneas de producto Couchbase Mobile, IOT y Analytics, incluyendo la evangelizaci\u00f3n de la estrategia y visi\u00f3n del producto con clientes, socios, desarrolladores y analistas.\r\n\r\nAntes de unirse a Couchbase, Sachin fue Gerente Senior, Gesti\u00f3n de Producto, en Cisco WebEx, donde dirigi\u00f3 el equipo de producto responsable de transformar la experiencia del cliente de extremo a extremo a trav\u00e9s del ciclo de vida del producto WebEx - consideraci\u00f3n, compra, uso y renovaciones. Antes de su etapa en Cisco, Sachin trabaj\u00f3 en diferentes startups en multitud de puestos relacionados con la ingenier\u00eda, la arquitectura, la gesti\u00f3n de productos y las alianzas."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/7568","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/users\/559"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/comments?post=7568"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/7568\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media\/7475"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media?parent=7568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/categories?post=7568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/tags?post=7568"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/ppma_author?post=7568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}