EXPLAIN (ANALYZE, BUFFERS) and interpreting shared buffers hit in Nested Loops

pganalyze.com

EXPLAIN (ANALYZE, BUFFERS) and interpreting shared buffers hit in Nested Loops

pganalyze.com

Jason Novinger@programming.devM to

PostgreSQL@programming.dev · 2 years ago

We explain how the BUFFERS option for EXPLAIN ANALYZE works, and why the shared hits counter is hard to interpret in Nested Loops.

You must log in or # to comment.

Chat

PostgreSQL@programming.dev

postgresql@programming.dev

Create a post

You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !postgresql@programming.dev

The world’s most advanced open source relational database

Project

About (history)
Docs
Donate to PostgreSQL
Wiki
Planet PostgreSQL
IRC
Mailing lists:
- pgsql-announce
- pgsql-hackers (developers)
- pgsql-general
- pgsql-jobs
User Groups

Events

SEAPUG Summer BBQ, 6 July in Seattle
SFBA PostgreSQL Meetup, 12 July
Chicago PostgreSQL Meetup, 19 July
PGDay UK 2023, 12 September in London
PGConf 2023, 3-5 October in New York City
PGDay Israel 2023, 19 October
PGConf.EU 2023, 12-15 December in Prague

Podcasts

postgres.fm (feed)

Related Fediverse communities

c/SQL on programming.dev
#sql on Mastodon
#postgresql on Mastodon

Visibility: Public

This community can be federated to other instances and be posted/commented in by their users.

1 user / day
1 user / week
3 users / month
3 users / 6 months
2 local subscribers
1 subscriber
47 Posts
19 Comments
Modlog