PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL
The same plan analysis you know from Redshift, now for PostgreSQL — including EXPLAIN ANALYZE, buffer stats, and JSON format.
When...
2026-05-08
84 reads
PlanTrace Now Supports PostgreSQL
The same plan analysis you know from Redshift, now for PostgreSQL — including EXPLAIN ANALYZE, buffer stats, and JSON format.
When...
2026-05-08
84 reads
Here’s a little secret APEX performance hack if you are running on the Autonomous database. As background, I’m running an Autonomous database with six CPUs and a terabyte of...
2026-05-08
76 reads
I’m doing a small series on indexing basics for SQL Server, and on May 14th I’ll be presenting the third part which is about columnstore indexes. You can watch...
2026-05-07
58 reads
These days everything is changing to AI World, IT roles are getting changed and it is going towards AI ways, everyone in IT should be aware of AI –...
2026-05-07
42 reads
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
Introducing PlanTrace — a free, browser-based tool that turns raw execution plans into interactive graphs and actionable tuning insights.
plantrace.studyyourdata.com
PlanTrace...
2026-05-07
104 reads
I went to sleep while reading a Kindle book on my phone. I know because my hand dropped and the phone knocked me in the forehead. I set it...
2026-05-06
127 reads
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent looks like from the client’s side; the users who drifted away, the security work nobody...
2026-05-06
29 reads
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric, and Fabric data agents become part of everyday conversations with customers: will GenAI replace reports...
2026-05-06 (first published: 2026-04-23)
376 reads
For those entering the AI space whether professionally or personally I wanted to give a quick overview on the different models on offer within the Claude family – when...
2026-05-06 (first published: 2026-04-27)
388 reads
Its never been easier to analyze an AWR report. With our new oracle skills repository, your favourite agent can do a respectable job giving some insights into the AWR...
2026-05-06
69 reads
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
Telp/WA 62 8218200203 Jl. Komp. Rs. Fatmawati No.1, RT.1/RW.9, Cilandak Bar., Kec. Cilandak, Kota...
Telp/WA 62 8218200233 Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 Lt GF unit C,...
Telp/WA 62 8218200174 Gedung Multika, Jl. Mampang Prpt. Raya No.71-73, RT.1/RW.1, Tegal Parang, Kec....
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers