Skip to main content

Large size of the nVision database

Marcin Matuszewski
  • Updated

You can find information about the size of tables in the nVision database on the server, in the logs folder, in the file "nv_atlas-pg_catalog-!pg_DiskUsage.csv".

Example:

C:\Program Files (x86)\Axence\nVision\Logs\PG\pg_catalog_simple\nv_atlas-pg_catalog-!pg_DiskUsage.csv

 

You can open the file using any tool that supports editing .CSV files, such as MS Excel.:

 

The table size is provided in the total column. The file is sorted by the values in this column. Check the table name to see which nVision functional area the data comes from. The name appears in the table_name column.

The following components have the greatest impact on the database size:

  • collected screenshots (screenshots table),

  • entries from the Windows System Logs section in Event Viewer (NtEventLogData table

  • Syslog entries (syslog table).

Expired data is automatically removed from the database to the schedule. This schedule is configured in the nVision options. However, daily cleanup does not shrink the physical size of the database. This is because PostgreSQL manages the table size internally.
 

 

Warning!

  • Never modify or delete files manually in the folder:

    C:\Program Files (x86)\Axence\nVision\Database\AtlasPG

    - you will corrupt the database!

  • Manual database cleanup can be time‑consuming, and nVision will be unavailable while it runs. Plan accordingly and start the procedure near the end of the workday to minimize disruption.

To manually clean the database:

  1. Check the automatic database cleanup settings.

    This will let you determine how often the database is cleaned automatically and how much data you can expect. The more data, the longer the cleanup will take.

  2. Create a database backup.

    Make a backup (e.g., to an attached external drive) by running the shortcut from the command prompt

    or by double‑clicking the shortcut icon.

  3. Download the archive https://cdn.axence.net/Support/DBCorrectPG.zip, save it on the server, and extract.

  4. Copy the DBCorrectPG.exe file into the nVision installation folder next to nVision.exe.
    Example:

    C:\Program Files (x86)\Axence\nVision\DBCorrectPG.exe

  5. Run DBCorrectPG.exe.

    In the Task name field, enter one of the following:

    DBVacuumFull

    frees disk space after data deletion; requires as much free disk space as the size of the “...\nVision\Database” folder

    Truncate_SysLog

    deletes all Syslog entries

    Truncate_NtEventLogData

    deletes all Windows event log entries

  6. Click Run task.

  7. The task should finish with the following entries:
     

    [Truncate_SysLog - END] 
[ END ]

Related articles