Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
CASE PORTAL: Inability to view all organizations' cases. We are investigating. Thank you for being so patient.

Excess space consumption by Repository folder of Qlik

cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Excess space consumption by Repository folder of Qlik

If you suspect that a Qlik Sense database is growing too large, this article can help you confirm which database needs to be further investigated. 

Environment:

 

Resolution:

 

PostgreSQL Monitoring.qvf

Attached is an App named PostgreSQL Monitoring.qvf. Import the App from the Qlik Sense Management Console and publish it to an available stream. View the app from the hub to display from top to bottom what database is consuming most disk space. 

! This app is a tool that is not supported nor maintained by Qlik Support (it is not a deliverable product)
 

Database Queries

  1. Use PGAdmin to connect to to PostGres, by following Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinti....
  2. Run the following query in the Query tool:
    SELECT pg_database.datname, pg_size_pretty(pg_database_size(pg_database.datname)) AS size FROM pg_database;​
  3. The result should look like this:
    datname     size
    postgres	7055kb
    QSR         70 MB​
  4. To verify which Table is the biggest, run the below query. Change the Limit line if you want to see more than 10 tables.
    SELECT
        relname AS "relation",
        pg_size_pretty (
            pg_total_relation_size (C .oid)
        ) AS "total_size"
    FROM
        pg_class C
    LEFT JOIN pg_namespace N ON (N.oid = C .relnamespace)
    WHERE
        nspname NOT IN (
            'pg_catalog',
            'information_schema'
        )
    AND C .relkind <> 'i'
    AND nspname !~ '^pg_toast'
    ORDER BY
        pg_total_relation_size (C .oid) DESC
    Limit 10;​
  5. The result should look like this:
    relation	         total size
    _deletedentitylog	 200 MB
    __MigrationHistory   100MB​

 

Manual verification using pgAdmin

Use PGAdmin to connect to to PostGres, by following Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinti....

  1. For each database instance, select the Properties tab. 
  2. The OID field will state which folder contains that specific database.

    For instance, in this example, the data for QLogs is contained in the 16433 subfolder.

    pgAdmin Properties QSR.png

  3. Find the corresponding folder on disk to manually review file size. 
  4. In a default installation of Qlik Sense Enterprise for Windows, the databases are located in C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6\base

    Folder.png
 

 

How to address excessive disk space

Common Articles associated with disk space:
_deletedentitylogs wasting C:\ space
Qlik Sense: Steps to reduce Excessive HDD space occupied by PostgreSQL.

 

Labels (2)
Attachments
Version history
Last update:
‎2021-05-25 06:24 AM
Updated by:
Contributors