Performance Endpoints

[vmesel]

Performance Endpoints

[vmesel]

I was thinking of adding an endpoint to add this query:

SELECT table_catalog as database,
       table_schema as schema,
       table_name,
       table_type as type,
       sub.total_size as total_size,
       sub.data_size as data_size,
       sub.indexes_size as indexes_size
       FROM information_schema.tables natural join (
    SELECT relname as table_name,
    pg_size_pretty(pg_total_relation_size(relid)) as total_size,
    pg_size_pretty(pg_relation_size(relid)) as data_size,
    pg_size_pretty(pg_indexes_size(relid)) as indexes_size
    FROM pg_catalog.pg_statio_user_tables
    ) sub

And others for alignment-checking and performance tuning.

[avelino]

@vmesel I like to have endpoints that give metrics about the connected bank, but I feel that this should not be part of prestd's core.

Why not in the core?
it is not essential endpoint and not all users would use it

as a plugin it makes much more sense