HOW TO: Extract Repository usage statistics

Environment: 
Note: Qlik does not support interacting directly with the Repository function of our product, unless specifically indicated as part of a Support case. Please note that the information collected by this guide does not have any value to system administrators and is only useful in specific scenarios.

In certain performance and stability-related cases, it may be necessary to consult the Repository usage statistics to determine if a clean-up is needed. Below you can find instructions on how to collect these usage statistics for Support.

In certain performance and stability-related cases, it may be necessary to consult the Repository usage statistics to determine if a clean-up is needed. Below you can find instructions on how to collect these usage statistics for Support.

 

How to collect NPrinting Server Repository usage statistics:

• Open a Command Prompt as Administrator
• Navigate to your NPrinting Server installation path and find the PostgreSQL binary folder, for example:

C:\>cd C:\Program Files\NPrintingServer\pgsql\bin

•  Run the following command to produce the statistics results in a CSV file:

psql -d nprinting -U postgres -h localhost -p 4992 -A -F"," -c "select relname, n_live_tup, n_tup_del, n_dead_tup from pg_stat_user_tables" > C:\table-stats.csv

• The command will prompt you for your Repository superuser password
• Browse to "C:\" drive and upload "table-stats.csv" to your Support case for review.

How to collect Qlik Sense Enterprise Repository Database usage statistics:

• Open a Command Prompt as Administrator
• Navigate to your Qlik Sense Enterprise installation path and find the PostgreSQL binary folder, for example:

C:\>cd C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin

• Run the following command to produce the statistics results in a CSV file:

​psql -d QSR -U postgres -h localhost -p 4432 -A -F"," -c "select relname, n_live_tup, n_tup_del, n_dead_tup from pg_stat_user_tables" > C:\table-stats.csv

• The command will prompt you for your Repository superuser password
• Browse to "C:\" drive and upload "table-stats.csv" to your Support case for review.