Keboola WIKI‎ > ‎Old Articles‎ > ‎Data Tips & Tricks‎ > ‎

Find out number of rows and size of your tables

by martin.matejka@keboola.com

Because of performance, KBC isn't showing real row count of the tables in SAPI.
If you need to determine no. of rows which you are storing in SAPI or importing to GD, you need to use the Sandbox. But you don't need to do SELECT COUNT(*) for every table you've uploaded to Sandbox. Just use one simple SQL statement:

SELECT SUM(TABLE_ROWS) 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA = 'tapi_XXXXX_sand';

To show rows per table:

SELECT
table_name,
table_rows
FROM information_schema.tables
WHERE information_schema = 'sand_xxx_xxxxx';

To show sizes of tables in MB:

SELECT 
table_name AS `Tables`,
round(((data_length + index_length) / 1024 / 1024), 2) AS `Size in MB`
FROM informaton_schema.tables
WHERE information_schema = 'sand_xxx_xxxxx';



Comments