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: bitmap

Explaining the unexplainable – part 2

Last time I wrote about what explain output shows. Now I'd like to talk more about various types of “nodes" / operations that you might see in explain plans.

Continue reading Explaining the unexplainable – part 2

Posted on 2013-04-272015-10-13|Tags bitmap, explain, heap, index, only, postgresql, scan, seq, unexplainable|16 Comments on Explaining the unexplainable – part 2

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • How to run some tasks without user intervention, at specific times? 0.9k views | 5 comments
  • Are there limits to partition counts? 822 views | 5 comments
  • Waiting for PostgreSQL 14 – Add pg_stat_database counters for sessions and session time 298 views | 0 comments
  • Waiting for PostgreSQL 14 – Add idle_session_timeout. 205 views | 0 comments
  • Explaining the unexplainable – part 3 196 views | 0 comments
  • Explaining the unexplainable – part 2 165 views | 0 comments
  • How to limit rows to at most N per category – fix 146 views | 0 comments
  • Waiting for PostgreSQL 14 – Report progress of COPY commands 139 views | 0 comments
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 128 views | 0 comments
  • Why is UPSERT so complicated? 95 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