https://docs.dataedo.com/assets/js/2adaf023.4809d247.js

1"use strict";(self.webpackChunkdataedo=self.webpackChunkdataedo||[]).push([["18555"],{91331:function(a,e,t){t.r(e),t.d(e,{frontMatter:()=>o,default:()=>c,toc:()=>u,metadata:()=>r,assets:()=>d,contentTitle:()=>i});var r=JSON.parse('{"id":"data-sources/databases/amazon-redshift/amazon-redshift-table-statistics","title":"Amazon Redshift - Table Statistics","description":"","source":"@site/docs/data-sources/databases/amazon-redshift/amazon-redshift-table-statistics.mdx","sourceDirName":"data-sources/databases/amazon-redshift","slug":"/docs/documenting-technology/supported-databases/amazon-redshift-table-statistics","permalink":"/docs/documenting-technology/supported-databases/amazon-redshift-table-statistics","draft":false,"unlisted":false,"tags":[],"version":"current","lastUpdatedAt":1783588744000,"frontMatter":{"title":"Amazon Redshift - Table Statistics","description":"","slug":"/docs/documenting-technology/supported-databases/amazon-redshift-table-statistics"},"sidebar":"tutorialSidebar","previous":{"title":"Amazon Redshift","permalink":"/docs/documenting-technology/supported-databases/amazon-redshift"},"next":{"title":"Connecting to Amazon Redshift database","permalink":"/docs/documenting-technology/supported-databases/connecting-to-amazon-redshift"}}'),s=t(85893),l=t(50065),n=t(72629);t(88046);let o={title:"Amazon Redshift - Table Statistics",description:"",slug:"/docs/documenting-technology/supported-databases/amazon-redshift-table-statistics"},i=void 0,d={},u=[{value:"Imported Statistics",id:"imported-statistics",level:2},{value:"Requirements",id:"requirements",level:2},{value:"Limitations",id:"limitations",level:2},{value:"Learn more",id:"learn-more",level:2}];function D(a){let e={a:"a",h2:"h2",li:"li",p:"p",table:"table",tbody:"tbody",td:"td",th:"th",thead:"thead",tr:"tr",ul:"ul",...(0,l.a)(),...a.components};return(0,s.jsxs)(s.Fragment,{children:[(0,s.jsx)(e.h2,{id:"imported-statistics",children:"Imported Statistics"}),"\n",(0,s.jsx)(n.G,{children:(0,s.jsxs)(e.table,{children:[(0,s.jsx)(e.thead,{children:(0,s.jsxs)(e.tr,{children:[(0,s.jsx)(e.th,{children:"Statistics"}),(0,s.jsx)(e.th,{children:"Is imported"}),(0,s.jsx)(e.th,{children:"Description"})]})}),(0,s.jsxs)(e.tbody,{children:[(0,s.jsxs)(e.tr,{children:[(0,s.jsx)(e.td,{children:"Row count"}),(0,s.jsx)(e.td,{children:"\u2705"}),(0,s.jsx)(e.td,{children:"Indicates the number of rows in table"})]}),(0,s.jsxs)(e.tr,{children:[(0,s.jsx)(e.td,{children:"Last user query"}),(0,s.jsx)(e.td,{children:"\u2705"}),(0,s.jsx)(e.td,{children:"Time of last user SELECT operation on table"})]}),(0,s.jsxs)(e.tr,{children:[(0,s.jsx)(e.td,{children:"Number of user queries"}),(0,s.jsx)(e.td,{children:"\u2705"}),(0,s.jsx)(e.td,{children:"Number of user SELECT operation on table"})]}),(0,s.jsxs)(e.tr,{children:[(0,s.jsx)(e.td,{children:"Last user update"}),(0,s.jsx)(e.td,{children:"\u2705"}),(0,s.jsx)(e.td,{children:"Time of last user INSERT, UPDATE and DELETE operations on table"})]}),(0,s.jsxs)(e.tr,{children:[(0,s.jsx)(e.td,{children:"Number of user updates"}),(0,s.jsx)(e.td,{children:"\u2705"}),(0,s.jsx)(e.td,{children:"Sum of user INSERT, UPDATE and DELETE operations on table"})]}),(0,s.jsxs)(e.tr,{children:[(0,s.jsx)(e.td,{children:"Last load time"}),(0,s.jsx)(e.td,{children:"\u2705"}),(0,s.jsx)(e.td,{children:"Time of last user COPY command on table"})]})]})]})}),"\n",(0,s.jsx)(e.h2,{id:"requirements",children:"Requirements"}),"\n",(0,s.jsx)(e.p,{children:"Dataedo requires access to the following tables and views:"}),"\n",(0,s.jsxs)(e.ul,{children:["\n",(0,s.jsx)(e.li,{children:"pg_class"}),"\n",(0,s.jsx)(e.li,{children:"pg_namespace"}),"\n",(0,s.jsx)(e.li,{children:"SYS_QUERY_DETAIL"}),"\n",(0,s.jsx)(e.li,{children:"SYS_QUERY_HISTORY"}),"\n",(0,s.jsx)(e.li,{children:"SVV_TABLE_INFO"}),"\n"]}),"\n",(0,s.jsx)(e.h2,{id:"limitations",children:"Limitations"}),"\n",(0,s.jsxs)(e.ul,{children:["\n",(0,s.jsx)(e.li,{children:"Row number in the table is only an estimate used by the planner. It is updated by VACUUM, ANALYZE, and a few DDL commands such as CREATE INDEX. If the table has never yet been vacuumed or analyzed, row count is 0."}),"\n",(0,s.jsx)(e.li,{children:"SYS_QUERY_HISTORY is systematically purged by default from two to five days (depends on cluster workload and size)"}),"\n"]}),"\n",(0,s.jsx)(e.h2,{id:"learn-more",children:"Learn more"}),"\n",(0,s.jsxs)(e.p,{children:["Read more about table statistics import in ",(0,s.jsx)(e.a,{href:"/docs/documenting-technology/supported-databases/sql-server-table-statistics",children:"main article"})]})]})}function c(a={}){let{wrapper:e}={...(0,l.a)(),...a.components};return e?(0,s.jsx)(e,{...a,children:(0,s.jsx)(D,{...a})}):D(a)}},72629:function(a,e,t){t.d(e,{G:()=>c,Z:()=>f});var r=t(85893),s=t(67294);let l="tableRow_LPwX",n="tableCell_wbSM",o="tableCellFeature_XOaV";

1var i=JSON.parse('{"filter":{"mode":"column","field":"type","default":"current","options":[{"label":"Current Plans","value":"current"},{"label":"Legacy Plans","value":"legacy"},{"label":"All Plans","value":null}]},"highlightedRows":["Connectors","Automatic Data Lineage","Manual Data Lineage","Data Quality"],"pinnedLastRow":"Application","columns":[{"name":"Dataedo Essentials","type":"current"},{"name":"Dataedo Data Lineage","type":"current"},{"name":"Dataedo Data Quality","type":"current"},{"name":"Data Catalog","type":"legacy"},{"name":"Enterprise","type":"legacy"},{"name":"Metadata Manager","type":"legacy"},{"name":"Pro Plus","type":"legacy"},{"name":"Pro","type":"legacy"},{"name":"Data Dictionary","type":"legacy"}],"rows":[{"name":"Application","values":{"Dataedo Essentials":"Portal and Desktop","Dataedo Data Lineage":"Portal and Desktop","Dataedo Data Quality":"Portal and Desktop","Data Catalog":"Portal and Desktop","Enterprise":"Portal and Desktop","Metadata Manager":"Desktop only","Pro Plus":"Desktop only","Pro":"Desktop only","Data Dictionary":"Desktop only"}},{"name":"AI Autodocumentation","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Automatic Data Lineage","values":{"Dataedo Essentials":false,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":true,"Enterprise":true,"Metadata Manager":true,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Manual Data Lineage","values":{"Dataedo Essentials":false,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":true,"Enterprise":true,"Metadata Manager":true,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Metadata Sync","values":{"Dataedo Essentials":false,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Data Quality","values":{"Dataedo Essentials":false,"Dataedo Data Lineage":false,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Badges","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Glossary","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":true,"Enterprise":true,"Metadata Manager":true,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Domains","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":true,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Data Products","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Community","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":true,"Enterprise":true,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Data Classification","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":true,"Enterprise":true,"Metadata Manager":true,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Data Profiling","values":{"Dataedo Essentials":false,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":true,"Enterprise":true,"Metadata Manager":true,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Public API","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Reference Data","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":true,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Report Catalog","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":true,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Scheduler","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Schema Change Tracking","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":true,"Enterprise":true,"Metadata Manager":true,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Steward Hub","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Workflows","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Custom Fields","values":{"Dataedo Essentials":"100","Dataedo Data Lineage":"100","Dataedo Data Quality":"100","Data Catalog":"100","Enterprise":"100","Metadata Manager":"10","Pro Plus":"10","Pro":"5","Data Dictionary":"1"}},{"name":"Connectors","values":{"Dataedo Essentials":"All","Dataedo Data Lineage":"All","Dataedo Data Quality":"All","Data Catalog":"All","Enterprise":"All","Metadata Manager":"All","Pro Plus":"All","Pro":"All","Data Dictionary":"All"}},{"name":"ML Models Documentation","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"ER Diagrams","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Browser Extension","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Exports","values":{"Dataedo Essentials":false,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"Dashboards","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}},{"name":"History of changes in documentation","values":{"Dataedo Essentials":true,"Dataedo Data Lineage":true,"Dataedo Data Quality":true,"Data Catalog":false,"Enterprise":false,"Metadata Manager":false,"Pro Plus":false,"Pro":false,"Data Dictionary":false}}]}'),d=JSON.parse('{"filter":{"mode":"row","field":"group","default":"General actions","options":[{"label":"General actions","value":"General actions"},{"label":"Community actions","value":"Community actions"},{"label":"Basic actions","value":"Basic actions"},{"label":"Advanced actions","value":"Advanced actions"}]},"columns":[{"name":"Admin"},{"name":"Approver"},{"name":"Connection Manager"},{"name":"Data Community Member"},{"name":"Data Steward"},{"name":"Explorer"},{"name":"Power Data Steward"},{"name":"Viewer"}],"rows":[{"name":"Access Dataedo Portal","group":"General actions","values":{"Admin":true,"Approver":true,"Connection Manager":true,"Data Community Member":true,"Data Steward":true,"Explorer":true,"Power Data Steward":true,"Vie

1wer":true}},{"name":"Admin","group":"General actions","values":{"Admin":true,"Approver":false,"Connection Manager":false,"Data Community Member":false,"Data Steward":false,"Explorer":false,"Power Data Steward":false,"Viewer":false}},{"name":"Manage Connections","group":"General actions","values":{"Admin":false,"Approver":false,"Connection Manager":true,"Data Community Member":false,"Data Steward":false,"Explorer":false,"Power Data Steward":false,"Viewer":false}},{"name":"Edit Community","group":"Community actions","values":{"Admin":true,"Approver":false,"Connection Manager":false,"Data Community Member":true,"Data Steward":true,"Explorer":false,"Power Data Steward":true,"Viewer":false}},{"name":"View Community","group":"Community actions","values":{"Admin":true,"Approver":false,"Connection Manager":true,"Data Community Member":true,"Data Steward":true,"Explorer":false,"Power Data Steward":true,"Viewer":false}},{"name":"Edit Documentation","group":"Basic actions","values":{"Admin":false,"Approver":true,"Connection Manager":false,"Data Community Member":false,"Data Steward":true,"Explorer":false,"Power Data Steward":true,"Viewer":false}},{"name":"View Documentation","group":"Basic actions","values":{"Admin":true,"Approver":true,"Connection Manager":true,"Data Community Member":true,"Data Steward":true,"Explorer":true,"Power Data Steward":true,"Viewer":true}},{"name":"View History","group":"Basic actions","values":{"Admin":true,"Approver":false,"Connection Manager":true,"Data Community Member":false,"Data Steward":true,"Explorer":false,"Power Data Steward":true,"Viewer":false}},{"name":"View Schema Changes","group":"Basic actions","values":{"Admin":true,"Approver":false,"Connection Manager":true,"Data Community Member":false,"Data Steward":true,"Explorer":false,"Power Data Steward":true,"Viewer":false}},{"name":"Assign Badges","group":"Advanced actions","values":{"Admin":false,"Approver":false,"Connection Manager":false,"Data Community Member":false,"Data Steward":true,"Explorer":false,"Power Data Steward":true,"Viewer":false}},{"name":"Generate Descriptions Powered By AI","group":"Advanced actions","values":{"Admin":false,"Approver":false,"Connection Manager":false,"Data Community Member":false,"Data Steward":true,"Explorer":false,"Power Data Steward":true,"Viewer":false}},{"name":"Manage External Queries","group":"Advanced actions","values":{"Admin":false,"Approver":false,"Connection Manager":false,"Data Community Member":false,"Data Steward":false,"Explorer":false,"Power Data Steward":true,"Viewer":false}},{"name":"View Connection Info","group":"Advanced actions","values":{"Admin":true,"Approver":false,"Connection Manager":true,"Data Community Member":false,"Data Steward":true,"Explorer":false,"Power Data Steward":true,"Viewer":false}},{"name":"View Data Profiling Stats","group":"Advanced actions","values":{"Admin":true,"Approver":false,"Connection Manager":true,"Data Community Member":true,"Data Steward":true,"Explorer":true,"Power Data Steward":true,"Viewer":false}},{"name":"View Quality and Profiling Data","group":"Advanced actions","values":{"Admin":true,"Approver":false,"Connection Manager":true,"Data Community Member":true,"Data Steward":true,"Explorer":true,"Power Data Steward":true,"Viewer":false}},{"name":"View Scripts","group":"Advanced actions","values":{"Admin":true,"Approver":false,"Connection Manager":true,"Data Community Member":true,"Data Steward":true,"Explorer":true,"Power Data Steward":true,"Viewer":false}}]}'),u=t(42032);let D={plans_overview:i,roles_permissions_table:d},c=({children:a,wide:e=!1})=>(0,r.jsx)("div",{className:`markdownTableWrapper_fC_J ${e?"markdownTableWrapperWide_Eudh":""}`,children:(0,u.JR)(a)}),f=({dataKey:a="plans_overview",stickyHeader:e=!1})=>{let t=D[a]||null,i=t?.filter,d=i?.default??i?.options?.[0]?.value??null,[c,f]=(0,s.useState)(d);if(!t)return(0,r.jsxs)("div",{children:["Unknown table: ",a]});let{columns:m,rows:p,highlightedRows:g=[],pinnedLastRow:h}=t,y=m,v=p;if(i&&null!=c&&("column"===i.mode?y=m.filter(a=>a[i.field]===c):"row"===i.mode&&(v=p.filter(a=>a[i.field]===c))),!i||"column"===i.mode){let a=v.map(a=>a.name),e=g.filter(e=>a.includes(e)),t=h&&a.includes(h)?[h]:[],r=a.filter(a=>!e.includes(a)&&!t.includes(a)).sort((a,e)=>a.localeCompare(e));v=[...e,...r,...t].map(a=>p.find(e=>

1e.name===a)).filter(Boolean)}return(0,r.jsxs)(r.Fragment,{children:[i&&(0,r.jsx)("div",{className:"filterButtonsContainer_Nfae",children:i.options.map(a=>(0,r.jsx)("button",{className:`filterButton_h1Qf ${c===a.value?"filterButtonActive_iv0Y":""}`,onClick:()=>f(a.value),children:a.label},a.label))}),(0,r.jsx)("div",{className:`tableWrapper_tenR ${e?"tableWrapperSticky_cMGj":""}`,children:(0,r.jsxs)("div",{className:`tableInner_UBZr ${y.length<=3?"tableInnerFixed_Be5Z":""}`,children:[(0,r.jsxs)("div",{className:`${l} ${e?"tableRowSticky_GJw4":""}`,children:[(0,r.jsx)("div",{className:`${n} ${o}`}),y.map(a=>(0,r.jsx)("div",{className:`${n} tableCellHeader_vLpc`,children:a.name},a.name))]}),v.map(a=>(0,r.jsxs)("div",{className:l,children:[(0,r.jsx)("div",{className:`${n} ${o}`,children:a.name}),y.map(e=>{var t;return(0,r.jsx)("div",{className:n,children:null==(t=a.values?.[e.name])?(0,r.jsx)(u.b0,{}):"string"==typeof t?t:t?(0,r.jsx)(u.nQ,{}):(0,r.jsx)(u.b0,{})},e.name)})]},a.name))]})})]})}},42032:function(a,e,t){t.d(e,{JR:()=>function a(e){return s.Children.map(e,e=>{if("string"==typeof e){let a=e.split(i),t=e.match(i);return t?a.reduce((a,e,s)=>{if(e&&a.push(e),t[s]){let e=o[t[s]];a.push((0,r.jsx)(e,{},s))}return a},[]):e}return s.isValidElement(e)&&e.props.children?s.cloneElement(e,{children:a(e.props.children)}):e})},b0:()=>n,nQ:()=>l});var r=t(85893),s=t(67294);let l=()=>(0,r.jsx)("svg",{width:"16",height:"16",viewBox:"0 0 16 16",fill:"none",xmlns:"http://www.w3.org/2000/svg",children:(0,r.jsx)("path",{d:"M3.33325 7.99984L6.66659 11.3332L13.3333 4.6665",stroke:"#447E35",strokeLinecap:"round",strokeLinejoin:"round"})}),n=()=>(0,r.jsx)("svg",{width:"16",height:"16",viewBox:"0 0 16 16",fill:"none",xmlns:"http://www.w3.org/2000/svg",children:(0,r.jsx)("path",{d:"M12 4L4 12M4 4L12 12",stroke:"#B93C36",strokeLinecap:"round",strokeLinejoin:"round"})}),o={"\u2705":l,"\u2713":l,"\u2714":l,"\u274C":n},i=RegExp(`[${Object.keys(o).join("")}]`,"g")}}]);