HackerNoon Logo Sia Logo

Sia Storage Meta Data

File Information

Key: /using-simple-indexes-to-optimize-complicated-sorts-in-postgres-1761b097d97c.html
Size: 20,306 bytes
MIME Type: text/html; charset=utf-8
Modified: 6/26/2025, 2:56:17 PM

Storage Details

Bucket: test
eTag: e38470c0138b1afc980988e4b17ff309
Health: Healthy (1)
Min Shards: 10

Storage Shards

30 Shards
Shard 1
Host
ed25519:117c7c201b8ccc8f87d45301ac50e38cffecb147b70e90238a852b18bc06bd79
Contract
c614e4f9c03bdcb4870056cfd3f381e85a8621aebcfdffcbdbb478d0d5816b63
Root Hash
2fe26d1f0e33efeea5e4761970b548e415135a75eaba33c6c85176ecc79a304f
Shard 2
Host
ed25519:72e8ea2c2de3987608c360b574327c201ecbe34037dd47d51135370828650706
Contract
a40d26616686189852b08f65c95284ec9021a996eb4e4f721e8115287d04e159
Root Hash
dab0ce1452267d827ae44020319fed9cbbb53af503f7a2fb7bf73b96c6f58651
Shard 3
Host
ed25519:7c9f8497908643330dd544bc199fc45fc7833d2f48499ecd995404448d2dcb30
Contract
cc3e516a6d8f7b2018a7c830e12d0ed7f3829c0efead537ceaa18309ad66f105
Root Hash
e5a375dbe9355840d4dc877d50b92d52680e72696a0b8b2920161a971869b7ce
Shard 4
Host
ed25519:f54367610e7917b51e9a731bba11f68a4570415e3518901d6e89c6912e1b2278
Contract
bb1d93efa37157d9d822bfa420f17686dfce81675f2131de33707299cf5c56f3
Root Hash
624af9ae1014d92f4f4ba7b2844799310abd3ec5a23af509feac79852605d286
Shard 5
Host
ed25519:35e4a78314ccc770a99309b50ba3e58405aa4b9ba346b484c79a1dbc97282fe3
Contract
10b099d4d48b02a79405acda58ab303fa57fa45e9f8df13f9040e385d0a49d8d
Root Hash
739c35fe71d637f82582ceeca8e76d8efb3a52534df9fc95276df4b32171e38b
Shard 6
Host
ed25519:d02b58248a4ad14863dae54428b93ae8b8ecbb0aa72fcb6a5bf075499f7e785a
Contract
df9b6c9f3b339013588670b21dbc02c944d6fc7e0fb9f57cdbdcac36de270bb9
Root Hash
9f4d9bbc35c2506475f219c0602bd5143883bf530d6d7680ec188da90718ca7b
Shard 7
Host
ed25519:13b9fe61639e3eae0e6899aca8857d8b239102d3ac11fc79a6791d5072439ee6
Contract
e4511cb12b429324c00ee23b4edc0363580a560d938108c8a1a1d0eb4f7e6d20
Root Hash
89ee4a87108b33f5a715b33d3642871c92a7af55e4ca86497c17dd7b4e4b4641
Shard 8
Host
ed25519:8ca44084492c110bf35941ee94a3b351e33a6ce329c3fc97bc4a24507942fc09
Contract
def105f3b2ce699e50ed3214d2449997c48f89e41f78145ddc14674284652991
Root Hash
f063b16502a4ff859bc192419e8ad0b4efec5db91839589c3b33781584aff084
Shard 9
Host
ed25519:40dcaf4ac2c93116853d528c0354abf2fda8481c6c32da8a517253f2afa2a6df
Contract
8b5ffea3300cc74e7800fe645488773e1d8fc3636b33e694f7e194576d4c4ccd
Root Hash
1b318175b94252e8c640a8b7b0eade5ad980daab8ab69583f96565fa05c60a39
Shard 10
Host
ed25519:cf8a860ac55d07d9881c0d6f43fe8b516512de4d6290379581646bc43df19efb
Contract
42cb65e059c7248b69a8793b8bc4836d198ff721aa388b5e7769f0642917bd09
Root Hash
855bb4614e70dda7b984bb52091e4ab2f54cfff9b981c096465b8535044ca35a
Shard 11
Host
ed25519:b28c0c36b9cdcad8f4c7951fe617409857f4b0d03ce2829a814ff9685056a2eb
Contract
9f0d375efbc103b09c3fba3ed133f852a7cde049521179ba442760a4356c4401
Root Hash
2021a94a2f620a2ed676950c66c803a9aa784d6c0a11ab0623bae78688ad05aa
Shard 12
Host
ed25519:14abb9d376abdc3e3920e76cd27d8d4271fa2ea0fe08b74df897adf22329d235
Contract
83b386108865ac036145130962057751b0aefc709ef39b2234f6ad568c83b0b8
Root Hash
ce73608a2ddb13f979f8203a2af24c4a19ed95d28cd7f610ca2fe9a503a87060
Host
ed25519:f51464221096264da92e0852a7d7e7bb821b39288edba39537e90e6409a142a0
Contract
0b4e9600be855e65903e5c92150bdb550e142bda35f2a58d16b3c323e0848df6
Root Hash
ce73608a2ddb13f979f8203a2af24c4a19ed95d28cd7f610ca2fe9a503a87060
Shard 13
Host
ed25519:cdc7546efacb4da41a5239199873c73f67579cad43354fb085611bd7e375a1ec
Contract
6d283e1f390c3e33b94fbf8f0e4c4fcc42b8a172e9f51c2c6fbe1247b57e84ab
Root Hash
ea44f84bf77b3dcf770a66d94c0a9cacd902d519306362f2ddc2cc47da809394
Shard 14
Host
ed25519:3ede3b85525973a29076c62bc13681be47f81102907993444eb307116c30c54a
Contract
d888cf160fde0fd39b03317b49441c75191cec01c59a01bee5ae65530a797ed5
Root Hash
a53364fa570954e8f3951dae61cdc5d2d09f93387ef7af434ae2973b8311ca0f
Host
ed25519:fd9090f5973fc92410e141d2ca7112f266a5f9e5aca9a7024f4116b5a3504274
Contract
8efd36587652215384dbdf52c0ed405fec73ab6c2661bcbe36c8e9b5d074bf31
Root Hash
a53364fa570954e8f3951dae61cdc5d2d09f93387ef7af434ae2973b8311ca0f
Shard 15
Host
ed25519:e707b20f95a2ddd58d0dbd98d75cbc8d179187f1842f3aeadc0d612d1654f926
Contract
79a7ee15919a3cd7c6de8e4d17a58f9df68c55ecd7fb5c16f400bfdfcf186c86
Root Hash
f2bd586798f7ca0bf75f9272932ae50ed83d3b57e858930819dd91843b486095
Shard 16
Host
ed25519:daf30cea1a9c3509460e7a719e59c4ccd29b365e8df52b2bad4d79d94ebfcdbe
Contract
f388c210892ac2e03ebf010c41acf9177b13548c41bfcec1ef69a178a67c85d3
Root Hash
0ad0ff981bf8f098bf771496e5c27642cf44ea9f84b3fbf4cb183cb86708a49b
Shard 17
Host
ed25519:a94e6819e9663a65e05ccfc1d4e5a765c1647cd8458b8e821c3a00a05fd0e684
Contract
95730494baa41932c398c8b3874f3393058a97b413ac80da596d94ee2add2d42
Root Hash
294867329d2850c386e05c56cfa443f44b4c15665bc36e814c9021a1d072deb3
Shard 18
Host
ed25519:d300668a497a01a6924bd4393b131b377652c0eb4c08a7df2a73d4a95d95c22f
Contract
d1c9563bdf9ac06320eb76df4a0bbc54e0be459f01a600eb54e5179889757555
Root Hash
4341f6664e368a199c11a22ae4f352938cd524d16592dfecf8723207eb78621b
Shard 19
Host
ed25519:210ad99f0e16a02ef055fdd0fcb6506106afeaab81b6834de96d6187ebae0c42
Contract
93dd017146e8830b728dc747345c6b021d09cd336a13a09518a42c03eefad098
Root Hash
7bfe34ffa33c05b7a0087f019b68dac45e6b805cee34b94c1776061b319097b1
Shard 20
Host
ed25519:be5965c5f52542ea6016875ed4a46cc1173abbced2be47b39f91991f0b21db96
Contract
f15b9e9ca3101cf9211bba1cab44cc7018120938ade6d0235a74be3a86ad72dd
Root Hash
56b763fd5e2ac465324e170158083ba3d082b08499f22b58ba4b5b79916c75a6
Shard 21
Host
ed25519:f291371aedfd74fd8a7f2a42b56ff46ecda298bc72bfd2dd7618408d75a8fc26
Contract
e51f5b8c956fc0b634bec2f9bbd1af766f0573017f0bb8a4b6038b64ccdd88e7
Root Hash
d981ca36449da66ed62aac76f348d1833cf4d495706a23a8f8331991ae8a0b94
Shard 22
Host
ed25519:2b1935e35bf85862a6fb0dde3d637e76a00b6f09bf7d0be897a821aa7efe986f
Contract
e8aceaa325497aa8dde68be7b2277b73e0af6f0bedb4d648dee3aa179aa1ce78
Root Hash
dadd4315a69301590db3aa1b97fcae110199ef97c1e3e3690dac2b14815501e8
Host
ed25519:6f6b07c8206d7077b559fcd65652ac3c106cd457317ee7bcfdfce8e022fd1fae
Contract
db3ffaf1110950a2b6b20bdbf42f75e2ad5b34a46db1863eafd57d706dee8bfb
Root Hash
dadd4315a69301590db3aa1b97fcae110199ef97c1e3e3690dac2b14815501e8
Shard 23
Host
ed25519:2addd5035bb22992038a7d981b4da6cb329a80cb5b7ecd5adfa50a48e470e215
Contract
1dce52f9a23c294ca3b7e75500341b1ca1faf70a25652749e0ceecad6ae42b65
Root Hash
5e2ddf82dd7a805b6a0a67b9763e4d4852fc4c1cb806a362bad08bee78ad368b
Shard 24
Host
ed25519:6d1b26661f3866e089a6372bc97152a583b20c9ad9c802fff5818afc411c3d7b
Contract
efd16a78dac9c9ca833fec17588162b3b08ea5bb49002a9c83f1bd3c1924b380
Root Hash
9a8913233c489c0e8ad260aa436023895862f68632ef9f1f52c7bf7f3a127bf3
Shard 25
Host
ed25519:4298a298dd84bc48028f7bcf267e8b779a41fa671df3924cf47199fc7d344e2c
Contract
c9175cf5d2c5b657072f9343ae9886c2d536dc4791671c5fd0ccb3e87754c538
Root Hash
819185a3347357b2d58d75b70559e8aed6f0954ea99fef8e0bc9e791e7527679
Shard 26
Host
ed25519:20a79a1287530c1c8c4066783d3f129c949aab4eb59edac5d1b44baf2d1d109c
Contract
8bbeabe5445ef24c2fe1ec9b472e2f01805cf3ef6470efc082ae8821aab3583c
Root Hash
30de5b78b52d27db14b22c0a1c4665fcbb111a8b6001f9db4a523a77c71a64e8
Shard 27
Host
ed25519:1effbcd6411c6a305c9f6bb43c42e4f2da1d674e3f179259777beb259faaa194
Contract
6492a2be1a6be18723d7d473a8a7b46e57d82557d6cc2bae43c0fb03b682bd35
Root Hash
dadd4501bd9e1ac79a4a10793fbdde327c7b692ff6cb5a94e561e2fa2e5a2651
Shard 28
Host
ed25519:562f3094ac19ed45a93411aeb4519f77cdc7d5c1c9b12160327823452a0c3b4f
Contract
64131da9737965a92b20d6edd15223e682e8eb66d53ae970537fbfc285bcd410
Root Hash
37ca4eea5c286b46c4b5c457cce4cb57d190b5d8203789ff5f1d8d3353d0552b
Shard 29
Host
ed25519:f166b306fbbcc6a774aead9605e2e9187ed660254a513d68f282a722a4c6b74c
Contract
c526edd4ca9b27a70050604ddeabf1a39aa07e97fee1e77e9b48ffcec56e4799
Root Hash
d53007d00c360a046445d1a39359f1e3d1b451ccbeaa2026cecabd577288e1f2
Shard 30
Host
ed25519:cfc3034e2270ebf2f55683b5ff485b6678186417d2f8def08e4e2c25912af321
Contract
2f3424a7247a874cf32e7b8ac666f5d6876ab8cfdedf2ca91c71015f4c089fd7
Root Hash
eeaf83615f888f56fcaf051a4a1dc268651379e45bf6050897d6f9ba88740ab1