Postgres Pro
Downloads
Home   >   mailing lists

pg_stat_statements query jumbling question - Mailing list pgsql-hackers

From Satoshi Nagayasu
Subject pg_stat_statements query jumbling question
Date
Msg-id 55E51C48.1060102@uptime.jp
Whole thread Raw
Responses Re: pg_stat_statements query jumbling question  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers
Tree view 
Hi,

I have a question on jumbling queries in pg_stat_statements.

I found that JumbleRangeTable() uses relation oid in
RangeTblEntry.

Obviously, this would result different queryid when the table
gets re-created (dropped and created).

Why don't we use relation name (with looking up the catalog)
on query jumbling? For performance reason?

Regards,
-- 
NAGAYASU Satoshi <snaga@uptime.jp>

pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Horizontal scalability/sharding
Next
From: Peter Geoghegan
Date:
Subject: Re: pg_stat_statements query jumbling question