# Sorry, no examples found for this query in Example tab(postgres)

**URL:** <https://forums.percona.com/t/sorry-no-examples-found-for-this-query-in-example-tab-postgres/11183>\
**Category:** PMM unofficial Dashboards and Plugins\
**Tags:** pmm\
**Created:** [July 2, 2021, 6:18pm UTC](https://forums.percona.com/t/sorry-no-examples-found-for-this-query-in-example-tab-postgres/11183 "2021-07-02T18:18:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gajendra](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gajendra/32/44_2.png) [@Gajendra](https://forums.percona.com/u/Gajendra)\
**Post date:** [July 2, 2021, 6:18pm UTC](https://forums.percona.com/t/sorry-no-examples-found-for-this-query-in-example-tab-postgres/11183/1 "2021-07-02T18:18:11Z")

</div>

Hi Team,

i am monitoring postgresql database using pmm2.17.0  
Server 2.17.0  
client : 2.17.0  
postgresql version : 12

##Added below parameter in postgresql.conf

shared\_preload\_libraries = ‘pg\_stat\_statements’  
track\_activity\_query\_size = 2048  
pg\_stat\_statements.track = all

## Create extension

CREATE EXTENSION pg\_stat\_statements SCHEMA public;

ALTER SYSTEM SET track\_io\_timing=ON;

monitoring looks good but QAN having prob.

in example tab i am not getting table definition  
PFA

 ![postgres_pmm](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/6/63f80473a76c09abeb34b0baf263d78791d79121.png)

---

<div class="post-metadata">

**Author:** ![Robert\_Bernier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/robert_bernier/32/1367_2.png) [@Robert\_Bernier](https://forums.percona.com/u/Robert_Bernier)\
**Post date:** [July 2, 2021, 7:30pm UTC](https://forums.percona.com/t/sorry-no-examples-found-for-this-query-in-example-tab-postgres/11183/2 "2021-07-02T19:30:50Z")

</div>

Silly question perhaps, but did you restart the server?

---

<div class="post-metadata">

**Author:** ![steve.hoffman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/steve.hoffman/32/66_2.png) [@steve.hoffman](https://forums.percona.com/u/steve.hoffman)\
**Post date:** [July 2, 2021, 7:40pm UTC](https://forums.percona.com/t/sorry-no-examples-found-for-this-query-in-example-tab-postgres/11183/3 "2021-07-02T19:40:40Z")

</div>

Not silly at all Robert! I seemed to recall that for pg\_stat\_statement postgres (not the whole server) has to be restarted after being setup… Also have you looked at the official [docs here](https://www.percona.com/doc/percona-monitoring-and-management/2.x/setting-up/client/postgresql.html)? It’s been a while since I did it but I think one time I had enabled the extension as the ‘pmm’ user I created vs the postgres user and so examples was only populating for certain schemas or something…

---

<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:** [July 2, 2021, 7:52pm UTC](https://forums.percona.com/t/sorry-no-examples-found-for-this-query-in-example-tab-postgres/11183/4 "2021-07-02T19:52:10Z")

</div>

we need to add more to [PostgreSQL - Percona Monitoring and Management](https://www.percona.com/doc/percona-monitoring-and-management/2.x/setting-up/client/postgresql.html#choose-and-configure-an-extension)  
But the pg\_stat\_statements is not providing the Examples. This was one of the reasons for us to do pg\_stat\_monitor plugin

So, sorry @Gajendra this is expected behavior.  
I would encourage you to give a try to pg\_stat\_monitor but be aware it’s not fully GA’ed in PMM

---

<div class="post-metadata">

**Author:** ![Gajendra](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gajendra/32/44_2.png) [@Gajendra](https://forums.percona.com/u/Gajendra)\
**Post date:** [July 4, 2021, 11:32am UTC](https://forums.percona.com/t/sorry-no-examples-found-for-this-query-in-example-tab-postgres/11183/5 "2021-07-04T11:32:20Z")

</div>

> [@Roma\_Novikov](#):
>
> I would encourage you to give a try to pg\_stat\_monitor but be aware it’s not fully GA’ed in PMM

Thanks Roma

will enable pg\_stat\_monitor and check if it works .