From: Robert Greene <robert.greene@adtran.com>
To: "pgsql-www@postgresql.org" <pgsql-www@postgresql.org>
Subject: blocking_tree view from
 https://wiki.postgresql.org/wiki/Lock_dependency_information
Thread-Topic: blocking_tree view from
 https://wiki.postgresql.org/wiki/Lock_dependency_information
Thread-Index: AdfLab61ea60AQXuRJqhKSdnjnH0nw==
Date: Wed, 27 Oct 2021 19:35:30 +0000
Message-ID: 
 <BN7PR19MB23536F5AB81F057705CF477695859@BN7PR19MB2353.namprd19.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?2Sj5KWvHMTW//+ET9OsuwT62I1F4LHgQin7hHDqNlGfkxgDpyrDcMylcB4XZ?=
 =?us-ascii?Q?v79C7x2f0IitTjhxBnUsdot3l39IAcXiCcvBCg+VxrOd4GkWAa5AQo4vlrpQ?=
 =?us-ascii?Q?wlrj9BDUVxHYNT1ruclCQhRDYZ5+78f509CNQZdeoZiXRVVXx2aZwJhHQHWj?=
 =?us-ascii?Q?msIbDZ4Mm58Er8UmrZfKKr4cbMozXgX378YsjkuLjaTtaPaNDhWdZpfY9D+s?=
 =?us-ascii?Q?5MxMAcU7zKDJUPCDHXU77GNRR7Y1YwLQxA4SSsrBA2qwMLD1aTSDnhkXGBB7?=
 =?us-ascii?Q?hVSj+RFUwsWVF6VB4rJWFuUbHVLJkmkB6RkY4wfrtupZDNqgcPiW5WlFQGl8?=
 =?us-ascii?Q?Ksf/6uNOJ8kpIszw98avza86EyPgmRfrAaSDrai5QLnyFqHLphRQ/G/kGWRN?=
 =?us-ascii?Q?LQTuxn944obvFdBJXuTtuyyNGz3mZEgSlLRDRXq5xWIODT+kHx/1qn8FalOM?=
 =?us-ascii?Q?FWWfl/6NtpdAr3U2zpLJKwcGmZ22TNUkUKcbRwASb1rSNVxFrel5ZUPhdVAf?=
 =?us-ascii?Q?sy2o6Kwk7SDewaWzX/7tvx9L22rmavW1d9/4+uF4ZP9ZrrLkHbG3Rfg8B/2h?=
 =?us-ascii?Q?R7Y8f9cU33Snp9f5VgcK5hVUeRp/di4TyovfzJy2ep51DhDTfn/LPOeINeSU?=
 =?us-ascii?Q?bM3NwUWT+Jqochk+rl9xa8ZB6SRI+dZS9vmI+MOErQYYuNqwrKcm2mwgqMXJ?=
 =?us-ascii?Q?54JsfGKMlUS+rm8l4OlpFzxPAqXNo/7SkYtZL1IsTy/8/DiH+iIIvZkrnQK+?=
 =?us-ascii?Q?KylT19WyO/1AQHnGmNXFwGWiDOT1geR7O+MQQLLSJiEJ39C2JxCF/UeyIlDu?=
 =?us-ascii?Q?K61Bis7VKVFD6ibKKVsbwBt3p0MQyVgGiEM2Z1oOfsQxnv+QDMhYFNp8OaPp?=
 =?us-ascii?Q?ltw3ZqZ7kuNjUeXFRe/w/mmXtH2Bhof397yKTfk0ETmrziTxkKCg2D2zTb/3?=
 =?us-ascii?Q?YLK3ZrP3nfYd7aJPgml8womcPdLRehi3LFSXv785lphP6uYh3TC8nLS1P8zP?=
 =?us-ascii?Q?mMS/lIMksRgoNpmuDsYtWh//kd5NynlSLiJkK4ZKtifq1NriOMUjOtBCIrMo?=
 =?us-ascii?Q?vDdXW4iuzE4SfuzZFULF9lX6RUn9LB7faIWsobteVgw5ZvgaTWVUJDxeEQ5N?=
 =?us-ascii?Q?8V9bSooHHzp4QwG1z72Qm4sTqczHpdXdLwccRnzbQH2VxUCnpEGKjigBzzMl?=
 =?us-ascii?Q?2RE9UIBc+LCRqyB4B0mSozVjcy4KPudX6GfBRn7C4bIt6QIJSpT70yuOwwV6?=
 =?us-ascii?Q?9f4hH13+g0HwRpYnBD6+NxRch7PiBAkChJVcrPwQWf0Ud06WevVvkjM1ZTca?=
 =?us-ascii?Q?1HMRkksVCGzZ1y+d6GXvbTSPPyH07HHLMye2IszRYhGRfWK7nav+Ryx17H+Y?=
 =?us-ascii?Q?vREyoknW3O41uTNSMnYYT1VKrPy+qSV49WhA/kZY9QrhXdDRLLMrBOcpwOFw?=
 =?us-ascii?Q?ZCGrftp8w8DMI0K9LoBEP740sCwzHWDVCQ6xoFiABY3EjPCjueRREJwT2i4l?=
 =?us-ascii?Q?zJh8Dc2ZABWpezwqGpmRRERnnisk6eazkL5E1ma1FssDIKlDL8qgHiAh0Ugs?=
 =?us-ascii?Q?7Vb2RErPwloSuMegt9LOoB9VBRdIQmqtPBjxFL9lyIBNhJax1GLMq8Ai0JkM?=
 =?us-ascii?Q?ICtTRiEvpyPT3s4Z7SL9YhqQFiWl7HAZliD7OMOBg/kayqlYGzgQiasbudJM?=
 =?us-ascii?Q?TffcQjDYaUm+S7RIUihZ9uiEceim8qJeefE+mSu3VHgioYXuoEs63nsKynTa?=
 =?us-ascii?Q?01A8BWlWCQ=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_BN7PR19MB23536F5AB81F057705CF477695859BN7PR19MB2353namp_"
MIME-Version: 1.0
X-OriginatorOrg: adtran.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: BN7PR19MB2353.namprd19.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 d485ef27-6d08-492e-cba6-08d99980efd2
X-MS-Exchange-CrossTenant-originalarrivaltime: 27 Oct 2021 19:35:30.6409
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 423946e4-28c0-4deb-904c-a4a4b174fb3f
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 BV1FI/RdXPgX+UbyLGpMxBDa0/JhZTKPuo1vIhs9BYkvMf5UWsdx5ua6f/r+OGJKcGXgWP7dxh+YWMfdXUPWBFilQH/2x56RqR0C767CKaI=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN8PR19MB2529
List-Id: <pgsql-www.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-www@lists.postgresql.org>
List-Owner: <mailto:pgsql-www-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-www>
Archived-At: 
 <https://www.postgresql.org/message-id/BN7PR19MB23536F5AB81F057705CF477695859%40BN7PR19MB2353.namprd19.prod.outlook.com>
Precedence: bulk

--_000_BN7PR19MB23536F5AB81F057705CF477695859BN7PR19MB2353namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I cant get the blocking_tree view to work.

The lock_composite view / table / whatever doesn't exist?

Is there something I need to install? A specific version of Postgresql I ne=
ed to use?


--_000_BN7PR19MB23536F5AB81F057705CF477695859BN7PR19MB2353namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">I cant get the blocking_tree view to work.<o:p></o:p=
></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">The lock_composite view / table / whatever doesn&#82=
17;t exist?<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Is there something I need to install? A specific ver=
sion of Postgresql I need to use?<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
</body>
</html>

--_000_BN7PR19MB23536F5AB81F057705CF477695859BN7PR19MB2353namp_--