Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TEMPORARY TABLE t_temp_streams_to_delete
- ON COMMIT DROP
- AS (SELECT ID FROM t_stream WHERE NAME LIKE '/customer:[REDACTED]/%')
- WITH DATA;
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
- --------------------+--------------------------+-----------+----------+-----------------------------------+----------+--------------+-------------
- position | bigint | | not null | nextval('position_seq'::regclass) | plain | |
- timestamp | timestamp with time zone | | not null | now() | plain | |
- stream_id | integer | | not null | | plain | |
- event_type | udt_event_type | | not null | | extended | |
- metadata_encoding | udt_encoding | | | | extended | |
- metadata_content | text | | | | extended | |
- data_encoding | udt_encoding | | not null | | extended | |
- data_content | text | | not null | | extended | |
- stream_wildcard_id | integer | | not null | | plain | |
- Partition key: RANGE ("position")
- Indexes:
- "t_status_pkey" PRIMARY KEY, btree ("position")
- "idx_t_status__pos_sw_wildcard_id" btree ("position", stream_wildcard_id)
- "idx_t_status__stream_wildcard_id" btree (stream_wildcard_id)
- "idx_t_status__sw_wildcard_id_pos" btree (stream_wildcard_id, "position")
- "idx_t_status_event_type" btree (event_type)
- "idx_t_status_stream_id" btree (stream_id)
- "idx_t_status_timestamp" btree ("timestamp")
- Foreign-key constraints:
- "fk_t_status__stream_wildcard_id" FOREIGN KEY (stream_wildcard_id) REFERENCES t_stream_wildcard(stream_wildcard_id)
- "t_status_stream_id_fkey" FOREIGN KEY (stream_id) REFERENCES t_stream(id)
- Partitions: t_status_148000000_149000000 FOR VALUES FROM ('148000000') TO ('149000000'),
- t_status_149000000_150000000 FOR VALUES FROM ('149000000') TO ('150000000'),
- t_status_150000000_151000000 FOR VALUES FROM ('150000000') TO ('151000000'),
- t_status_151000000_152000000 FOR VALUES FROM ('151000000') TO ('152000000'),
- t_status_152000000_153000000 FOR VALUES FROM ('152000000') TO ('153000000'),
- t_status_153000000_154000000 FOR VALUES FROM ('153000000') TO ('154000000'),
- t_status_154000000_155000000 FOR VALUES FROM ('154000000') TO ('155000000'),
- t_status_155000000_156000000 FOR VALUES FROM ('155000000') TO ('156000000'),
- t_status_156000000_157000000 FOR VALUES FROM ('156000000') TO ('157000000'),
- t_status_157000000_158000000 FOR VALUES FROM ('157000000') TO ('158000000'),
- t_status_158000000_159000000 FOR VALUES FROM ('158000000') TO ('159000000'),
- t_status_159000000_160000000 FOR VALUES FROM ('159000000') TO ('160000000'),
- t_status_160000000_161000000 FOR VALUES FROM ('160000000') TO ('161000000'),
- t_status_161000000_162000000 FOR VALUES FROM ('161000000') TO ('162000000'),
- t_status_162000000_163000000 FOR VALUES FROM ('162000000') TO ('163000000'),
- t_status_163000000_164000000 FOR VALUES FROM ('163000000') TO ('164000000'),
- t_status_164000000_165000000 FOR VALUES FROM ('164000000') TO ('165000000'),
- t_status_165000000_166000000 FOR VALUES FROM ('165000000') TO ('166000000'),
- t_status_166000000_167000000 FOR VALUES FROM ('166000000') TO ('167000000'),
- t_status_167000000_168000000 FOR VALUES FROM ('167000000') TO ('168000000'),
- t_status_168000000_169000000 FOR VALUES FROM ('168000000') TO ('169000000'),
- t_status_169000000_170000000 FOR VALUES FROM ('169000000') TO ('170000000'),
- t_status_170000000_171000000 FOR VALUES FROM ('170000000') TO ('171000000'),
- t_status_171000000_172000000 FOR VALUES FROM ('171000000') TO ('172000000'),
- t_status_172000000_173000000 FOR VALUES FROM ('172000000') TO ('173000000'),
- t_status_173000000_174000000 FOR VALUES FROM ('173000000') TO ('174000000'),
- t_status_174000000_175000000 FOR VALUES FROM ('174000000') TO ('175000000'),
- t_status_175000000_176000000 FOR VALUES FROM ('175000000') TO ('176000000'),
- t_status_176000000_177000000 FOR VALUES FROM ('176000000') TO ('177000000'),
- t_status_177000000_178000000 FOR VALUES FROM ('177000000') TO ('178000000'),
- t_status_178000000_179000000 FOR VALUES FROM ('178000000') TO ('179000000'),
- t_status_179000000_180000000 FOR VALUES FROM ('179000000') TO ('180000000'),
- t_status_180000000_181000000 FOR VALUES FROM ('180000000') TO ('181000000'),
- t_status_181000000_182000000 FOR VALUES FROM ('181000000') TO ('182000000'),
- t_status_182000000_183000000 FOR VALUES FROM ('182000000') TO ('183000000'),
- t_status_183000000_184000000 FOR VALUES FROM ('183000000') TO ('184000000'),
- t_status_184000000_185000000 FOR VALUES FROM ('184000000') TO ('185000000'),
- t_status_185000000_186000000 FOR VALUES FROM ('185000000') TO ('186000000'),
- t_status_186000000_187000000 FOR VALUES FROM ('186000000') TO ('187000000'),
- t_status_187000000_188000000 FOR VALUES FROM ('187000000') TO ('188000000'),
- t_status_188000000_189000000 FOR VALUES FROM ('188000000') TO ('189000000'),
- t_status_189000000_190000000 FOR VALUES FROM ('189000000') TO ('190000000'),
- t_status_190000000_191000000 FOR VALUES FROM ('190000000') TO ('191000000')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement