Object table count records and procedure executed

Help Procedural SQL
1

Hi Team

is there any options in memsql to show the count of records in each table and
is there any option to check when the procedure is executed recently date like that…?

2

You can sum up row counts from information_schema.table_statistics. You need to group by db name and table name and sum the ROWS column.

select database_name, table_name, sum(rows) from table_statistics group by 1, 2;

3

There’s no built in feature to record the last time an SP was run. See information_schema.routines for info. kept about SPs.

If you really need this, you can add a line to each SP to record it’s db name, sp name, and the current time in a table in a user database.