pg_stat_user_tables

From: Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pg_stat_user_tables
Date: 2003-02-14 22:57:06
Message-ID: 3E4D7442.2070308@intransa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How come I don't see any activities from pg_stat_user_tables

pg=> select relid, n_tup_ins, n_tup_upd, n_tup_del from pg_stat_user_tables;

relid | n_tup_ins | n_tup_upd | n_tup_del
-------+-----------+-----------+-----------
16557 | 0 | 0 | 0
16562 | 0 | 0 | 0
16567 | 0 | 0 | 0
16573 | 0 | 0 | 0
16578 | 0 | 0 | 0
16583 | 0 | 0 | 0
16588 | 0 | 0 | 0
16594 | 0 | 0 | 0
16600 | 0 | 0 | 0
16606 | 0 | 0 | 0
16612 | 0 | 0 | 0
16618 | 0 | 0 | 0
16624 | 0 | 0 | 0
16630 | 0 | 0 | 0
16636 | 0 | 0 | 0
16642 | 0 | 0 | 0
16647 | 0 | 0 | 0
16652 | 0 | 0 | 0
16657 | 0 | 0 | 0
16663 | 0 | 0 | 0
16669 | 0 | 0 | 0
16675 | 0 | 0 | 0
16681 | 0 | 0 | 0
16686 | 0 | 0 | 0
16692 | 0 | 0 | 0
16698 | 0 | 0 | 0
16704 | 0 | 0 | 0
16709 | 0 | 0 | 0
16715 | 0 | 0 | 0
16721 | 0 | 0 | 0
16727 | 0 | 0 | 0
16733 | 0 | 0 | 0
16739 | 0 | 0 | 0
16745 | 0 | 0 | 0
16750 | 0 | 0 | 0
16756 | 0 | 0 | 0

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-02-14 23:23:11 Re: operators and bit field
Previous Message Marc G. Fournier 2003-02-14 22:55:34 Re: http://www.pgsql.com/advertising/ many Warning: