Some time ago I wrote a site to paste SQL queries with reformatting/pretty-printing using pgFormatter library. Today, I figured out that I should update the library since it has quite some changes recently, so it would be good to incorporate its ...

Couple of times, in various places, I was asked: what is the benefit from upgrading to some_version. So far, I just read release docs, and compiled list of what has changed. But this is not necessarily simple - consider upgrade from 9.3.2 ...

On Friday, Zr40 reported on irc that explain.depesz.com doesn't show table/index names for Parallel Seq Scan nodes. Checked it and found couple of other omissions of the same kind with other Parallel* scans. Fixed (I hope) all of them in: Pg::Explain plan parsing ...

Long time ago I wrote first version of explain.depesz.com. Since then I gradually improve it. But, what was lacking was a way to paste queries too - explain.depesz.com handles explains, but not plain queries. Now this has changed. I created new ...

Today, on irc, someone asked interesting question. Basically she ran a query like: select a, b, c, d, e, f from table order by a then, she processed the query to get, for each a array of unique values of b, c, d, ...

Quite a long time ago (in October), Oskar Liljeblad reported a bug in anonymization. Namely - group keys were not anonymized. You can see example of such plan here. I finally got to it, fixed the bug, pushed new version to live ...

February 3rd, 2015 by depesz | Tags: , , , , , , | No comments »

Just thought I'll share a "fun" story. Friend reported weird bug - OmniPITR reported that xlogs are sent to archive, but they actually weren't. After some checking we found out that he was giving custom rsync-path (--rsync-path - path to rsync ...

Recently I saw this discussion on LinkedIn. In there a guy asks whether modifying script while it's executing will change the way it executes.

There are some cases where you might want to get your own copy of explain.depesz.com. You might not trust me with your explains. You might want to use it without internet access. Or you just want to play with it, ...

Uploaded new version to the server - straight from GitHub. There are two changes - one visible, and one not really. The invisible change, first, is one for people hosting explain.depesz.com on their own. As you perhaps know you can get ...