Accessing query fingerprinting used by pg_stat_statements

From: David Osborne <david(at)qcode(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: Accessing query fingerprinting used by pg_stat_statements
Date: 2015-10-15 11:25:59
Message-ID: CAKmpXCe3q5WNhdpgpBhwBbMMcgXSvieyi=2HKKPeJJzZf6NESw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Turnbull 2015-10-15 12:10:15 Create objects(table etc) to be stored in specific schema
Previous Message Rob Emery 2015-10-15 11:12:41 PGPool2 + RemoteHost IP