When monitoring PostgreSQL database, Database Security sensor requires the PostgreSQL audit plug-in to be installed in addition to the sensor. The PostgreSQL audit plug-in is a separately maintained, open-source project.
To download and install the PostgreSQL audit plug-in, follow the instructions at PostgreSQL audit wiki page.