Thread: How to Run a pg_stats Query
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
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
Y Sidhu escribió: > 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 Stats are present on all databases. As for the name of the tables, try pg_stat_user_tables and pg_stat_activity for starters. There are a lot more; check the documentation or a \d pg_stat* in psql. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support