Show
Ignore:
Timestamp:
04/23/10 17:01:37 (4 years ago)
Author:
robert
Message:

fix typo, add example

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/contrib/control/README.control

    r134 r136  
    11 
    2 select * from pgreats_control.pg_control; 
     2select * from pgtreats_control.pg_control; 
     3 
     4# do something interesting 
     5postgres=# 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 pgtreats_control.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