# Does pg\_stat\_statements extension view needs to be created on all databases

**URL:** <https://forums.percona.com/t/does-pg-stat-statements-extension-view-needs-to-be-created-on-all-databases/32260>\
**Category:** PMM 2.x\
**Tags:** new-release, pmm-doc, postgresql\
**Created:** [August 13, 2024, 7:59pm UTC](https://forums.percona.com/t/does-pg-stat-statements-extension-view-needs-to-be-created-on-all-databases/32260 "2024-08-13T19:59:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rups](https://avatars.discourse-cdn.com/v4/letter/r/5e9695/32.png) [@rups](https://forums.percona.com/u/rups)\
**Post date:** [August 13, 2024, 7:59pm UTC](https://forums.percona.com/t/does-pg-stat-statements-extension-view-needs-to-be-created-on-all-databases/32260/1 "2024-08-13T19:59:20Z")

</div>

Hello,

Does the extension needs to be created on each database separately for the QAN to capture the sqls ?

##Reference:

1. Install the extension.

```auto
psql postgres postgres -c "CREATE EXTENSION pg_stat_statements SCHEMA public"

```

This command creates the view where you can access the collected statistics.

**We recommend that you create the extension for the `postgres` database. In this case, you receive access to the statistics collected from every database.**

> **[Percona Monitoring and Management - PostgreSQL](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/postgresql.html#install)**
>
> How to set up PMM to monitor a PostgreSQL or Percona Distribution for PostgreSQL database instance.

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [August 13, 2024, 11:31pm UTC](https://forums.percona.com/t/does-pg-stat-statements-extension-view-needs-to-be-created-on-all-databases/32260/2 "2024-08-13T23:31:05Z")

</div>

Hello, no, only for `postgres` database.

---

<div class="post-metadata">

**Author:** ![rups](https://avatars.discourse-cdn.com/v4/letter/r/5e9695/32.png) [@rups](https://forums.percona.com/u/rups)\
**Post date:** [August 13, 2024, 11:44pm UTC](https://forums.percona.com/t/does-pg-stat-statements-extension-view-needs-to-be-created-on-all-databases/32260/3 "2024-08-13T23:44:05Z")

</div>

Thank you nurlan for responding.  
Just confirming , I am unable to query pg\_stat\_statements view from other dbs since i executed create extension only for postgres db, but as you said this should work fine.  
We dont need to run this individually on each database.

---

<div class="post-metadata">

**Author:** ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)\
**Post date:** [August 14, 2024, 9:55am UTC](https://forums.percona.com/t/does-pg-stat-statements-extension-view-needs-to-be-created-on-all-databases/32260/4 "2024-08-14T09:55:57Z")

</div>

@rups , also please consider using [pg\_stat\_monitor - pg\_stat\_monitor Documentation](https://docs.percona.com/pg-stat-monitor/) extension as it will provide much better data  
[PostgreSQL - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/postgresql.html#choose-and-configure-an-extension)

---

<div class="post-metadata">

**Author:** ![rups](https://avatars.discourse-cdn.com/v4/letter/r/5e9695/32.png) [@rups](https://forums.percona.com/u/rups)\
**Post date:** [August 14, 2024, 4:22pm UTC](https://forums.percona.com/t/does-pg-stat-statements-extension-view-needs-to-be-created-on-all-databases/32260/5 "2024-08-14T16:22:15Z")

</div>

Sure, pls suggest how to install pg\_stat\_monitor on freebsd. We have database cluster with rhel and freebsd.