Re: Does Postgres have consistent identifiers (plan hash value) for explain plans?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jerry Brenner <jbrenner(at)guidewire(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Does Postgres have consistent identifiers (plan hash value) for explain plans?
Date: 2023-12-04 14:57:24
Message-ID: 756532.1701701844@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jerry Brenner <jbrenner(at)guidewire(dot)com> writes:
> Both Oracle and SQL Server have
> consistent hash values for query plans and that makes it easy to identify
> when there are multiple plans for the same query. Does that concept exist
> in later releases of Postgres (and is the value stored in the json explain
> plan)?

No, there's no support currently for obtaining a hash value that's
associated with a plan rather than an input query tree.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Julien Rouhaud 2023-12-04 17:30:12 Re: Does Postgres have consistent identifiers (plan hash value) for explain plans?
Previous Message Jerry Brenner 2023-12-04 14:45:39 Does Postgres have consistent identifiers (plan hash value) for explain plans?