sql: investigate composite type introspection slowness #121225
Labels
A-sql-pgcatalog
C-performance
Perf of queries or internals. Solution not expected to change functional behavior.
T-sql-foundations
SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
Repro:
Observe the
15.917s total
latency on the introspection queryHowever, if we lookup
t
's oid via thepg_type
table (cast toregtype
instead ofregclass
), we get what we expect:So it looks like
pg_type
is good - something inpg_class
is likely the problem.While we are here, we can see/keep track of how many round trips the query does by adding this to
rttanalysis
tests.Jira issue: CRDB-37145
The text was updated successfully, but these errors were encountered: