Skip to content

Instantly share code, notes, and snippets.

@mkubala
Created July 10, 2020 11:48
Show Gist options
  • Save mkubala/3fa3ba322e6b71559e4a84896fffac00 to your computer and use it in GitHub Desktop.
Save mkubala/3fa3ba322e6b71559e4a84896fffac00 to your computer and use it in GitHub Desktop.
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