Before and after analyze:
select schemaname,relid,indexrelid,relname,indexrelname from
pg_stat_all_indexes where relname='input_transaction_snbs';
schemaname | relid | indexrelid |relname |
indexrelname
On Tue, Jul 3, 2012 at 12:48 PM, Samuel Stearns
sstea...@internode.com.auwrote:
Before and after analyze:
** **
select schemaname,relid,indexrelid,relname,indexrelname from
pg_stat_all_indexes where relname='input_transaction_snbs';
** **
schemaname | relid |
On 06/25/2012 11:40 AM, Rob Cowell wrote:
Why would the output from ‘ls’ show older filenames (013D...xx)
as newer in date than the “013F...xx” filenames?
Does Postgres re-cycle old log filenames ?
It recycles old log files. If you turn on log_checkpoints, you can see
how
Ok, that returns only the 1 row:
SELECT idstat.indexrelid as indexrelid,
idstat.schemaname AS schema_name,
idstat.relname AS table_name,
idstat.indexrelname AS index_name,
idstat.idx_scan AS times_used,
idstat.idx_scan AS times_used,
Hi Friends
Can u please suggest me any web client tool for administrating postgres
database.(like OEM for oracle)
Thanks in Advance.
Regards
Madhu.Lanka
On Wed, Jul 4, 2012 at 7:09 AM, Samuel Stearns sstea...@internode.com.auwrote:
Ok, that returns only the 1 row:
** **
SELECT idstat.indexrelid as indexrelid,
idstat.schemaname AS schema_name,
idstat.relname AS table_name,
idstat.indexrelname AS
You can use trail version of PEM, a product of EnterpriseDB. Am not a
sales guy :), just came out as you said the word Like OEM for oracle.
http://www.enterprisedb.com/products-services-training/products/postgres-enterprise-manager
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog:
On Wed, Jul 4, 2012 at 10:25 AM, Madhu.Lanka mla...@avineonindia.comwrote:
Hi Friends
** **
Can u please suggest me any web client tool for administrating postgres
database.(like OEM for oracle)
** **
**
You can monitor PostgreSQL with Zabbix tool: