Archiwizowane May, 2013

In previous posts in this series, I talked about how to read EXPLAIN output, and what each line (operation/node) means. Now, in the final post, I will try to explain how it happens that Pg chooses "Operation X" over "Operation Y".

In this, hopefully 2nd to last, post in the series, I will cover the rest of usually happening operations that you can see in your explain outputs.

Word of warning: this blogpost is about thing related to Bash (well, maybe other shells too, didn't really test), but since I found it while doing Pg work, and it might bite someone else doing Pg related work, I decided ...

In previous post in the series I wrote about how to interpret single line in explain analyze output, it's structure, and later on described all basic data-getting operations (nodes in explain tree). Today, we'll move towards more complicated operations.