BUG #12012: After the upgrade PostgreSQL 9.2.4 -> 9.2.9 Missing "actual time" in auto_explain plans

From: al(dot)shuranov(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12012: After the upgrade PostgreSQL 9.2.4 -> 9.2.9 Missing "actual time" in auto_explain plans
Date: 2014-11-20 12:31:03
Message-ID: 20141120123103.2473.83371@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 12012
Logged by: Alexey Shuranov
Email address: al(dot)shuranov(at)gmail(dot)com
PostgreSQL version: 9.2.9
Operating system: CentOS release 6.4 (Final)
Description:

Hello!
After the upgrade PostgreSQL 9.2.4 -> 9.2.9 Missing "actual time" in
auto_explain plans, as a bug 11939 PostgreSQL 9.3.5
OS: CentOS release 6.4 (Final)
PostgreSQL:
version
--------------------------------------------------------------------------------------------------------------
PostgreSQL 9.2.9 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-4), 64-bit

2014-11-12 15:24:20 MSK [7039:6/1332713] [pg-monitor] xx.xx.xx.xx(57549)
pg-monitor-copy-log-cp$plan LOG: duration: 130.452 ms plan:
Query Text: INSERT INTO plan VALUES(NEW.*)
Insert on plan (cost=0.00..0.01 rows=1 width=0) (actual rows=0
loops=1)
Buffers: shared hit=59 read=24 dirtied=12
-> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1
loops=1)

Thanks, Alexey

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2014-11-20 14:06:10 Re: BUG #12008: REASSIGN OWNED changes other databases
Previous Message bashtanov 2014-11-20 12:23:49 BUG #12011: information_schema.constraint_column_usage is slow