]> granicus.if.org Git - postgresql/commit
Add pg_partition_tree to display information about partitions
authorMichael Paquier <michael@paquier.xyz>
Tue, 30 Oct 2018 01:25:06 +0000 (10:25 +0900)
committerMichael Paquier <michael@paquier.xyz>
Tue, 30 Oct 2018 01:25:06 +0000 (10:25 +0900)
commitd5eec4eefde70414c9929b32c411cb4f0900a2a9
tree254b4a9ec2c7d817af93324983319dfc6afdfa73
parent56c0484b2ef10cacdfc3f35e017e8049ecc0800b
Add pg_partition_tree to display information about partitions

This new function is useful to display a full tree of partitions with a
partitioned table given in output, and avoids the need of any complex
WITH RECURSIVE query when looking at partition trees which are
deep multiple levels.

It returns a set of records, one for each partition, containing the
partition's name, its immediate parent's name, a boolean value telling
if the relation is a leaf in the tree and an integer telling its level
in the partition tree with given table considered as root, beginning at
zero for the root, and incrementing by one each time the scan goes one
level down.

Author: Amit Langote
Reviewed-by: Jesper Pedersen, Michael Paquier, Robert Haas
Discussion: https://postgr.es/m/8d00e51a-9a51-ad02-d53e-ba6bf50b2e52@lab.ntt.co.jp
doc/src/sgml/func.sgml
src/backend/utils/adt/Makefile
src/backend/utils/adt/partitionfuncs.c [new file with mode: 0644]
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/test/regress/expected/partition_info.out [new file with mode: 0644]
src/test/regress/parallel_schedule
src/test/regress/serial_schedule
src/test/regress/sql/partition_info.sql [new file with mode: 0644]