FilesExpand file tree

 main

/

check_partitions.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

27 lines (23 loc) · 822 Bytes

 main

/

check_partitions.sql

Top

File metadata and controls

• Code
• Blame

27 lines (23 loc) · 822 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

-- Check existing partitions and their boundaries

-- Run this in your PostgreSQL 'jobs' database

-- Check CompletedJob partitions

SELECT

c.relname AS partition_name,

pg_get_expr(c.relpartbound, c.oid) AS partition_bounds

FROM pg_class c

JOIN pg_inherits i ON c.oid = i.inhrelid

JOIN pg_class p ON i.inhparent = p.oid

WHERE p.relname = 'CompletedJob'

ORDER BY c.relname;

-- Check FailedJob partitions

SELECT

c.relname AS partition_name,

pg_get_expr(c.relpartbound, c.oid) AS partition_bounds

FROM pg_class c

JOIN pg_inherits i ON c.oid = i.inhrelid

JOIN pg_class p ON i.inhparent = p.oid

WHERE p.relname = 'FailedJob'

ORDER BY c.relname;

-- Alternative view using pg_partition_tree

SELECT * FROM pg_partition_tree('"CompletedJob"'::regclass);

SELECT * FROM pg_partition_tree('"FailedJob"'::regclass);