Skip to content

=$
|

  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … 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: backward

Fixed display of Backward scans on explain.depesz.com

Yaroslav Schekin (ysch) reported on irc that Index Scans Backward do not display properly.

After checking I found out that if explain is in JSON/YAML/XML – node type is changed to “Index Scan" (or “Index Only Scan" if it was originally “Index Only Scan Backward").

Continue reading Fixed display of Backward scans on explain.depesz.com

Posted on 2021-03-03|Tags backward, explain, explain.depesz.com, perl, postgresql|

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • Waiting for PostgreSQL 15 – JSON_TABLE 1k views | 0 comments
  • Explaining the unexplainable – part 3 292 views | 0 comments
  • System roles – what, why, how? 231 views | 1 comment
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 228 views | 0 comments
  • Explaining the unexplainable – part 2 213 views | 0 comments
  • Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default 186 views | 0 comments
  • “ERROR: operator does not exist: integer = text” how to fix it? 155 views | 0 comments
  • How much RAM is PostgreSQL using? 109 views | 0 comments
  • Understanding pg_stat_activity 107 views | 0 comments
  • Explaining the unexplainable 104 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 16
    • … PostgreSQL 15
    • … 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