pgAdmin4 query

From: Polgár Benedek <polgar(dot)benedek(at)otpmobil(dot)com>
To: "dpage(at)pgadmin(dot)org" <dpage(at)pgadmin(dot)org>, "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: pgAdmin4 query
Date: 2019-06-13 13:30:39
Message-ID: VE1PR01MB5903FE339B42BA2C33E56E57F4EF0@VE1PR01MB5903.eurprd01.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)benedek(at)otpmobil(dot)com<mailto:polgar(dot)benedek(at)otpmobil(dot)com>

[cid:image001(dot)png(at)01CF9768(dot)53366360]

Tel.: +36-1-776-6901
Fax: +36-1-776-6902
1093 Budapest, Közraktár u. 30-32.
RiverPark, K30. épület, II. emelet

[cid:image002(dot)png(at)01D100FE(dot)9034AF00]<https://itunes.apple.com/us/app/simple-labs/id819236628?ls=1&mt=8> [cid:image003(dot)png(at)01D100FE(dot)9034AF00] <https://play.google.com/store/apps/details?id=com.otpmobil.simple>

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Murtuza Zabuawala 2019-06-13 16:16:16 Re: pgAdmin4 query
Previous Message Dave Page 2019-06-12 12:27:08 Re: How to disable the SSLv3 and TLS 1.0 and weak ciphers in pgAdmin 4.1