From: | Alexey Chernyshov <a(dot)chernyshov(at)postgrespro(dot)ru> |
---|---|
To: | PostgreSQL-Dev <pgsql-hackers(at)postgresql(dot)org> |
Subject: | [PATCH] Pageinspect - add functions on GIN and GiST indexes from gevel |
Date: | 2017-07-21 12:05:53 |
Message-ID: | accae316-5e4d-8963-0c3d-277ef13c396c@postgrespro.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi all,
the following patch transfers functionality from gevel module
(http://www.sai.msu.su/~megera/wiki/Gevel) which provides functions for
analyzing GIN and GiST indexes to pageinspect. Gevel was originally
designed by Oleg Bartunov, and Teodor Sigaev for developers of GiST and
GIN indexes.
Functions added:
- gist_stat(text) - shows statistics on GiST Tree
- gist_tree(text) - shows GiST tree
- gist_tree(text, int4) - shows GiST tree up to MAXLEVEL
- gist_print(text) - prints objects stored in GiST tree
- spgist_stat(text) - shows statistics on SP-GiST
- spgist_print(text) - prints objects stored in index
- gin_value_count() - originally gin_stat(text) - prints estimated counts
for index values
- gin_stats() - originally gin_statpage(text) - shows statistics
- gin_count_estimate(text, tsquery) - shows number of indexed rows matched
query
Tests also transferred, docs for new functions are added. I run pgindent
over the code, but the result is different from those I expected, so I leave
pgindented one.
The patch is applicable to the commit
866f4a7c210857aa342bf901558d170325094dde.
--
Alexey Chernyshov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
Attachment | Content-Type | Size |
---|---|---|
0001-gevel_to_pageinspect-v1.patch | text/x-patch | 261.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Yugo Nagata | 2017-07-21 12:09:07 | Re: xlogfilename |
Previous Message | Andres Freund | 2017-07-21 11:58:47 | Re: [PATCH] Make sure all statistics is sent after a few DML are performed |