# -*- mode: snippet -*-
# name: list-tables-row-count-size
# key: ls-tables
# group: vertica
# condition: (if (string-equal sql-product 'vertica)t)
# --
SELECT tbl.table_schema AS "Schema Name",
       tbl.table_name AS "Table Name",
       to_char(sum(prs.row_count)/count(DISTINCT prs.projection_name), '999G999G999G999') AS "No Of Rows",
       to_char(sum(prs.used_bytes)/count(DISTINCT prs.projection_name), '999G999G999G999G999') AS "Size In Bytes"
FROM TABLES tbl
JOIN projections prj ON tbl.table_id = prj.anchor_table_id
JOIN projection_storage prs ON prj.projection_name = prs.projection_name
GROUP BY 1, 2
ORDER BY 1, 2;$0