How Can I Tell How Many Users Are Using PSQL?
Release Date: 02/08/2024
Versions: PSQL 13 and Up
If you suspect you are running out of PSQL licenses or just want to know how many users are using PSQL, Actian has a utility that provides that information: Monitor. PSQL Monitor utility provides open files, sessions, and resource usage information. It is useful if you need to know more of the internal operations of the PSQL database.
Log into the server where PSQL is installed. There are two ways you can launch PSQL Monitor:
- In the Windows programs you will find an Actian PSQL group and under that will be PSQL Monitor. The utility will prompt for a server to monitor.
- If you have a shortcut to bring up the PSQL Control Center, you can choose Tools from the menu along the top and then Monitor.
The selection defaults to the server you are on, but you may have to select a different server. If so, you may need the administrator password to monitor the server. Another window will appear and you will click the Resource Usage tab.
Here you can see the current number of users, the peak that has been reached since the server has been up, and the maximum number of users allowed according to your license. You can see who the users are by clicking on the MicroKernel Sessions tab.
The first column contains the user ID that is using PSQL. Some of these may be "SRDE:<anonymous>" or "SRDE:Master." These sessions are accessing the data through ODBC or directly through the PSQL Control Center. Since you may access the data through ODBC with Excel, Crystal, or shipping software, you should take these into account when you are calculating the number of PSQL licenses needed.
See also related KB articles:
MAD