Re: pgAdmin4 query - Mailing list pgadmin-support

Dear Support Team!

 

We find that The gpAdmin4 generates too many query.

 

for example:

SELECT 'session_stats' AS chart_name, row_to_json(t) AS chart_data

        FROM (SELECT

           (SELECT count(*) FROM pg_stat_activity WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1433952)) AS "Total",

           (SELECT count(*) FROM pg_stat_activity WHERE state = 'active' AND datname = (SELECT datname FROM pg_database WHERE oid = 1433952))  AS "Active",

           (SELECT count(*) FROM pg_stat_activity WHERE state = 'idle' AND datname = (SELECT datname FROM pg_database WHERE oid = 1433952))  AS "Idle"

        ) t

        UNION ALL

        SELECT 'tps_stats' AS chart_name, row_to_json(t) AS chart_data

        FROM (SELECT

           (SELECT sum(xact_commit) + sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1433952)) AS "Transactions",

           (SELECT sum(xact_commit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1433952)) AS "Commits",

           (SELECT sum(xact_rollback) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1433952)) AS "Rollbacks"

        ) t

        UNION ALL

        SELECT 'ti_stats' AS chart_name, row_to_json(t) AS chart_data

        FROM (SELECT

           (SELECT sum(tup_inserted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1433952)) AS "Inserts",

           (SELECT sum(tup_updated) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1433952)) AS "Updates",

           (SELECT sum(tup_deleted) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1433952)) AS "Deletes"

        ) t

        UNION ALL

        SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data

        FROM (SELECT

           (SELECT sum(tup_fetched) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1433952)) AS "Fetched",

           (SELECT sum(tup_returned) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1433952)) AS "Returned"

        ) t

        UNION ALL

        SELECT 'bio_stats' AS chart_name, row_to_json(t) AS chart_data

        FROM (SELECT

           (SELECT sum(blks_read) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1433952)) AS "Reads",

           (SELECT sum(blks_hit) FROM pg_stat_database WHERE datname = (SELECT datname FROM pg_database WHERE oid = 1433952)) AS "Hits"

        ) t

 

 

Can I disable these queries?

 

______________________________________________________________

Best Regardsl:

 

Benedek Polgár

System administrator

 

polgar.benedek@otpmobil.com

 

 

Tel.: +36-1-776-6901

Fax: +36-1-776-6902

1093 Budapest, Közraktár u. 30-32.

RiverPark, K30. épület, II. emelet