Re: Query hitting empty tables taking 48 minutes - Mailing list pgsql-general

From Robert Creager
Subject Re: Query hitting empty tables taking 48 minutes
Date
Msg-id 4457A071-1CE2-4936-BFD5-D93F629FF7AF@logicalchaos.org
Whole thread Raw
In response to Re: Query hitting empty tables taking 48 minutes  (Robert Creager <robert@logicalchaos.org>)
List pgsql-general


On Jun 18, 2018, at 4:33 PM, Robert Creager <robert@logicalchaos.org> wrote:

I cannot explain the discrepancy between the runtimes of 85 seconds versus 10857 seconds.

It would be nice if the auto_explain analyze did include the other information like the psql analyze does.

Like this.  I’ll try again.

auto_explain.log_triggers (boolean)
auto_explain.log_triggers causes trigger execution statistics to be included when an execution plan is logged. This parameter has no effect unless auto_explain.log_analyze is enabled. This parameter is off by default. Only superusers can change this setting.



pgsql-general by date:

Previous
From: Sherrylyn Branchaw
Date:
Subject: Re: What to do when dynamic shared memory control segment is corrupt
Next
From: Benjamin Scherrey
Date:
Subject: Re: High WriteLatency RDS Postgres 9.3.20