sql 2022-02-11 | Slack Archive

Fork me on GitHub

pinkfrog13:02:57

How do you profile how much time a query takes ?

pinkfrog13:02:26

I can wrap jdbc/execute with a start and end time, and log it. But is there any battery included support?

You might want to look at what your database offers, eg in postgres you can enable a slow query log

pinkfrog15:02:34

Right.

pinkfrog15:02:41

Maybe I shall more focus on the db side.

✅ 1

seancorfield17:02:15

@UGC0NEP4Y next.jdbc has builtin support for logging like this.

Ben Sless19:02:17

You can also ask the database to explain it's query plan

seancorfield01:02:11

#Also sent to the channel

Just a follow-up, now I'm at a computer and can browse the docs properly: https://cljdoc.org/d/com.github.seancorfield/next.jdbc/1.2.772/doc/getting-started#naive-logging-with-timing

pinkfrog04:02:58

Yes,I saw that also after your comment.

seancorfield01:02:11

replied to a thread:I can wrap jdbc/execute with a start and end time, and log it. But is there any battery included support?

Just a follow-up, now I'm at a computer and can browse the docs properly: https://cljdoc.org/d/com.github.seancorfield/next.jdbc/1.2.772/doc/getting-started#naive-logging-with-timing