Talk Python To Me cover image

#366: Optimizing PostgreSQL DB Queries with pgMustard

Talk Python To Me

00:00

Why Is It Slow?

Some of the o r m have features that you can make it spit out the queries like a super verbos mode. You just append that to the beginning of your query, run it as normal, and then it gives you the query plan. But if you want to get the performance information and get start to diginto exactly why it's slow, you need to run something called explain analyze which will also run the query. So be careful around that. If you're running kind of big delet or something, and probably not run it on production. We'll run the querry by hunsings by. Instead of getting the date, or instead of lets o get in the data back,

Transcript
Play full episode

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app