Accessing query fingerprinting used by pg_stat_statements - Mailing list pgsql-admin

From David Osborne
Subject Accessing query fingerprinting used by pg_stat_statements
Date
Msg-id CAKmpXCe3q5WNhdpgpBhwBbMMcgXSvieyi=2HKKPeJJzZf6NESw@mail.gmail.com
Whole thread Raw
List pgsql-admin

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 

pgsql-admin by date:

Previous
From: Rob Emery
Date:
Subject: PGPool2 + RemoteHost IP
Next
From: Sam Turnbull
Date:
Subject: Create objects(table etc) to be stored in specific schema