Ever Run Into A PostgreSQL Query That You Can Figure Out What It Does??
Ever have a query 'tossed over the fence' that you find incomprehensible but still have to support it? A few years ago, you would have needed to triage the query. Obfuscated queries can be tough to decipher. Sometimes, the query is due to someone or an ORM being clever. Many times the query is touch to read because the DBeaver recently added its AI Chat to the free, open-source DBeaver Community Edition. And you will find it very at determining what a query does. Let's start with a simple query. Open AI Assistant Where to find the AI Assistant DBeaver 26.1.2's AI Assistant can be found on the main menu under 'AI'. Input Prompt Once you have the AI Assistant open, ask 'what does this do'? Prompt with a query Explanation The AI will examine what you gave it and report back. I am using OpenAI with the gpt-4o engine. The Query Explained Hopefully, you were able to recognize this simple query, which reports the number of dead tuples. Okay, let us try some...