sessions vs vs_sessions

[nnani]

Hello All,

Came across this system table vs_sessions and was confused as to what does this table show.

The session tables show the sessions information, but it seems this table is different from sessions table.
This table does not belong to v_internal or v_monitor or v_catalog schema.

Thanks

[NorbertKrupa]

According to the table descriptions, sessions shouldn't contain internal sessions:

Code: Select all

dbadmin=> select * from vs_system_tables where table_name IN ('sessions', 'vs_sessions');
 table_schema | table_name  | table_id |                     table_description                      | is_view | is_dc
--------------+-------------+----------+------------------------------------------------------------+---------+-------
 v_internal   | vs_sessions |    22600 | Information on each Session (internal or external session) | f       | f
 v_monitor    | sessions    |    31000 | Information on each Session                                | f       | f
(2 rows)

[nnani]

Thanks norbert !!!!