Skip site navigation (1) Skip section navigation (2)

Bug #758: show_planner_stats does not work for new PREPARE calls

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #758: show_planner_stats does not work for new PREPARE calls
Date: 2002-09-06 04:17:48
Message-ID: 20020906041748.6DC96475F62@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
Barry Lind (barry(at)xythos(dot)com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
show_planner_stats does not work for new PREPARE calls

Long Description
I was testing the 7.3 PREPARE functionality.  I was using the timing information from show_parser_stats, show_planner_stats, show_executor_stats to compare times with and without using PREPARE.  But unfortunatly no planing timing information is shown when using PREPARE so I can't see the total before and after information.  Since all PREPARE is doing is parsing and planning the statement, it makes sense that it would show the planning information when show_planner_stats is enabled?

Sample Code


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Bruno Wolff IIIDate: 2002-09-06 04:59:48
Subject: atan2 documentation bugs for 7.3 and 7.2
Previous:From: Bruce MomjianDate: 2002-09-06 02:32:40
Subject: Re: [BUGS] Bug #756: suggestion: file with password instead

pgsql-patches by date

Next:From: Yury BokhoncovichDate: 2002-09-06 06:04:14
Subject: Big number of "unused" pages as reported by VACUUM
Previous:From: Bruce MomjianDate: 2002-09-06 02:32:40
Subject: Re: [BUGS] Bug #756: suggestion: file with password instead

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group