# ★は参照しているDCテーブル
dbadmin=> \x
Expanded display is on.
dbadmin=> select * from vs_system_views where view_name = 'user_sessions' ;
-[ RECORD 1 ]----+-------------------------------------------------------------------------------------------------
view_schema      | v_monitor
view_name        | user_sessions
view_description | User session history
query_string     | create view "v_monitor"."user_sessions" as select ss.node_name, ss.user_name, ss.session_id,
           vs.transaction_id,
           vs.statement_id,
       case when drpc.current_runtime_priority = '' then null
           else drpc.current_runtime_priority
       end as "runtime_priority",
       ss.time as session_start_timestamp, se.time as session_end_timestamp,
       (se.time IS NULL) as is_active,
       ss.client_hostname,
           ss.client_pid,
           ss.client_label,
       ss.ssl_state,
           ss.authentication_method,
           ss.client_type,
           ss.client_version,
           ss.client_os,
           ss.client_os_user_name,
           ss.requested_protocol,
           ss.effective_protocol
from v_internal.dc_session_starts★ ss
         LEFT JOIN v_internal.dc_session_ends★ se USING (node_name, session_id)
     LEFT JOIN v_internal.vs_sessions     vs USING (node_name, session_id)
     left join (
     select node_name,session_id,current_runtime_priority,transaction_id from
         (
         select node_name, session_id, current_runtime_priority, transaction_id, row_number() over (partition by node_name, session_id order by time desc) as rn
         from v_internal.dc_runtime_priority_changes★
         ) as sq0
     where rn = 1
     ) as drpc
        on (ss.node_name      = drpc.node_name and
            ss.session_id     = drpc.session_id and
            vs.transaction_id = drpc.transaction_id)
 where not ss.is_internal
;

# ★は参照しているDCテーブル
dbadmin=> select * from vs_system_views where view_name = 'query_requests' ;
-[ RECORD 1 ]----+-------------------------------------------------------------------------------------------------
view_schema      | v_monitor
view_name        | query_requests
view_description | User-issued query requests
query_string     | create view "v_monitor"."query_requests" as select ri.node_name,
       ri.user_name,
       ri.session_id,
       ri.request_id,
       ri.transaction_id,
       ri.statement_id,
       ri.request_type,
       replace(replace(ri.request, E'\n', ' '), E'\t', ' ') as request,
       ri.label as request_label,
       ri.search_path,
       round(ra.memory_mb, 2) as memory_acquired_mb,
       rc.success,
       de.error_count,
       ri.time                                   as start_timestamp,
       rc.time                                   as end_timestamp,
       rc.time - ri.time                         as request_duration,
       datediff('millisecond', ri.time, rc.time) as request_duration_ms,
       rs.is_running IS NOT NULL AND rc.time IS NULL as is_executing
from
     v_internal.dc_requests_issued★ ri
     LEFT OUTER JOIN (select node_name, session_id, request_id,
                             reserved_extra_memory, time,
                             processed_row_count, schema_name,
                             table_name, command_tag, completion_tag,
                             success
                             FROM v_internal.dc_requests_completed★) rc
                USING (node_name, session_id, request_id)
     LEFT OUTER JOIN (select node_name,
                       session_id,
                       request_id,
                       count(*) as error_count
                from v_internal.dc_errors★
                where error_level >= 20
                group by 1,2,3) de USING (node_name, session_id, request_id)
     LEFT OUTER JOIN (select node_name,
                       transaction_id,
                       statement_id,
                       max(memory_kb)/1024::float as memory_mb
                from v_internal.dc_resource_acquisitions★
                where result = 'Granted'
                group by 1,2,3) ra
                USING (node_name, transaction_id, statement_id)
     LEFT OUTER JOIN (select node_name,
                       user_name,
                       session_id,
                       statement_id,
                       true as is_running -- Is session still running? Always true if it's in vs_sessions
                from v_internal.vs_sessions
                group by 1,2,3,4) rs
                USING (node_name, user_name, session_id, statement_id);

dbadmin=> select node_name,component,table_name,memory_buffer_size_kb,disk_size_kb,interval_set,interval_time from data_collector where table_name in ('dc_session_starts','dc_session_ends','dc_runtime_priority_changes') ;
     node_name     |       component        |         table_name          | memory_buffer_size_kb | disk_size_kb | interval_set | interval_time
-------------------+------------------------+-----------------------------+-----------------------+--------------+--------------+---------------
 v_testdb_node0001 | RuntimePriorityChanges | dc_runtime_priority_changes |                  1000 |        10000 | f            | 0
 v_testdb_node0001 | SessionEnds            | dc_session_ends             |                   100 |         5000 | f            | 0
 v_testdb_node0001 | SessionStarts          | dc_session_starts           |                   200 |         5000 | f            | 0
(3 rows)

dbadmin=> select node_name,component,table_name,memory_buffer_size_kb,disk_size_kb,interval_set,interval_time from data_collector where table_name in ('dc_requests_issued','dc_requests_completed','dc_errors','dc_resource_acquisitions') ;
     node_name     |      component       |        table_name        | memory_buffer_size_kb | disk_size_kb | interval_set | interval_time
-------------------+----------------------+--------------------------+-----------------------+--------------+--------------+---------------
 v_testdb_node0001 | Errors               | dc_errors                |                  1000 |        10000 | f            | 0
 v_testdb_node0001 | RequestsCompleted    | dc_requests_completed    |                  2000 |        50000 | f            | 0
 v_testdb_node0001 | RequestsIssued       | dc_requests_issued       |                  2000 |        50000 | f            | 0
 v_testdb_node0001 | ResourceAcquisitions | dc_resource_acquisitions |                  1000 |        10000 | f            | 0
(4 rows)

dbadmin=> select node_name,component,table_name,memory_buffer_size_kb,disk_size_kb,interval_set,interval_time from data_collector where table_name in ('dc_session_starts','dc_session_ends','dc_runtime_priority_changes') ;
     node_name     |       component        |         table_name          | memory_buffer_size_kb | disk_size_kb | interval_set | interval_time
-------------------+------------------------+-----------------------------+-----------------------+--------------+--------------+---------------
 v_testdb_node0001 | RuntimePriorityChanges | dc_runtime_priority_changes |                  1000 |        10000 | f            | 0
 v_testdb_node0001 | SessionEnds            | dc_session_ends             |                   100 |         5000 | f            | 0
 v_testdb_node0001 | SessionStarts          | dc_session_starts           |                   200 |         5000 | f            | 0
(3 rows)

dbadmin=> SELECT get_data_collector_policy('RuntimePriorityChanges');
                          get_data_collector_policy
-----------------------------------------------------------------------------
 1000KB kept in memory, 10000KB kept on disk. Time based retention disabled.
(1 row)

dbadmin=> SELECT get_data_collector_policy('SessionEnds');
                         get_data_collector_policy
---------------------------------------------------------------------------
 100KB kept in memory, 5000KB kept on disk. Time based retention disabled.
(1 row)

dbadmin=> SELECT get_data_collector_policy('SessionStarts');
                         get_data_collector_policy
---------------------------------------------------------------------------
 200KB kept in memory, 5000KB kept on disk. Time based retention disabled.
(1 row)

dbadmin=> select node_name,component,table_name,memory_buffer_size_kb,disk_size_kb,interval_set,interval_time from data_collector where table_name in ('dc_requests_issued','dc_requests_completed','dc_errors','dc_resource_acquisitions') ;
     node_name     |      component       |        table_name        | memory_buffer_size_kb | disk_size_kb | interval_set | interval_time
-------------------+----------------------+--------------------------+-----------------------+--------------+--------------+---------------
 v_testdb_node0001 | Errors               | dc_errors                |                  1000 |        10000 | f            | 0
 v_testdb_node0001 | RequestsCompleted    | dc_requests_completed    |                  2000 |        50000 | f            | 0
 v_testdb_node0001 | RequestsIssued       | dc_requests_issued       |                  2000 |        50000 | f            | 0
 v_testdb_node0001 | ResourceAcquisitions | dc_resource_acquisitions |                  1000 |        10000 | f            | 0
(4 rows)

dbadmin=> SELECT get_data_collector_policy('Errors');
                          get_data_collector_policy
-----------------------------------------------------------------------------
 1000KB kept in memory, 10000KB kept on disk. Time based retention disabled.
(1 row)

dbadmin=> SELECT get_data_collector_policy('RequestsCompleted');
                          get_data_collector_policy
-----------------------------------------------------------------------------
 2000KB kept in memory, 50000KB kept on disk. Time based retention disabled.
(1 row)

dbadmin=> SELECT get_data_collector_policy('RequestsIssued');
                          get_data_collector_policy
-----------------------------------------------------------------------------
 2000KB kept in memory, 50000KB kept on disk. Time based retention disabled.
(1 row)

dbadmin=> SELECT get_data_collector_policy('ResourceAcquisitions');
                          get_data_collector_policy
-----------------------------------------------------------------------------
 1000KB kept in memory, 10000KB kept on disk. Time based retention disabled.
(1 row)

dbadmin=> SELECT set_data_collector_policy('RuntimePriorityChanges','1000','1048576','7');
 set_data_collector_policy
---------------------------
 SET
(1 row)

dbadmin=> SELECT set_data_collector_policy('SessionEnds','100','1048576','7');
 set_data_collector_policy
---------------------------
 SET
(1 row)

dbadmin=> SELECT set_data_collector_policy('SessionStarts','200','1048576','7');
 set_data_collector_policy
---------------------------
 SET
(1 row)

dbadmin=> SELECT set_data_collector_policy('Errors','1000','1048576','7');
 set_data_collector_policy
---------------------------
 SET
(1 row)

dbadmin=> SELECT set_data_collector_policy('RequestsCompleted','2000','1048576','7');
 set_data_collector_policy
---------------------------
 SET
(1 row)

dbadmin=> SELECT set_data_collector_policy('RequestsIssued','2000','1048576','7');
 set_data_collector_policy
---------------------------
 SET
(1 row)

dbadmin=> SELECT set_data_collector_policy('ResourceAcquisitions','1000','1048576','7');
 set_data_collector_policy
---------------------------
 SET
(1 row)

dbadmin=> select node_name,component,table_name,memory_buffer_size_kb,disk_size_kb,interval_set,interval_time from data_collector where table_name in ('dc_session_starts','dc_session_ends','dc_runtime_priority_changes') ;
     node_name     |       component        |         table_name          | memory_buffer_size_kb | disk_size_kb | interval_set | interval_time
-------------------+------------------------+-----------------------------+-----------------------+--------------+--------------+---------------
 v_testdb_node0001 | RuntimePriorityChanges | dc_runtime_priority_changes |                  1000 |      1048576 | t            | 7
 v_testdb_node0001 | SessionEnds            | dc_session_ends             |                   100 |      1048576 | t            | 7
 v_testdb_node0001 | SessionStarts          | dc_session_starts           |                   200 |      1048576 | t            | 7
(3 rows)

dbadmin=> select node_name,component,table_name,memory_buffer_size_kb,disk_size_kb,interval_set,interval_time from data_collector where table_name in ('dc_requests_issued','dc_requests_completed','dc_errors','dc_resource_acquisitions') ;
     node_name     |      component       |        table_name        | memory_buffer_size_kb | disk_size_kb | interval_set | interval_time
-------------------+----------------------+--------------------------+-----------------------+--------------+--------------+---------------
 v_testdb_node0001 | Errors               | dc_errors                |                  1000 |      1048576 | t            | 7
 v_testdb_node0001 | RequestsCompleted    | dc_requests_completed    |                  2000 |      1048576 | t            | 7
 v_testdb_node0001 | RequestsIssued       | dc_requests_issued       |                  2000 |      1048576 | t            | 7
 v_testdb_node0001 | ResourceAcquisitions | dc_resource_acquisitions |                  1000 |      1048576 | t            | 7
(4 rows)