pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDisable sending query to obtain database performance information from pgAdmin4
5+ messages / 3 participants
[nested] [flat]
* Disable sending query to obtain database performance information from pgAdmin4
@ 2019-08-27 22:01 Andy Hsu <hhhsu7a@yahoo.com>
2019-08-27 23:11 ` Re: Disable sending query to obtain database performance information from pgAdmin4 Jeff Janes <jeff.janes@gmail.com>
2019-08-28 14:47 ` RE: Disable sending query to obtain database performance information from pgAdmin4 Igor Neyman <ineyman@perceptron.com>
0 siblings, 2 replies; 5+ messages in thread
From: Andy Hsu @ 2019-08-27 22:01 UTC (permalink / raw)
To: pgsql-admin
All,
We have used pgAdmin III for Greenplum database, postgresql 8.2. Recently, we upgraded to Greenplum postgresql 8.3 and switched to pgAdmin4.
We found that pgAdmin4 sends many sqls to obtain database performance, which filled up Greenplum log quickly.
I cannot find anywhere to disable these queries. Please advise on where and how to disable?
Thanks,Andy
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Disable sending query to obtain database performance information from pgAdmin4
2019-08-27 22:01 Disable sending query to obtain database performance information from pgAdmin4 Andy Hsu <hhhsu7a@yahoo.com>
@ 2019-08-27 23:11 ` Jeff Janes <jeff.janes@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Jeff Janes @ 2019-08-27 23:11 UTC (permalink / raw)
To: Andy Hsu <hhhsu7a@yahoo.com>; +Cc: pgsql-admin
On Tue, Aug 27, 2019 at 6:01 PM Andy Hsu <hhhsu7a@yahoo.com> wrote:
> All,
>
> We have used pgAdmin III for Greenplum database, postgresql 8.2. Recently,
> we upgraded to Greenplum postgresql 8.3 and switched to pgAdmin4.
>
> We found that pgAdmin4 sends many sqls to obtain database performance,
> which filled up Greenplum log quickly.
>
> I cannot find anywhere to disable these queries. Please advise on where
> and how to disable?
>
File -> Preferences -> Dashboard Display -> set "Show Graphs" to false.
Cheers,
Jeff
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Disable sending query to obtain database performance information from pgAdmin4
2019-08-27 22:01 Disable sending query to obtain database performance information from pgAdmin4 Andy Hsu <hhhsu7a@yahoo.com>
@ 2019-08-28 14:47 ` Igor Neyman <ineyman@perceptron.com>
2019-09-24 17:40 ` Re: Disable sending query to obtain database performance information from pgAdmin4 Andy Hsu <hhhsu7a@yahoo.com>
1 sibling, 1 reply; 5+ messages in thread
From: Igor Neyman @ 2019-08-28 14:47 UTC (permalink / raw)
To: Andy Hsu <hhhsu7a@yahoo.com>; pgsql-admin
From: Andy Hsu [mailto:hhhsu7a@yahoo.com]
Sent: Tuesday, August 27, 2019 6:01 PM
To: pgsql-admin@postgresql.org
Subject: Disable sending query to obtain database performance information from pgAdmin4
All,
We have used pgAdmin III for Greenplum database, postgresql 8.2. Recently, we upgraded to Greenplum postgresql 8.3 and switched to pgAdmin4.
We found that pgAdmin4 sends many sqls to obtain database performance, which filled up Greenplum log quickly.
I cannot find anywhere to disable these queries. Please advise on where and how to disable?
Thanks,
Andy
If you are still using postgresql 8.3, why switching to pgAdmin4? It’s not intended to be used with postgresql 8.3.
Just stay with pgAdmin III.
Regards,
Igor Neyman
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Disable sending query to obtain database performance information from pgAdmin4
2019-08-27 22:01 Disable sending query to obtain database performance information from pgAdmin4 Andy Hsu <hhhsu7a@yahoo.com>
2019-08-28 14:47 ` RE: Disable sending query to obtain database performance information from pgAdmin4 Igor Neyman <ineyman@perceptron.com>
@ 2019-09-24 17:40 ` Andy Hsu <hhhsu7a@yahoo.com>
2019-09-24 19:06 ` RE: Disable sending query to obtain database performance information from pgAdmin4 Igor Neyman <ineyman@perceptron.com>
0 siblings, 1 reply; 5+ messages in thread
From: Andy Hsu @ 2019-09-24 17:40 UTC (permalink / raw)
To: Igor Neyman <ineyman@perceptron.com>; pgsql-admin
When using pgAdmin 3 with Greenplum 5 (Postgres 8.3), an error pops up when accessing schema. Then, all view, functions, and sequences are not displayed.
Andy
Sent from Yahoo Mail for iPad
On Wednesday, August 28, 2019, 10:47 PM, Igor Neyman <ineyman@perceptron.com> wrote:
#yiv5627347758 #yiv5627347758 -- _filtered #yiv5627347758 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv5627347758 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv5627347758 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv5627347758 #yiv5627347758 p.yiv5627347758MsoNormal, #yiv5627347758 li.yiv5627347758MsoNormal, #yiv5627347758 div.yiv5627347758MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New serif;}#yiv5627347758 a:link, #yiv5627347758 span.yiv5627347758MsoHyperlink {color:#0563C1;text-decoration:underline;}#yiv5627347758 a:visited, #yiv5627347758 span.yiv5627347758MsoHyperlinkFollowed {color:#954F72;text-decoration:underline;}#yiv5627347758 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv5627347758 span.yiv5627347758EmailStyle18 {font-family:sans-serif;color:#1F497D;}#yiv5627347758 .yiv5627347758MsoChpDefault {font-size:10.0pt;} _filtered #yiv5627347758 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv5627347758 div.yiv5627347758WordSection1 {}#yiv5627347758
From: Andy Hsu [mailto:hhhsu7a@yahoo.com]
Sent: Tuesday, August 27, 2019 6:01 PM
To: pgsql-admin@postgresql.org
Subject: Disable sending query to obtain database performance information from pgAdmin4
All,
We have used pgAdmin III for Greenplum database, postgresql 8.2. Recently, we upgraded to Greenplum postgresql 8.3 and switched to pgAdmin4.
We found that pgAdmin4 sends many sqls to obtain database performance, which filled up Greenplum log quickly.
I cannot find anywhere to disable these queries. Please advise on where and how to disable?
Thanks,
Andy
If you are still usingpostgresql 8.3, why switching to pgAdmin4? It’s not intended to be used with postgresql 8.3.
Just stay with pgAdmin III.
Regards,
Igor Neyman
Attachments:
IMG_0113.JPG (image/jpeg, 79.0K) download
view image
* RE: Disable sending query to obtain database performance information from pgAdmin4
2019-08-27 22:01 Disable sending query to obtain database performance information from pgAdmin4 Andy Hsu <hhhsu7a@yahoo.com>
2019-08-28 14:47 ` RE: Disable sending query to obtain database performance information from pgAdmin4 Igor Neyman <ineyman@perceptron.com>
2019-09-24 17:40 ` Re: Disable sending query to obtain database performance information from pgAdmin4 Andy Hsu <hhhsu7a@yahoo.com>
@ 2019-09-24 19:06 ` Igor Neyman <ineyman@perceptron.com>
0 siblings, 0 replies; 5+ messages in thread
From: Igor Neyman @ 2019-09-24 19:06 UTC (permalink / raw)
To: Andy Hsu <hhhsu7a@yahoo.com>; pgsql-admin
From: Andy Hsu [mailto:hhhsu7a@yahoo.com]
Sent: Tuesday, September 24, 2019 1:41 PM
To: Igor Neyman <ineyman@perceptron.com>; pgsql-admin@postgresql.org
Subject: Re: Disable sending query to obtain database performance information from pgAdmin4
WARNING: This email originated from outside of Perceptron! Please be mindful of PHISHING and MALWARE risks.
When using pgAdmin 3 with Greenplum 5 (Postgres 8.3), an error pops up when accessing schema. Then, all view, functions, and sequences are not displayed.
Andy
[Inline image]
Sent from Yahoo Mail for iPad<https://overview.mail.yahoo.com/?.src=iOS;
Meaning, you need to find pgAdmin III version, which is compatible with Postgres 8.3.
Regards,
Igor Neyman
Attachments:
image001.jpg (image/jpeg, 79.0K) download
view image
end of thread, other threads:[~2019-09-24 19:06 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-08-27 22:01 Disable sending query to obtain database performance information from pgAdmin4 Andy Hsu <hhhsu7a@yahoo.com>
2019-08-27 23:11 ` Jeff Janes <jeff.janes@gmail.com>
2019-08-28 14:47 ` Igor Neyman <ineyman@perceptron.com>
2019-09-24 17:40 ` Andy Hsu <hhhsu7a@yahoo.com>
2019-09-24 19:06 ` Igor Neyman <ineyman@perceptron.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox