gp_toolkit.gp_log_master_concise

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=#