News for hackers. Stuff that matters.

A comment on Ask HN: What are you working on? (April 2025). Parent comment

Re:Ask HN: What are you working on? (April 2025) by thebytefairy on Monday April 28, 2025 @09:07PM (#43827764)
Can you not use EXPLAIN ANALYZE to identify steps that had the highest compute time? I think most databases have some form of this.
[ Parent | on HN ]
Re:Ask HN: What are you working on? (April 2025) by noahbp on Monday April 28, 2025 @11:58PM (#43828572)
I've never heard of this, and I'm pretty sure my coworkers haven't either. Thanks for mentioning it!

https://chatgpt.com/share/68104c37-b578-8003-8c4e-b0a4688206...

[ Parent | on HN ]
Re:Ask HN: What are you working on? (April 2025) by xzel on Tuesday April 29, 2025 @05:32PM (#43838268)
This is a great command everyone should know. We once had a long running database query that was blocking a pipeline (code was written in a week and of course became integral to operations). Ran it, 15 minutes of thinking, added a new index on an now important column, and cut the run time down from almost 30 minutes to 5 seconds.
[ Parent | on HN ]