title: Where can i find Column Statistics in Redshift?
body: <p>Taking into consideration an example of hive tables / databricks:</p>
  <p>If I need column level statistics what i do is:</p>
  <pre><code>ANALYZE TABLE &lt;db.table&gt; COMPUTE STATISTICS FOR COLUMNS &lt;column&gt;
  
  
  DESCRIBE EXTENDED &lt;db.table&gt; &lt;column&gt;
  </code></pre>
  <p>Similarly I've seen there's no command called <code>DESCRIBE</code> in Redshift.</p>
  <p>Now i'm expecting the same workaround in Redshift.</p>
  <p>What is the output I am expecting:</p>
  <p>Statistics like:</p>
  <ol>
  <li>Min</li>
  <li>Max</li>
  <li>Avg Length</li>
  <li>Max Length</li>
  <li>Distinct</li>
  <li>Null</li>
  </ol>
  <p>What internal tables do i need to look into? Also if I need to join multiple internal tables to get the aforementioned stats.</p>