root/trunk/contrib/control/README.control

Revision 137, 0.7 kB (checked in by robert, 8 years ago)

make this look like the other contrib modules

Line 
1
2 select * from controldata.pg_control;
3
4 # do something interesting
5 postgres=# select value as last_checkpoint, now(), checkpoint_timeout, now() - value as lag, now() - value > checkpoint_timeout as is_behind from (select  value::timestamptz, (select setting::interval from pg_settings where name = 'checkpoint_timeout') as checkpoint_timeout  from crontroldata.pg_control where name = 'checkPointCopy.time') x ;
6     last_checkpoint     |             now              | checkpoint_timeout |      lag       | is_behind
7 ------------------------+------------------------------+--------------------+----------------+-----------
8  2010-04-23 12:58:26-04 | 2010-04-23 12:59:37.38634-04 | 00:05:00           | 00:01:11.38634 | f
9
Note: See TracBrowser for help on using the browser.