Skip to content

=$
|

  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact

Tag: result

Explaining the unexplainable – part 4

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.

Continue reading Explaining the unexplainable – part 4

Posted on 2013-05-192015-10-13|Tags append, cte, explain, groupaggregate, hashsetop, initplan, postgresql, result, setop, subplan, unexplainable, unique, values|4 Comments on Explaining the unexplainable – part 4

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • Explaining the unexplainable – part 3 281 views | 0 comments
  • Getting value from dynamic column in pl/PgSQL triggers? 213 views | 0 comments
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 200 views | 0 comments
  • Explaining the unexplainable – part 2 173 views | 0 comments
  • Explaining the unexplainable 135 views | 0 comments
  • How much RAM is PostgreSQL using? 128 views | 0 comments
  • how to insert data to database – as fast as possible 117 views | 0 comments
  • How to run short ALTER TABLE without long locking concurrent queries 115 views | 0 comments
  • explain.depesz.com. 114 views | 0 comments
  • Waiting for PostgreSQL 14 – Improvements for handling large number of connections 109 views | 0 comments

PostgreSQL

  • Documentation
  • Explain Analyze analyzer
  • IRC help channel
  • Mailing Lists search
  • PG Planet
  • PostgreSQL Home Page

About me

  • CPAN
  • GitLab
  • Linked In
  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact