# Percona 2.22 does not show example for postgres database

**URL:** <https://forums.percona.com/t/percona-2-22-does-not-show-example-for-postgres-database/12507>\
**Category:** PMM 2.x\
**Created:** [October 11, 2021, 6:27am UTC](https://forums.percona.com/t/percona-2-22-does-not-show-example-for-postgres-database/12507 "2021-10-11T06:27:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Angell](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@Angell](https://forums.percona.com/u/Angell)\
**Post date:** [October 11, 2021, 6:27am UTC](https://forums.percona.com/t/percona-2-22-does-not-show-example-for-postgres-database/12507/1 "2021-10-11T06:27:22Z")

</div>

Good morning I have a problem with percona. I am using percona 2.22 to monitor a postrges 11.10 database. I have a capture of the queries for the last few hours but while selecting the queries I can see the details and the table but I cannot see the example. I get:

> Sorry, no examples found for this query

This happens for the default database postgres and for the database I am interested.  
Any ideas why this might happen? Maybe I have done a mistake in my configuration?

Thank you,  
Angell

---

<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:** [October 11, 2021, 4:24pm UTC](https://forums.percona.com/t/percona-2-22-does-not-show-example-for-postgres-database/12507/2 "2021-10-11T16:24:17Z")

</div>

I assume you’re using the built-in pg\_stat\_statements method of capturing query data which doesn’t actually capture the raw query to give examples…it strips it down to a more generic query gives it a fingerprint and then starts aggregating stats by fingerprint.

There is an extension in tech preview from Percona called [pg\_stat\_monitor](https://www.percona.com/doc/percona-monitoring-and-management/2.x/setting-up/client/postgresql.html) that will actually capture query examples so you can not only see the generic query but examples with the full where clauses. Just know that this will show the _exact_ query posed to the DB so take good care not to inadvertently expose sensitive data to people who might not otherwise be allowed to view it.

---

<div class="post-metadata">

**Author:** ![Angell](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@Angell](https://forums.percona.com/u/Angell)\
**Post date:** [October 11, 2021, 8:01pm UTC](https://forums.percona.com/t/percona-2-22-does-not-show-example-for-postgres-database/12507/3 "2021-10-11T20:01:45Z")

</div>

Good evening Steve,

Thank you for your reply.  
Yes you are right I am using the classic approach with pg\_stat\_statements. How accurate are the execution timings for the provided queries?

With pg\_stat\_monitor I will have the ability to see also explain plans? Queries with bind variables have full example provided or they remain bind variables?

I am trying to understand what this exact query means.

---

<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:** [October 11, 2021, 8:36pm UTC](https://forums.percona.com/t/percona-2-22-does-not-show-example-for-postgres-database/12507/4 "2021-10-11T20:36:24Z")

</div>

This [blog article](https://www.percona.com/blog/2020/10/14/announcing-pg_stat_monitor-tech-preview-get-better-insights-into-query-performance-in-postgresql/) will help with all the goodness of pg\_stat\_monitor. Because we’ll have the full query we can actually run an explain against it to help understand the query execution better.

Here’s a blog on how to install [pg\_stat\_monitor](https://www.percona.com/blog/2021/01/19/pg_stat_monitor-a-new-way-of-looking-at-postgresql-metrics/) and the link I sent above shows how to have PMM use pg\_stat\_monitor provide stats (I wouldn’t recommend using both although it is possible…just double load on your system).

---

<div class="post-metadata">

**Author:** ![Angell](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@Angell](https://forums.percona.com/u/Angell)\
**Post date:** [October 14, 2021, 5:29am UTC](https://forums.percona.com/t/percona-2-22-does-not-show-example-for-postgres-database/12507/5 "2021-10-14T05:29:55Z")

</div>

Thank you very much Steve for your explanations.  
One more question: There are some queries where I do not get even the table information.

```auto
No table info from example nor explain

```

Do you might know why this is happening?