Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

2017-05-25 Thread Scott Mead
On Thu, May 25, 2017 at 9:20 PM, Steven Chang wrote: > Hello Scott, > > Nagios is an alert system, I guess the check_postgres module is in > use. > EM Grid is a management console whose functions are not just alert , > but also remote control, etc. > > Hello Ravi, > > From a open

Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

2017-05-25 Thread Steven Chang
Hello Scott, Nagios is an alert system, I guess the check_postgres module is in use. EM Grid is a management console whose functions are not just alert , but also remote control, etc. Hello Ravi, From a open source standing, I propose pgcluu. But it doesn't include remote control

Re: [PERFORM] Monitoring tool for Postgres Database

2017-05-25 Thread Gary Evans
Hi Ravi, > What is the best monitoring tool for Postgres database? Something like > Oracle Enterprise Manager. > If you're an existing user of OEM, there is a PostgreSQL plugin for it by Blue Medora (believe it is commercial). You might like to have a look at it. > > > Specifically I am intere

Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

2017-05-25 Thread Scott Whitney
Personally I push those off to my network monitor. Nagios in my case. I find a single integrated alert and escalation framework is better than individual tools, but that's just me. If you're using Nagios, let me know, and I can pop you several stub scripts to help. On May 25, 2017 2:50 PM, Rav

[PERFORM] Monitoring tool for Postgres Database

2017-05-25 Thread Ravi Tammineni
Hi, What is the best monitoring tool for Postgres database? Something like Oracle Enterprise Manager. Specifically I am interested in tools to help: Alert DBAs to problems with both configuration and performance issues Deadlocks, Long running queries etc., Monitoring of overall system performan

[PERFORM] Multicolumn B-Tree index - order by on 1st column and IN lookup for 2nd

2017-05-25 Thread Alexandru Lazarev
I created such table (similar to example from http://use-the-index-luke.com/sql/example-schema/postgresql/performance-testing-scalability ) CREATE TABLE scale_data ( section NUMERIC NOT NULL, id1 NUMERIC NOT NULL, -- unique values simulating ID or Timestamp id2 NUMERIC NOT NULL --

Re: FW: Re: [PERFORM] Query is running very slow......

2017-05-25 Thread Tomas Vondra
On 5/25/17 2:26 PM, Dinesh Chandra 12108 wrote: Hi Tomas, Please find the below input for slow query. (a) something about the hardware it's running on RAM-->64 GB, CPU->40core (b) amounts of data in the tables / databases Database size :32GB - Tables size

FW: Re: [PERFORM] Query is running very slow......

2017-05-25 Thread Dinesh Chandra 12108
Hi Tomas, Please find the below input for slow query. (a) something about the hardware it's running on RAM-->64 GB, CPU->40core (b) amounts of data in the tables / databases Database size :32GB - Tables size - Workflow.project: 8194 byte workflo

Re: [PERFORM] Delete, foreign key, index usage

2017-05-25 Thread Johann Spies
On 4 April 2017 at 14:07, Johann Spies wrote: > While updating our database which includes a lot of deletions where a lot > of foreign key references are involved we found that in the case of two > tables the indexes are ignored and it slow down the process a lot. > ... > > > Why would that be?

Re: [PERFORM] Query is very much slow

2017-05-25 Thread Andreas Kretschmer
Hi, there is a similar question from dinesh.chan...@cyient.com, but it is not exact the same query. [PERFORM] Query is running very slow.., some hours ago. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com -- Sent via pgsql-performance mailing list

Re: [PERFORM] Query is very much slow

2017-05-25 Thread Andreas Kretschmer
Am 25.05.2017 um 07:13 schrieb Daulat Ram: Hi team, We are getting very slow response of this query. SELECT date_trunc('day', insert_time),workflow.project.project_name, workflow.tool_performance.project_id,workflow.tool_performance.user_id,workflow.tool_performance.step_id,count(*), round