Created
July 10, 2020 11:48
-
-
Save mkubala/3fa3ba322e6b71559e4a84896fffac00 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
psql> \d+ journal_0 | |
Partitioned table “public.journal_0" | |
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description | |
-----------------+-----------+-----------+----------+-----------------------------------------------+----------+--------------+------------- | |
ordering | bigint | | not null | nextval('journal_ordering_seq'::regclass) | plain | | | |
sequence_number | bigint | | not null | | plain | | | |
deleted | boolean | | not null | false | plain | | | |
persistence_id | text | | not null | | extended | | | |
message | bytea | | not null | | extended | | | |
tags | integer[] | | | | extended | | | |
Partition of: journal FOR VALUES IN ('p-0') | |
Partition constraint: ((persistence_id IS NOT NULL) AND (persistence_id = 'p-0'::text)) | |
Partition key: RANGE (sequence_number) | |
Indexes: | |
"journal_0_pkey" PRIMARY KEY, btree (persistence_id, sequence_number) | |
"journal_0_ordering_idx" brin (ordering) | |
Partitions: journal_0_0 FOR VALUES FROM ('0') TO ('10000000'), | |
journal_0_1 FOR VALUES FROM ('10000000') TO ('20000000') |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment