to find table stats for last update time. - Mailing list pgsql-novice

Hi All,

Is there any way to find out the most recent update time for a table in postgres like the mysql equivalent :

 
mysql> SHOW TABLE STATUS LIKE 'XXXX';
+--------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
| Name               | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time          | Collation         | Checksum | Create_options | Comment |
+--------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
| XXXX | MyISAM |       9 | Compressed |    0 |              0 |          60 |      4294967295 |         1024 |         0 |           NULL | 2010-01-01 23:50:01 | 2010-01-05 00:59:17 | 2010-01-05 00:59:17 | latin1_swedish_ci |        0 |                |         |
+--------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
1 row in set (0.00 sec)


In Mysql the Update_time field tells the most recent time at which the table XXXX was updated.

I need to figure out the way to check whether the table is active insertions/updates in last 15 mins?

Any way out??


Thanks and Regards,

Shabala Deshpande.