We just released a new major feature on pganalyze: Automated EXPLAIN plan analysis and plan visualization.Learn more

EXPLAIN - Hash

Description:

Reads data into a hash table, where it can easily be looked up by the hash key. This is used for hash joins and hash aggregates.

Important Fields:

  • Hash Batches
  • Hash Buckets
  • Original Hash Batches
  • Original Hash Buckets
  • Peak Memory Usage

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →