Обсуждение: Accessing query fingerprinting used by pg_stat_statements

Поиск
Список
Период
Сортировка

Accessing query fingerprinting used by pg_stat_statements

От
David Osborne
Дата:

Hi,

Is there a way we can access the query fingerprinting as used by pg_stat_statments extension?

Trivial example:

So given a query "select email from customers where id=1234;"

We would like to know if that query is already in the pg_stat_statements view:

select query from pg_stat_statements where query=pg_fingerprint('select email from customers where id=1234');

                                query                                
---------------------------------------------------------------------
select email from customers where id=?;
(1 row)

Regards,
--
David