We have migrated to new Google sites!
Post date: Jan 20, 2014 9:54:36 PM
gpadmin=# \d gp_toolkit.gp_log_master_concise
View "gp_toolkit.gp_log_master_concise"
Column | Type | Modifiers
-------------+--------------------------+-----------
logtime | timestamp with time zone |
logdatabase | text |
logsession | text |
logcmdcount | text |
logseverity | text |
logmessage | text |
View definition:
SELECT __gp_log_master_ext.logtime, __gp_log_master_ext.logdatabase, __gp_log_master_ext.logsession, __gp_log_master_ext.logcmdcount, __gp_log_master_ext.logseverity, __gp_log_master_ext.logmessage
FROM ONLY gp_toolkit.__gp_log_master_ext;
logtime=>The timestamp of the log message.
logdatabase=>The name of the database.
logsession=>The session identifier (prefixed with "con").
logcmdcount=>The command number within a session (prefixed with "cmd").
logmessage=>Log or error message text.
This view uses an external table to read a subset of the log fields from the master log file. The use of this view requires superuser permissions.
gpadmin=# select * from gp_toolkit.gp_log_master_concise limit 10;
logtime | logdatabase | logsession | logcmdcount | logseverity |
logmessage
-------------------------------+-------------+------------+-------------+-------------+----------------------------------------------------------------------
--------------------------------------------------------------------------------------------------
2013-11-27 12:51:33.08036-05 | | | | LOG | database system was shut down at 2013-11-27 12:51:32 EST
2013-11-27 12:51:33.080475-05 | | | | LOG | checkpoint record is at 0/8ABA78
2013-11-27 12:51:33.080507-05 | | | | LOG | redo record is at 0/8ABA78; undo record is at 0/0; shutdown TRUE
2013-11-27 12:51:33.08053-05 | | | | LOG | next transaction ID: 0/902; next OID: 10901
2013-11-27 12:51:33.080551-05 | | | | LOG | next MultiXactId: 1; next MultiXactOffset: 0
2013-11-27 12:51:33.08059-05 | | | | LOG | end of transaction log location is 0/8ABAF0
2013-11-27 12:51:33.081056-05 | | | | LOG | Oldest active transaction from prepared transactions 902
2013-11-27 12:51:33.346109-05 | | | | LOG | database system is ready
2013-11-27 12:51:33.346179-05 | | | | LOG | PostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1 Community Editi
on) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 17 2012 11:48:43
2013-11-27 12:51:33.432896-05 | | | | LOG | Finished normal startup for clean shutdown case
(10 rows)
gpadmin=#