xactStartTimestamp=stmtStartTimestamp;

xactStopTimestamp=0;

pgstat_report_txn_timestamp(xactStartTimestamp);

pgstat_report_xact_timestamp(xactStartTimestamp);

AtEOXact_ComboCid();

AtEOXact_HashTables(true);

AtEOXact_PgStat(true);

pgstat_report_txn_timestamp(0);

pgstat_report_xact_timestamp(0);

CurrentResourceOwner=NULL;

ResourceOwnerDelete(TopTransactionResourceOwner);

AtEOXact_ComboCid();

AtEOXact_HashTables(false);

AtEOXact_PgStat(false);

pgstat_report_txn_timestamp(0);

pgstat_report_xact_timestamp(0);

U.rolnameAS usename,

pg_stat_get_backend_activity(S.backendid)AS current_query,

pg_stat_get_backend_waiting(S.backendid)AS waiting,

pg_stat_get_backend_txn_start(S.backendid)AStxn_start,

pg_stat_get_backend_xact_start(S.backendid)ASxact_start,

pg_stat_get_backend_activity_start(S.backendid)AS query_start,

pg_stat_get_backend_start(S.backendid)AS backend_start,

pg_stat_get_backend_client_addr(S.backendid)AS client_addr,

beentry->st_procpid=MyProcPid;

beentry->st_proc_start_timestamp=proc_start_timestamp;

beentry->st_activity_start_timestamp=0;

beentry->st_txn_start_timestamp=0;

beentry->st_xact_start_timestamp=0;

beentry->st_databaseid=MyDatabaseId;

beentry->st_userid=userid;

beentry->st_clientaddr=clientaddr;

}

pgstat_report_txn_timestamp(TimestampTztstamp)

pgstat_report_xact_timestamp(TimestampTztstamp)

{

volatilePgBackendStatus*beentry=MyBEEntry;

beentry->st_changecount++;

beentry->st_txn_start_timestamp=tstamp;

beentry->st_xact_start_timestamp=tstamp;

beentry->st_changecount++;

Assert((beentry->st_changecount&1)==0);

}

externDatumpg_stat_get_backend_activity(PG_FUNCTION_ARGS);

externDatumpg_stat_get_backend_waiting(PG_FUNCTION_ARGS);

externDatumpg_stat_get_backend_activity_start(PG_FUNCTION_ARGS);

externDatumpg_stat_get_backend_txn_start(PG_FUNCTION_ARGS);

externDatumpg_stat_get_backend_xact_start(PG_FUNCTION_ARGS);

externDatumpg_stat_get_backend_start(PG_FUNCTION_ARGS);

externDatumpg_stat_get_backend_client_addr(PG_FUNCTION_ARGS);

externDatumpg_stat_get_backend_client_port(PG_FUNCTION_ARGS);

pg_stat_get_backend_txn_start(PG_FUNCTION_ARGS)

pg_stat_get_backend_xact_start(PG_FUNCTION_ARGS)

