src/pgperf/t/105_create_snapshot_pg_stat_activity/expected/test91.out

SELECT pgperf.create_snapshot_pg_stat_activity(0);
 create_snapshot_pg_stat_activity 
----------------------------------
 t
(1 row)

SELECT count(*) FROM pgperf.snapshot_pg_stat_activity;
 count 
-------
     1
(1 row)

SELECT count(*) = 1
  FROM pgperf.snapshot_pg_stat_activity
 WHERE sid = 0
   AND datid IS NOT NULL
   AND datname = 'testdb'
   AND procpid IS NOT NULL
   AND usesysid IS NOT NULL
   AND usename IS NOT NULL
   AND application_name = 'psql'
   AND client_port IS NOT NULL
   AND backend_start < now()
   AND xact_start < now()
   AND query_start < now()
   AND waiting = false
   AND current_query = 'SELECT pgperf.create_snapshot_pg_stat_activity(0);';
 ?column? 
----------
 t
(1 row)

SELECT pgperf.create_snapshot_pg_stat_activity(1);
 create_snapshot_pg_stat_activity 
----------------------------------
 t
(1 row)

SELECT count(*) FROM pgperf.snapshot_pg_stat_activity;
 count 
-------
     2
(1 row)

SELECT b.sid - a.sid = 1,
       b.datid = a.datid,
       b.datname = a.datname,
       b.procpid = a.procpid,
       b.usesysid = a.usesysid,
       b.usename = a.usename,
       b.application_name = a.application_name,
       b.client_port = a.client_port,
       (b.backend_start - a.backend_start) = '0'::interval,
       (b.xact_start - a.xact_start) > '0'::interval,
       (b.query_start - a.query_start) > '0'::interval,
       b.waiting = a.waiting,
       b.current_query = 'SELECT pgperf.create_snapshot_pg_stat_activity(1);'
  FROM ( SELECT * FROM pgperf.snapshot_pg_stat_activity WHERE sid = 0 ) AS a,
       ( SELECT * FROM pgperf.snapshot_pg_stat_activity WHERE sid = 1 ) AS b
;
 ?column? | ?column? | ?column? | ?column? | ?column? | ?column? | ?column? | ?column? | ?column? | ?column? | ?column? | ?column? | ?column? 
----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------
 t        | t        | t        | t        | t        | t        | t        | t        | t        | t        | t        | t        | t
(1 row)

SELECT pgperf.create_snapshot_pg_stat_activity(2);
 create_snapshot_pg_stat_activity 
----------------------------------
 t
(1 row)

SELECT count(*) = 3 FROM pgperf.snapshot_pg_stat_activity;
 ?column? 
----------
 t
(1 row)

SELECT pgperf.delete_snapshot_pg_stat_activity(1);
 delete_snapshot_pg_stat_activity 
----------------------------------
 t
(1 row)

SELECT count(*) = 0 FROM pgperf.snapshot_pg_stat_activity WHERE sid = 1;
 ?column? 
----------
 t
(1 row)

SELECT count(*) = 2 FROM pgperf.snapshot_pg_stat_activity;
 ?column? 
----------
 t
(1 row)