Re: Query hitting empty tables taking 48 minutes

[Robert Creager <robert@xxxxxxxxxxxxxxxx>]

On Jun 18, 2018, at 4:33 PM, Robert Creager <robert@xxxxxxxxxxxxxxxx> 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.