The following bug has been logged on the website:
Bug reference: 12012
Logged by: Alexey Shuranov
Email address: al.shuranov@gmail.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