{

int32beid=PG_GETARG_INT32(0);

TimestampTzresult;

if (!superuser()&&beentry->st_userid!=GetUserId())

PG_RETURN_NULL();

result=beentry->st_txn_start_timestamp;

result=beentry->st_xact_start_timestamp;

if (result==0)/* not in a transaction */

PG_RETURN_NULL();

DESCR("statistics: is backend currently waiting for a lock");

DATA(insertOID=2094 (pg_stat_get_backend_activity_startPGNSPPGUID1210fftfs11184"23"_null__null__null_pg_stat_get_backend_activity_start-_null__null_ ));

DESCR("statistics: start time for current query of backend");

DATA(insertOID=2857 (pg_stat_get_backend_txn_startPGNSPPGUID1210fftfs11184"23"_null__null__null_pg_stat_get_backend_txn_start-_null__null_ ));

DATA(insertOID=2857 (pg_stat_get_backend_xact_startPGNSPPGUID1210fftfs11184"23"_null__null__null_pg_stat_get_backend_xact_start-_null__null_ ));

DESCR("statistics: start time for backend's current transaction");

DATA(insertOID=1391 (pg_stat_get_backend_startPGNSPPGUID1210fftfs11184"23"_null__null__null_pg_stat_get_backend_start-_null__null_ ));

DESCR("statistics: start time for current backend session");

TimestampTzst_proc_start_timestamp;

TimestampTzst_txn_start_timestamp;

TimestampTzst_xact_start_timestamp;

TimestampTzst_activity_start_timestamp;

externvoidpgstat_bestart(void);

externvoidpgstat_report_activity(constchar*what);

externvoidpgstat_report_txn_timestamp(TimestampTztstamp);

externvoidpgstat_report_xact_timestamp(TimestampTztstamp);

externvoidpgstat_report_waiting(boolwaiting);

externvoidpgstat_initstats(Relationrel);

pg_rules | SELECT n.nspname AS schemaname, c.relname AS tablename, r.rulename, pg_get_ruledef(r.oid) AS definition FROM ((pg_rewrite r JOIN pg_class c ON ((c.oid = r.ev_class))) LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE (r.rulename <> '_RETURN'::name);

pg_settings | SELECT a.name, a.setting, a.unit, a.category, a.short_desc, a.extra_desc, a.context, a.vartype, a.source, a.min_val, a.max_val FROM pg_show_all_settings() a(name text, setting text, unit text, category text, short_desc text, extra_desc text, context text, vartype text, source text, min_val text, max_val text);

pg_shadow | SELECT pg_authid.rolname AS usename, pg_authid.oid AS usesysid, pg_authid.rolcreatedb AS usecreatedb, pg_authid.rolsuper AS usesuper, pg_authid.rolcatupdate AS usecatupd, pg_authid.rolpassword AS passwd, (pg_authid.rolvaliduntil)::abstime AS valuntil, pg_authid.rolconfig AS useconfig FROM pg_authid WHERE pg_authid.rolcanlogin;

pg_stat_activity | SELECT d.oid AS datid, d.datname, pg_stat_get_backend_pid(s.backendid) AS procpid, pg_stat_get_backend_userid(s.backendid) AS usesysid, u.rolname AS usename, pg_stat_get_backend_activity(s.backendid) AS current_query, pg_stat_get_backend_waiting(s.backendid) AS waiting,pg_stat_get_backend_txn_start(s.backendid) AStxn_start, pg_stat_get_backend_activity_start(s.backendid) AS query_start, pg_stat_get_backend_start(s.backendid) AS backend_start, pg_stat_get_backend_client_addr(s.backendid) AS client_addr, pg_stat_get_backend_client_port(s.backendid) AS client_port FROM pg_database d, (SELECT pg_stat_get_backend_idset() AS backendid) s, pg_authid u WHERE ((pg_stat_get_backend_dbid(s.backendid) = d.oid) AND (pg_stat_get_backend_userid(s.backendid) = u.oid));

pg_stat_activity | SELECT d.oid AS datid, d.datname, pg_stat_get_backend_pid(s.backendid) AS procpid, pg_stat_get_backend_userid(s.backendid) AS usesysid, u.rolname AS usename, pg_stat_get_backend_activity(s.backendid) AS current_query, pg_stat_get_backend_waiting(s.backendid) AS waiting,pg_stat_get_backend_xact_start(s.backendid) ASxact_start, pg_stat_get_backend_activity_start(s.backendid) AS query_start, pg_stat_get_backend_start(s.backendid) AS backend_start, pg_stat_get_backend_client_addr(s.backendid) AS client_addr, pg_stat_get_backend_client_port(s.backendid) AS client_port FROM pg_database d, (SELECT pg_stat_get_backend_idset() AS backendid) s, pg_authid u WHERE ((pg_stat_get_backend_dbid(s.backendid) = d.oid) AND (pg_stat_get_backend_userid(s.backendid) = u.oid));

pg_stat_all_indexes | SELECT c.oid AS relid, i.oid AS indexrelid, n.nspname AS schemaname, c.relname, i.relname AS indexrelname, pg_stat_get_numscans(i.oid) AS idx_scan, pg_stat_get_tuples_returned(i.oid) AS idx_tup_read, pg_stat_get_tuples_fetched(i.oid) AS idx_tup_fetch FROM (((pg_class c JOIN pg_index x ON ((c.oid = x.indrelid))) JOIN pg_class i ON ((i.oid = x.indexrelid))) LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE (c.relkind = ANY (ARRAY['r'::"char", 't'::"char"]));

pg_stat_all_tables | SELECT c.oid AS relid, n.nspname AS schemaname, c.relname, pg_stat_get_numscans(c.oid) AS seq_scan, pg_stat_get_tuples_returned(c.oid) AS seq_tup_read, (sum(pg_stat_get_numscans(i.indexrelid)))::bigint AS idx_scan, ((sum(pg_stat_get_tuples_fetched(i.indexrelid)))::bigint + pg_stat_get_tuples_fetched(c.oid)) AS idx_tup_fetch, pg_stat_get_tuples_inserted(c.oid) AS n_tup_ins, pg_stat_get_tuples_updated(c.oid) AS n_tup_upd, pg_stat_get_tuples_deleted(c.oid) AS n_tup_del, pg_stat_get_live_tuples(c.oid) AS n_live_tup, pg_stat_get_dead_tuples(c.oid) AS n_dead_tup, pg_stat_get_last_vacuum_time(c.oid) AS last_vacuum, pg_stat_get_last_autovacuum_time(c.oid) AS last_autovacuum, pg_stat_get_last_analyze_time(c.oid) AS last_analyze, pg_stat_get_last_autoanalyze_time(c.oid) AS last_autoanalyze FROM ((pg_class c LEFT JOIN pg_index i ON ((c.oid = i.indrelid))) LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE (c.relkind = ANY (ARRAY['r'::"char", 't'::"char"])) GROUP BY c.oid, n.nspname, c.relname;

pg_stat_bgwriter | SELECT pg_stat_get_bgwriter_timed_checkpoints() AS checkpoints_timed, pg_stat_get_bgwriter_requested_checkpoints() AS checkpoints_req, pg_stat_get_bgwriter_buf_written_checkpoints() AS buffers_checkpoint, pg_stat_get_bgwriter_buf_written_clean() AS buffers_clean, pg_stat_get_bgwriter_maxwritten_clean() AS maxwritten_clean;