File Information
Key:
/from-materialized-views-to-continuous-aggregates-enhancing-postgresql-with-real-time-analytics.html
Size:
26,786 bytes
MIME Type:
text/html; charset=utf-8
Modified:
6/3/2025, 10:53:09 PM
Storage Details
Bucket:
test
eTag:
619e0a3d0280ad84f71cc8ad160cd6a8
Health:
Healthy (0.95)
Min Shards:
10
Storage Shards
30 ShardsShard 1
Host
ed25519:117c7c201b8ccc8f87d45301ac50e38cffecb147b70e90238a852b18bc06bd79
Contract
b6d3f81db000e2fabf9f876fea48838504d21e49a08872fdc5d96f74e8cea48f
Root Hash
5ac93684e5655882e69136349e2536dbf1e3aa9a2d4eb316480b8c2ef0886a3b
Host
ed25519:baf4061d9865f509722327ff5ca85203523b2a71afd50806c1322b5ca1ac6fcc
Contract
7a53f27390613428b759b1bc6557b8e20ccf82aadab16ed84a51f9e771d307b8
Root Hash
5ac93684e5655882e69136349e2536dbf1e3aa9a2d4eb316480b8c2ef0886a3b
Shard 2
Host
ed25519:f54367610e7917b51e9a731bba11f68a4570415e3518901d6e89c6912e1b2278
Contract
f37caab4328f128208170c028414940d6f247d87e42f28acdbdcb44c51b5aebe
Root Hash
331880a6a6c6d6addc141f0b6e1980a0d3a377657692db96a7a1600fc54b1985
Shard 3
Host
ed25519:8ca44084492c110bf35941ee94a3b351e33a6ce329c3fc97bc4a24507942fc09
Contract
c360d331b1691a928a4b93cd8e7b33a3691b99675b4b212d5b2d24dcf0f02c5a
Root Hash
c74ceec6475ff98f40e91e3c6a14a60b0e0ab277be407b89b67771473e187adb
Shard 4
Host
ed25519:e707b20f95a2ddd58d0dbd98d75cbc8d179187f1842f3aeadc0d612d1654f926
Contract
54520d79421dca59bdf0eac018cef5c3b489541f0f143141ca7f0e6508f2a5ef
Root Hash
7f424b6e6aa8c94a5785e3faf98a593f6cdf83e8ac2823d7946002b832cf48be
Shard 5
Host
ed25519:11f06381ccf85bfd00494c35f53fd3cf3a8766086bdc5bddb6d9c8fb28b90fd0
Contract
21c3f4fd1ac4bc95911de4174a36dd882fc37eeefade6055705e62168bec2813
Root Hash
46d882941081b0af0002162905ccc8ed270f78e9fc8371733d0a726ee952047e
Host
ed25519:be5965c5f52542ea6016875ed4a46cc1173abbced2be47b39f91991f0b21db96
Contract
4866d8a1881295699af8c5cb6a922d4ba43971f67ede393644554f19b7ed8c83
Root Hash
46d882941081b0af0002162905ccc8ed270f78e9fc8371733d0a726ee952047e
Shard 6
Host
ed25519:f291371aedfd74fd8a7f2a42b56ff46ecda298bc72bfd2dd7618408d75a8fc26
Contract
48d58ee7a939bf3e4d071c379ec48d8c8455a13c382a7c99772733137cde8e7d
Root Hash
69f18032afbf97e469cfe37b2aea35eb6a1ec5935003c3145ac8e5c03ed494be
Shard 7
Host
ed25519:88e232320d34210275bc2a8d96d7b6129e16381dcec37e8f846ebd14481e561f
Contract
871b69fa00bab77e11600b4979cf1e0bf4e913a2f86531ed2e1a5152175cf462
Root Hash
5cf4b7f5833f9030992f164561f8701582c768a18d7ef08b69a9cab4f7055bad
Shard 8
Host
ed25519:447ee211d0e1a5a8762577d967443b103c58fcccf8b6305a386bcad1ca5c8f38
Contract
2854d72ecac1c34d803867d9331abcc26a42fafd6cd68c66b59b5812adfe8068
Root Hash
98aa4439a7a07445e5692ad6f94bcd7e9088f99d1b6ad720e422e8d8568f38f2
Shard 9
Host
ed25519:349132f73233db4ef2c5392a5d9e05dfa77dcf273bb4f3d8bd5d990f933a3139
Contract
ff20d2531aeb45615055734b26e51f7df683cc9ed04a9811dc22936bf47ebe65
Root Hash
5686092071664e7899b8e7de7abc0c6135e2a6eac74428ef0ba3e2ded4482861
Shard 10
Host
ed25519:3794d9438e79cbfa16c419c367e4c18ee6b34f5f8a7670e2c3dd485c16787297
Contract
3eba80520e948265480a6ac1c947aaf7e7705d4b97841250e3ddf1900002a1f8
Root Hash
9eef2f010de538d670d4a86d3d84d9ee4bac42285930345c0efba8d439cb7dc3
Host
ed25519:d5bfc8fcf4976b1b17f8ddcd843afc50ce52f144a2dbcff75bd75b0fdbe41249
Contract
d09a892686400d584e0e96b3caa7a1e5cf7f2394bb137408d81ac9dbedad8bfc
Root Hash
9eef2f010de538d670d4a86d3d84d9ee4bac42285930345c0efba8d439cb7dc3
Shard 11
Host
ed25519:be730c67782fa3e170e702592a7595cf248207705bef24844c03967cc545878b
Contract
88ff0fc1e6b642325480af22a07222d8b37bf381576ee172e25e7a0c187da5be
Root Hash
be8356755d211d2196eb12a18e88241b581fc73631f1c06319fb8fb7d5acbd63
Shard 12
Host
ed25519:210ad99f0e16a02ef055fdd0fcb6506106afeaab81b6834de96d6187ebae0c42
Contract
acd77c0b896bd1ca486603656ea84bca9c622b579589f936cddda2111c4ad999
Root Hash
0265b30cbf4dee64b4f51ac04ce972cc42f949e4ffc6632207866a5228b3b971
Shard 13
Host
ed25519:a94e6819e9663a65e05ccfc1d4e5a765c1647cd8458b8e821c3a00a05fd0e684
Contract
05c6c18c1f8a9ec61af8d50bc98809e21b4d4d69c98bf65b9220ff9f01da00df
Root Hash
bfccebc15288fa5dc38670d7e87cdc144df67596e041a116790e318a4d867cd2
Shard 14
Host
ed25519:9e948c608943abfc8c7e2f7aa76672afd1226c78d7ff5d917b9ed6904ae9acca
Contract
ad19773a4d2983c737fb184833fe2f7c1d70217d1f5f847ba8bba3b332dcfd92
Root Hash
cf37f62c163065fee91209f61f62343904a0cf37641027fb913ae038e1e0c2c4
Shard 15
Host
ed25519:cdc7546efacb4da41a5239199873c73f67579cad43354fb085611bd7e375a1ec
Contract
146002d18fbb131861b125834621f65afe513103c10d1cccce8da49d14dbfc24
Root Hash
ba6ce29a7b5037cd9d3478572c2f735614db07d113ef040bf048f2581a19b7b0
Shard 16
Host
ed25519:3077686e977dbe016b6f03ddf6fb9828af8136c10ae6062ec7b2ef99ab3098c2
Contract
a9c0fe3231321e4e0984363035b7fd92aae99d28fd50d8183053cc2b87a7b0ef
Root Hash
c3aa3fa2903453272067e1a632bf3419949f22f46311b1364be7777ce3fe7274
Shard 17
Host
ed25519:35e4a78314ccc770a99309b50ba3e58405aa4b9ba346b484c79a1dbc97282fe3
Contract
9d0420a01f530646994dab7e0c81c8185c7113d3a50b7990951dc7eebf93843e
Root Hash
bbe7be6cf029930183dce1090f84ce7c21264f25f71693d4b8671fc09f32b477
Shard 18
Host
ed25519:3809d0f8a0d9220d39b11ed69f026c6fa4f5df3bcd17d94e1507a9c3e6aa20bc
Contract
86e273f7060ccbbce4ec47bbc61d04cda1cb6739de7064eea02d3eea9bb327aa
Root Hash
e6f2fa4811ec536f27583453843390b2daa55493bcff813f0a013b31b195eb6e
Shard 19
Shard 20
Host
ed25519:cb807bf0edbd86b865aedbf9948ea46949c090a74ce0e1effb5343b0c44f6df6
Contract
4a1af96e75b3546a11c6286e435cc06b1beef809d559690377b2f66002d26ecd
Root Hash
d97b094b96e24ffe98f625fd67e0002f6f22548906bc57df496af474391bbb1b
Shard 21
Host
ed25519:562f3094ac19ed45a93411aeb4519f77cdc7d5c1c9b12160327823452a0c3b4f
Contract
1d8c986e9c8724c036998f736cb9b870b50cf341bc752d9e524a3ddb60b6f543
Root Hash
d309bfe69424b3a624e649d9c31880a9c2081391a5f858bc47e7c956f4efda85
Shard 22
Host
ed25519:5423b9f522f8e14b3dea4da09631b6c8c641132c797c897f5e87077b5920e495
Contract
ebac925f9eaed5de6f29159bafd442014dab4dd3b57bac9bebae3fc0c0cfd85f
Root Hash
ca92602d5032feffd02527b26a8ae4c6e12cb90e1544b9c791a208eee1d88627
Host
ed25519:cf8a860ac55d07d9881c0d6f43fe8b516512de4d6290379581646bc43df19efb
Contract
ce49993890a81b704e04bf41a1184197754752b0f9be635c1dba88d973b8a725
Root Hash
ca92602d5032feffd02527b26a8ae4c6e12cb90e1544b9c791a208eee1d88627
Shard 23
Host
ed25519:a96cf2f4415a4e053128c6c34220b1995fd8fbc10d9f3ac3a8029d48ecdefe44
Contract
e668af7a555ff8832da501d477672eaa50e64562eee5ff8cd9697d81596a688a
Root Hash
65bd0feda949abe821c490d3592b1af5c274ab9d8b40654ff7f15567f4fa127c
Host
ed25519:adae50da5abf55640ea125c9a733fbdc93d67f015dffe340f808ac2383841565
Contract
2eeda296cbcccc769d599bbaeb2d771089b114d54b4bbd8158a278f33b28aeed
Root Hash
65bd0feda949abe821c490d3592b1af5c274ab9d8b40654ff7f15567f4fa127c
Shard 24
Host
ed25519:1bdf513521b27bed0fc278acf40d7e0a43c6f1556fe3789aa89601505d061756
Contract
390929d67c099543edd4539c00ac33afaf64af4f2c7ad2a07ba86a867958c396
Root Hash
6ae7bdfcb920534bf48dcd05f8d17aeb2979808d9c34ced5d587896d1abe2ef1
Shard 25
Host
ed25519:c8b5c8751baa134dcb906b945a796caa196513f0497b874b9a8b77135c5b9702
Contract
78972c8e3b924f7c5ba80d5c4d9d117175c85163009aa15bc7cb61a786a50633
Root Hash
3b65861f1f47645e8ec40f8691d426f8894092b9a620ed148abd315aa0b6f099
Shard 26
Shard 27
Host
ed25519:f166b306fbbcc6a774aead9605e2e9187ed660254a513d68f282a722a4c6b74c
Contract
3a94d4590c83dc70d76374f8b51a60768e07c4fcdd5a3c64e70a7868b8aca30c
Root Hash
30016f3df35b4e18122ad416811e94edfa4437eb559f2617089a46b9db2fda54
Shard 28
Host
ed25519:13b9fe61639e3eae0e6899aca8857d8b239102d3ac11fc79a6791d5072439ee6
Contract
b5414d7e31e71e079a5385652cf44c707ef1bb6753a00bb6601599990dd27a58
Root Hash
e6847735c292985c8d4adf9e82bfe56d428e49931c8da23aa34b95aaa0eecb32
Shard 29
Shard 30