Bug#969311: UDD: please install pg_stat_statements extension

[Michael Banck <mbanck@gmail.com>]

Package: qa.debian.org
Severity: wishlist
User: qa.debian.org@packages.debian.org
Usertags: udd

Dear Maintainer,

it seems some parts of the UDD schema are sub-optimal, e.g. some
non-trivial tables are missing primary keys or indexes alltogether,
resulting in many full table scans.

In order to best assess where and how to improve the situation, please
install the pg_stat_statements extension in the udd database, like

CREATE EXTENSION pg_stat_statements;

Also it would be beneficial if the 'track_io_timings' parameter in
postgresql.conf could be set to 'on' followed by a reload (a restart is
not necessary).

After a few days or weeks running with pg_stat_statements, I'd like to
take a look at the most problematic queries and how to possibly improve
them.


Thanks,

Michael

-- System Information:
Debian Release: 10.5
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.19.0-6-amd64 (SMP w/2 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled