List all in bucket from script runtime.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_bucket_read_collection_record_user_id_idx
WHERE deleted_at = 0
AND bucket = 'bucket1'
AND read >= 0
LIMIT 11;
+-------+------------+-------+--------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+--------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_bucket_read_collection_record_user_id_idx |
| 3 | | spans | /0/"bucket1"/0-/0/"bucket1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+--------------------------------------------------------------+
List all in bucket/collection from script runtime.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_bucket_collection_read_record_user_id_idx
WHERE deleted_at = 0
AND bucket = 'bucket1'
AND collection = 'collection1'
AND read >= 0
LIMIT 11;
+-------+------------+-------+--------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+--------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_bucket_collection_read_record_user_id_idx |
| 3 | | spans | /0/"bucket1"/"collection1"/0-/0/"bucket1"/"collection1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+--------------------------------------------------------------+
List all in bucket from client.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_bucket_read_collection_record_user_id_idx
WHERE deleted_at = 0
AND bucket = 'bucket1'
AND read >= 2
LIMIT 11;
+-------+------------+-------+--------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+--------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_bucket_read_collection_record_user_id_idx |
| 3 | | spans | /0/"bucket1"/2-/0/"bucket1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+--------------------------------------------------------------+
List all in bucket/collection from client.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_bucket_collection_read_record_user_id_idx
WHERE deleted_at = 0
AND bucket = 'bucket1'
AND collection = 'collection1'
AND read >= 2
LIMIT 11;
+-------+------------+-------+--------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+--------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_bucket_collection_read_record_user_id_idx |
| 3 | | spans | /0/"bucket1"/"collection1"/2-/0/"bucket1"/"collection1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+--------------------------------------------------------------+
List all for user from script runtime.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_read_bucket_collection_record_idx
WHERE deleted_at = 0
AND user_id = b'user1'
AND read >= 0
LIMIT 11;
+-------+------------+-------+--------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+--------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_read_bucket_collection_record_idx |
| 3 | | spans | /0/"user1"/0-/0/"user1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+--------------------------------------------------------------+
List all for user/bucket from script runtime.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_bucket_read_collection_record_idx
WHERE deleted_at = 0
AND user_id = b'user1'
AND bucket = 'bucket1'
AND read >= 0
LIMIT 11;
+-------+------------+-------+--------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+--------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_bucket_read_collection_record_idx |
| 3 | | spans | /0/"user1"/"bucket1"/0-/0/"user1"/"bucket1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+--------------------------------------------------------------+
List all for user/bucket/collection from script runtime.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_bucket_collection_read_record_idx
WHERE deleted_at = 0
AND user_id = b'user1'
AND bucket = 'bucket1'
AND collection = 'collection1'
AND read >= 0
LIMIT 11;
+-------+------------+-------+-----------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+-----------------------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_bucket_collection_read_record_idx |
| 3 | | spans | /0/"user1"/"bucket1"/"collection1"/0-/0/"user1"/"bucket1"/"collection1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+-----------------------------------------------------------------------------+
List all for user self from client.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_read_bucket_collection_record_idx
WHERE deleted_at = 0
AND user_id = b'user1'
AND read >= 1
LIMIT 11;
+-------+------------+-------+--------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+--------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_read_bucket_collection_record_idx |
| 3 | | spans | /0/"user1"/1-/0/"user1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+--------------------------------------------------------------+
List all for user other from client.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_read_bucket_collection_record_idx
WHERE deleted_at = 0
AND user_id = b'user1'
AND read >= 2
LIMIT 11;
+-------+------------+-------+--------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+--------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_read_bucket_collection_record_idx |
| 3 | | spans | /0/"user1"/2-/0/"user1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+--------------------------------------------------------------+
List all for user self/bucket from client.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_bucket_read_collection_record_idx
WHERE deleted_at = 0
AND user_id = b'user1'
AND bucket = 'bucket1'
AND read >= 1
LIMIT 11;
+-------+------------+-------+--------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+--------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_bucket_read_collection_record_idx |
| 3 | | spans | /0/"user1"/"bucket1"/1-/0/"user1"/"bucket1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+--------------------------------------------------------------+
List all for user other/bucket from client.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_bucket_read_collection_record_idx
WHERE deleted_at = 0
AND user_id = b'user1'
AND bucket = 'bucket1'
AND read >= 2
LIMIT 11;
+-------+------------+-------+--------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+--------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_bucket_read_collection_record_idx |
| 3 | | spans | /0/"user1"/"bucket1"/2-/0/"user1"/"bucket1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+--------------------------------------------------------------+
List all for user self/bucket/collection from client.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_bucket_collection_read_record_idx
WHERE deleted_at = 0
AND user_id = b'user1'
AND bucket = 'bucket1'
AND collection = 'collection1'
AND read >= 1
LIMIT 11;
+-------+------------+-------+-----------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+-----------------------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_bucket_collection_read_record_idx |
| 3 | | spans | /0/"user1"/"bucket1"/"collection1"/1-/0/"user1"/"bucket1"/"collection1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+-----------------------------------------------------------------------------+
List all for user other/bucket/collection from client.
EXPLAIN SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_bucket_collection_read_record_idx
WHERE deleted_at = 0
AND user_id = b'user1'
AND bucket = 'bucket1'
AND collection = 'collection1'
AND read >= 2
LIMIT 11;
+-------+------------+-------+-----------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-------+-----------------------------------------------------------------------------+
| 0 | limit | | |
| 1 | render | | |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_bucket_collection_read_record_idx |
| 3 | | spans | /0/"user1"/"bucket1"/"collection1"/2-/0/"user1"/"bucket1"/"collection1\x00" |
| 3 | | limit | 11 |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-------+-----------------------------------------------------------------------------+
List all in bucket from script runtime with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_bucket_read_collection_record_user_id_idx
WHERE (deleted_at, bucket, read, collection, record, user_id) > (0, 'bucket1', 1, 'collection1', 'record1', b'user1')
AND deleted_at+deleted_at = 0
AND bucket = 'bucket1'
AND read >= 0
LIMIT 11;
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_bucket_read_collection_record_user_id_idx |
| 3 | | spans | /0/"bucket1"/1/"collection1"/"record1"/"user1\x00"- |
| 3 | | filter | ((((deleted_at, bucket, read, collection, record, user_id) > (0, 'bucket1', 1, 'collection1', 'record1', b'user1')) AND ((deleted_at + deleted_at) = 0)) AND (bucket = 'bucket1')) AND (read >= 0) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
List all in bucket/collection from script runtime with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_bucket_collection_read_record_user_id_idx
WHERE (deleted_at, bucket, collection, read, record, user_id) > (0, 'bucket1', 'collection1', 1, 'record1', b'user1')
AND deleted_at+deleted_at = 0
AND bucket = 'bucket1'
AND collection = 'collection1'
AND read >= 0
LIMIT 11;
+-------+------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_bucket_collection_read_record_user_id_idx |
| 3 | | spans | /0/"bucket1"/"collection1"/1/"record1"/"user1\x00"- |
| 3 | | filter | (((((deleted_at, bucket, collection, read, record, user_id) > (0, 'bucket1', 'collection1', 1, 'record1', b'user1')) AND ((deleted_at + deleted_at) = 0)) AND (bucket = 'bucket1')) AND (collection = 'collection1')) AND (read >= 0) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
List all in bucket from client with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_bucket_read_collection_record_user_id_idx
WHERE (deleted_at, bucket, read, collection, record, user_id) > (0, 'bucket1', 2, 'collection1', 'record1', b'user1')
AND deleted_at+deleted_at = 0
AND bucket = 'bucket1'
AND read >= 2
LIMIT 11;
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_bucket_read_collection_record_user_id_idx |
| 3 | | spans | /0/"bucket1"/2/"collection1"/"record1"/"user1\x00"- |
| 3 | | filter | ((((deleted_at, bucket, read, collection, record, user_id) > (0, 'bucket1', 2, 'collection1', 'record1', b'user1')) AND ((deleted_at + deleted_at) = 0)) AND (bucket = 'bucket1')) AND (read >= 2) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
List all in bucket/collection from client with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_bucket_collection_read_record_user_id_idx
WHERE (deleted_at, bucket, collection, read, record, user_id) > (0, 'bucket1', 'collection1', 2, 'record1', b'user1')
AND deleted_at+deleted_at = 0
AND bucket = 'bucket1'
AND collection = 'collection1'
AND read >= 2
LIMIT 11;
+-------+------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_bucket_collection_read_record_user_id_idx |
| 3 | | spans | /0/"bucket1"/"collection1"/2/"record1"/"user1\x00"- |
| 3 | | filter | (((((deleted_at, bucket, collection, read, record, user_id) > (0, 'bucket1', 'collection1', 2, 'record1', b'user1')) AND ((deleted_at + deleted_at) = 0)) AND (bucket = 'bucket1')) AND (collection = 'collection1')) AND (read >= 2) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
List all for user from script runtime with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_read_bucket_collection_record_idx
WHERE (deleted_at, user_id, read, bucket, collection, record) > (0, b'user1', 1, 'bucket1', 'collection1', 'record1')
AND deleted_at+deleted_at = 0
AND user_id = b'user1'
AND read >= 0
LIMIT 11;
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_read_bucket_collection_record_idx |
| 3 | | spans | /0/"user1"/1/"bucket1"/"collection1"/"record1\x00"- |
| 3 | | filter | ((((deleted_at, user_id, read, bucket, collection, record) > (0, b'user1', 1, 'bucket1', 'collection1', 'record1')) AND ((deleted_at + deleted_at) = 0)) AND (user_id = b'user1')) AND (read >= 0) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
List all for user/bucket from script runtime with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_bucket_read_collection_record_idx
WHERE (deleted_at, user_id, bucket, read, collection, record) > (0, b'user1', 'bucket1', 1, 'collection1', 'record1')
AND deleted_at+deleted_at = 0
AND user_id = b'user1'
AND bucket = 'bucket1'
AND read >= 0
LIMIT 11;
+-------+------------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_bucket_read_collection_record_idx |
| 3 | | spans | /0/"user1"/"bucket1"/1/"collection1"/"record1\x00"- |
| 3 | | filter | (((((deleted_at, user_id, bucket, read, collection, record) > (0, b'user1', 'bucket1', 1, 'collection1', 'record1')) AND ((deleted_at + deleted_at) = 0)) AND (user_id = b'user1')) AND (bucket = 'bucket1')) AND (read >= 0) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
List all for user/bucket/collection from script runtime with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_bucket_collection_read_record_idx
WHERE (deleted_at, user_id, bucket, collection, read, record) > (0, b'user1', 'bucket1', 'collection1', 1, 'record1')
AND deleted_at+deleted_at = 0
AND user_id = b'user1'
AND bucket = 'bucket1'
AND collection = 'collection1'
AND read >= 0
LIMIT 11;
+-------+------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_bucket_collection_read_record_idx |
| 3 | | spans | /0/"user1"/"bucket1"/"collection1"/1/"record1\x00"- |
| 3 | | filter | ((((((deleted_at, user_id, bucket, collection, read, record) > (0, b'user1', 'bucket1', 'collection1', 1, 'record1')) AND ((deleted_at + deleted_at) = 0)) AND (user_id = b'user1')) AND (bucket = 'bucket1')) AND (collection = 'collection1')) AND (read >= 0) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
List all for user self from client with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_read_bucket_collection_record_idx
WHERE (deleted_at, user_id, read, bucket, collection, record) > (0, b'user1', 1, 'bucket1', 'collection1', 'record1')
AND deleted_at+deleted_at = 0
AND user_id = b'user1'
AND read >= 1
LIMIT 11;
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_read_bucket_collection_record_idx |
| 3 | | spans | /0/"user1"/1/"bucket1"/"collection1"/"record1\x00"- |
| 3 | | filter | ((((deleted_at, user_id, read, bucket, collection, record) > (0, b'user1', 1, 'bucket1', 'collection1', 'record1')) AND ((deleted_at + deleted_at) = 0)) AND (user_id = b'user1')) AND (read >= 1) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
List all for user other from client with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_read_bucket_collection_record_idx
WHERE (deleted_at, user_id, read, bucket, collection, record) > (0, b'user1', 2, 'bucket1', 'collection1', 'record1')
AND deleted_at+deleted_at = 0
AND user_id = b'user1'
AND read >= 2
LIMIT 11;
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_read_bucket_collection_record_idx |
| 3 | | spans | /0/"user1"/2/"bucket1"/"collection1"/"record1\x00"- |
| 3 | | filter | ((((deleted_at, user_id, read, bucket, collection, record) > (0, b'user1', 2, 'bucket1', 'collection1', 'record1')) AND ((deleted_at + deleted_at) = 0)) AND (user_id = b'user1')) AND (read >= 2) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
List all for user self/bucket from client with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_bucket_read_collection_record_idx
WHERE (deleted_at, user_id, bucket, read, collection, record) > (0, b'user1', 'bucket1', 1, 'collection1', 'record1')
AND deleted_at+deleted_at = 0
AND user_id = b'user1'
AND bucket = 'bucket1'
AND read >= 1
LIMIT 11;
+-------+------------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_bucket_read_collection_record_idx |
| 3 | | spans | /0/"user1"/"bucket1"/1/"collection1"/"record1\x00"- |
| 3 | | filter | (((((deleted_at, user_id, bucket, read, collection, record) > (0, b'user1', 'bucket1', 1, 'collection1', 'record1')) AND ((deleted_at + deleted_at) = 0)) AND (user_id = b'user1')) AND (bucket = 'bucket1')) AND (read >= 1) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
List all for user other/bucket from client with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_bucket_read_collection_record_idx
WHERE (deleted_at, user_id, bucket, read, collection, record) > (0, b'user1', 'bucket1', 2, 'collection1', 'record1')
AND deleted_at+deleted_at = 0
AND user_id = b'user1'
AND bucket = 'bucket1'
AND read >= 2
LIMIT 11;
+-------+------------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_bucket_read_collection_record_idx |
| 3 | | spans | /0/"user1"/"bucket1"/2/"collection1"/"record1\x00"- |
| 3 | | filter | (((((deleted_at, user_id, bucket, read, collection, record) > (0, b'user1', 'bucket1', 2, 'collection1', 'record1')) AND ((deleted_at + deleted_at) = 0)) AND (user_id = b'user1')) AND (bucket = 'bucket1')) AND (read >= 2) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
List all for user self/bucket/collection from client with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_bucket_collection_read_record_idx
WHERE (deleted_at, user_id, bucket, collection, read, record) > (0, b'user1', 'bucket1', 'collection1', 1, 'record1')
AND deleted_at+deleted_at = 0
AND user_id = b'user1'
AND bucket = 'bucket1'
AND collection = 'collection1'
AND read >= 1
LIMIT 11;
+-------+------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_bucket_collection_read_record_idx |
| 3 | | spans | /0/"user1"/"bucket1"/"collection1"/1/"record1\x00"- |
| 3 | | filter | ((((((deleted_at, user_id, bucket, collection, read, record) > (0, b'user1', 'bucket1', 'collection1', 1, 'record1')) AND ((deleted_at + deleted_at) = 0)) AND (user_id = b'user1')) AND (bucket = 'bucket1')) AND (collection = 'collection1')) AND (read >= 1) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
List all for user other/bucket/collection from client with cursor.
EXPLAIN(exprs) SELECT user_id, bucket, collection, record, value, version, read, write, created_at, updated_at, expires_at
FROM storage@deleted_at_user_id_bucket_collection_read_record_idx
WHERE (deleted_at, user_id, bucket, collection, read, record) > (0, b'user1', 'bucket1', 'collection1', 2, 'record1')
AND deleted_at+deleted_at = 0
AND user_id = b'user1'
AND bucket = 'bucket1'
AND collection = 'collection1'
AND read >= 2
LIMIT 11;
+-------+------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Type | Field | Description |
+-------+------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0 | limit | | |
| 0 | | count | 11 |
| 1 | render | | |
| 1 | | render 0 | user_id |
| 1 | | render 1 | bucket |
| 1 | | render 2 | collection |
| 1 | | render 3 | record |
| 1 | | render 4 | value |
| 1 | | render 5 | version |
| 1 | | render 6 | read |
| 1 | | render 7 | write |
| 1 | | render 8 | created_at |
| 1 | | render 9 | updated_at |
| 1 | | render 10 | expires_at |
| 2 | index-join | | |
| 3 | scan | | |
| 3 | | table | storage@deleted_at_user_id_bucket_collection_read_record_idx |
| 3 | | spans | /0/"user1"/"bucket1"/"collection1"/2/"record1\x00"- |
| 3 | | filter | ((((((deleted_at, user_id, bucket, collection, read, record) > (0, b'user1', 'bucket1', 'collection1', 2, 'record1')) AND ((deleted_at + deleted_at) = 0)) AND (user_id = b'user1')) AND (bucket = 'bucket1')) AND (collection = 'collection1')) AND (read >= 2) |
| 3 | scan | | |
| 3 | | table | storage@primary |
+-------+------------+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+