Fork me on GitHub
#sql
<
2017-10-11
>
bja03:10:20

switched off that for hikari awhile back

jeaye16:10:21

heroku pg:outliers is showing this at the top of the pack for me: https://gist.github.com/jeaye/65b9d35839d5152118fde4fbe78e6c19

jeaye16:10:06

After collecting all of my queries, I'm not issuing that anywhere. However, I also don't see it in clojure.java.jdbc.

jeaye16:10:27

So nearly 50% of my db time is spent looking up types from an unknown source.

seancorfield16:10:15

@jeaye No idea what that is. As you suspect, it's not coming from java.jdbc directly (it looks like a very PostgreSQL-specific query?) but that doesn't mean it's not being triggered by the PostgreSQL driver in response to something java.jdbc is asking it to do... Never heard of it being reported before tho'...

jeaye17:10:45

Doesn't seem like much of a cache though, hitting that query so many times!

seancorfield18:10:03

Interesting. Looks like it only calls that for user-defined types tho'?

jeaye21:10:13

Could be. Maybe we should use more strings. 😛