How to find size of a schema (table) in Adobe Campaign Classic V7 in console

[ravitejagundu]

Hi Team,

I want to know how to find the size of a schema (table) in Adobe Campaign Classic v7 via Console. Please let us know if there is any possibility to find out the size directly in the Campaign Console instead of checking it in the Control Panel.

Thanks,

Raviteja Gundu

[Marcel_Szimonisz · Accepted solution]

Hello @ravitejagundu ,

i think there is no dashboard to show you table space. But if your user can run SQL commands you can create your own dashboard in email or webapp, with use of sqlSelect JSAPI function https://experienceleague.adobe.com/developer/campaign-api/api/f-sqlSelect.html

To find the size of a table in e.g. PostgreSQL db engine, you can use the following SQL query:

SELECT pg_size_pretty(pg_total_relation_size('your_table_name'));

Replace 'your_table_name' with the actual name of the table you want to find the size of.

This query will return the size of the table in a human-readable format, such as "23 MB" or "1 GB". The pg_total_relation_size function returns the total size of the table including all indexes and associated objects, and pg_size_pretty formats the size in a readable format.

In Adobe Campaign JS  you can do

var res = sqlSelect("table,@size:number",
        "SELECT pg_size_pretty(pg_total_relation_size('nmsGroup'))")
logInfo(res.table.@size)

>> 04/06/2023 4:55:16 AM js 160 kB

Marcel Szimonisz

MarTech Consultant
for more tips visit my blog
https://www.martechnotes.com/

[ravitejagundu]

Hi Marcel,

The sqlSelect command in JS worked perfectly. Now, I can able to see the size of the table now.

Appreciating your Swift response.

Thanks,

Raviteja Gundu.