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

How to Run a pg_stats Query

From: "Y Sidhu" <ysidhu(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: How to Run a pg_stats Query
Date: 2007-05-15 22:42:01
Message-ID: b09064f30705151542w4c88298l1d5aa0a8a170bd50@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
I turned on all the stats in the conf file (below) and restarted the server.
Question is, what's the name of the database and how do I run a simple
select query?

stats_start_collector = true
stats_command_string = true
stats_block_level = true
stats_row_level = true
stats_reset_on_server_start = true

-- 
Yudhvir Singh Sidhu
408 375 3134 cell

Responses

pgsql-performance by date

Next:From: Alvaro HerreraDate: 2007-05-15 22:50:29
Subject: Re: How to Run a pg_stats Query
Previous:From: Y SidhuDate: 2007-05-15 20:18:42
Subject: Disk Fills Up and fsck "Compresses" it

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