Accessing query fingerprinting used by pg_stat_statements

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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 

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux