Re: Reseting statistics counters

From: Strahinja Kustudić <strahinjak(at)nordeus(dot)com>
To: Xenofon Papadopoulos <xpapad(at)gmail(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Reseting statistics counters
Date: 2013-11-16 19:49:19
Message-ID: CADKbJJW3W8n6MWh3qzxutAKo5Dx176X5iTzDo6xxM8n3y4Ro2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Sorry for the late reply, but as far as I know when you run pg_stat_reset()
you should always run analyze manually of the database to populate the
statistics.

Strahinja Kustudić | Lead System Engineer | Nordeus

On Tue, Oct 1, 2013 at 1:50 PM, Xenofon Papadopoulos <xpapad(at)gmail(dot)com>wrote:

> If we reset the statistics counters using pg_stat_reset() will it affect
> the performance of the database? Eg are these the same statistics used by
> the planner?
> Thanks
>
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rogerio Pereira 2013-11-18 16:38:09 Query in cache
Previous Message Patrick Krecker 2013-11-15 22:24:53 General slowness when retrieving a relatively small number of rows