Sentry nodestore_node 表压缩存储格式分析

Sentry 提供了一个名为“nodestore”的抽象，用于存储键/值 blob。
默认后端只是将它们作为 gzipped blob 存储在默认数据库的“nodestore_node”表中。
Django 后端使用 gzipped json blob-as-text 模式将所有数据存储在“nodestore_node”表中。

后端不提供任何选项，因此只需将其设置为空字典即可。

SENTRY_NODESTORE = 'sentry.nodestore.django.DjangoNodeStorage'
SENTRY_NODESTORE_OPTIONS = {}

PostgreSQL 表 nodestore_node, 有3个字段：id, data, "timestamp"，其中 data 为base64转码过的zlib压缩过的 json 文本数据。

data 字段样例数据

eJztmv9v2zYWwP8VQ8ABdzhZJSlSJA0ccEWX7Yo1t63NMBwSQ6BEylEsS6q+JDWC/O/3SNmxszm1NtzaA5xfYoXkI9+XDx9p69178cp0TZ623uzeS9adaYO8XJi2Mzowt6bsvJmIJPM3fW1XNbseKSP0AF2NUUtd3ZVukrZWZVzV7hk+Ap3Yp77MQcBb5UWRtyatSu353q0qeuPNMA4YoTBRV3WqCLp8ZY6JEBpI/PAAMtDemU+dW67py61w0ueFBukwgNnF5K8rlZf+5Fw1E0wmBBHqTzCeMTJD5G+Ty+/evIH2gARoDmuUys7hvflx3V1XJTR069o2bKcHLUzT5tC1nd+zyjcqdUubT2nRt/mtiQdlcMAF9r1r1V6DAFXcIJOmUiqOFVEwW1VD+8fe9CboVLsMUlOYZg0dzpW5NUMhE2lQWxoUIWNS29mprgezvWrpbVYfxhqOWSRDIxIjKKdEcR2GJKSK0SiiiO0MGlR2XuyLunHubiGyzdopAuE2pY5rAAJkTHmbN1W5cpH36qbSfdrlzj8Oh2HxJJVKcpyEicpoijMRIooiEaEsoxxTG0KIVqOsowY7pzeVI0Q1C7Dmcu57y7vh+d56FfSINwF5RjUY1a7bAGRuQd57FYA2t6+SvHw1CMCSEDn4e1c1S9N4cxBYNFVvhWPAJ8sXLmzltSpTY+2zXv3+3c+38YfX/7n76fXr5d3371vCCh3+G5lfPhU/3Ly9O785786/OevOL777CeZ2xpfmru3WhZlBpMIpwlOMrXZLsx6cg2FgAc4q4Dkvs8r+W6WqG1B61vNFtViA3jMPnldGtX2z1fLeK/tVXGWxJaXd2zRlVZq9DQZg2yjDVldadc75Yxbu8q74vOPLShuXE+K8bE0DS2OOJQslESjAnMow9L26UF1WNSuLzXZLAT83JrXjITomNbBd9FPhEMmQ284CTLZaJCpdwtr/hL3PAvz3vlyWkHPsTtBLa1EOiWDROKMsSJ4DwvcUpAfwie89bittdF9b9+gbVS6qx4dYddUqTx2iqalBU7e1rPsHf6yA+cK0Fiijc/fZtwD+EMq200WeWLddQ0LUVmT+mEw2LhzsDx4XrsEmBekW9L3fDq3XdT4bxk+tafvpxuYoYGp+oG2TLg6Q7djTJlN90Vk0yRSjKeFbkWHxLRcr07bK2hvYyOal82ewUW0zieNwO2x4MoFbhaFQGZSFU4FVNqVGkGmSMjFNZaYYTlPNJDko3RjrnrTqbXZB+yNgb3fGsqNWH+tH7w7LYQobjVIhCEIoorvejb7nkPUvXIs1FgxKm7w+Rv2v83cY8JCMzN+AdQqau8g2Nil+PoWDlvFGJFZtPMh4s67pzZPsr7MUJxHOiMJaCz1k/6ZzCsLTqn6ydVDE3b7rlM2iZV8UdisfHClwiOXvOz0e/B0sOgme8G23UrKLWF213aIx7cfCamwaYDZQWjfWQ1uR6ebj0Ni6shnFYzQk/8PAw8Yober5baRZQB/jnICxCqWGRiyDMNNtnHVyMLgHIjQyuJLIhMsE8zDKkjBCR4MreERHBZdT7EaeUnA/nL07e3MxudooABdR23HlBVeQBq88/2APHNDPdRUKEnxfg0/Ms+L7Y+Lk2ancYXzlTb59/8P5bwdMfvnX2fuz59Wb/GPyl3by7u3524sJwQfgRQHnO3zDLKJUM2bCkCbUsD8N3ySTkYBVEFOAkUiP4QvUiXG5iTPE+Au+J4Mv2fuW9MXwVQJRgkNt0iyVNJVH8WURIyPxHQ7hF3xPBF8SfXl8BcYG7pQMo0RSkR29PPAotD/mjME3igh+wfd08KXiK1welAkRl4IDWoQk7Di+kuNx+HJycl9sfv7xm9cXByiYfDizUG8RsixYyJ7SebDZATnAM4awA2DhAIe7WymjSWiUMZgKkkbM/HlgIZRBdI1UWmQC8aNgwXeqkWABrOzEwDrlvIi5/Ap5kScRiTARQGWmdXQUXwmpcRy+krAXfE8HX4K+wpcqgVEUIS21SLhKI3wcXzbyUio5O7VL6f/nqU4w/vKnulKMJACDjrQiUh69LgqEyLhTXWBif+M/KbBOOS1K9Ie/7fzx1zgyYYRRbUIaSpEcP9UFhmN9HL5E4JdT/YTwjciXx1fBzZHwLAOGMg5xO4pviMNxP5UKiuTvfVE1P/oO9HHrXF5u3v3Hrpokt0fOqBfVc/9yeEMeV8BxXOQrV0jwrSpaM3QONTi+rcGx/++qVfzn3i+7YQ3MqVz1jNPGOsdN5/bL0wmmQ9XKlHMqdJRFCZ12TdHeuYmGYhJ/KCaxDftFOv5+kc6vlv28fkPXbFt64T9XemHH7oqiNvVSk01J1F5nsLFoW1E1n38GBW6rPo5UnvhPbBk3bCjTsAVqVd+krvwJhrvKrcdqqD337OoruPfwX4AulnI=

以上为base64格式, 转为二进制并存到 a.zip文件：

echo eJztmv9v... |base64 -d >a.zip

python 用 print() 二进制输出 a.zip 的内容

b'x\x9c\xed\x9a\xffo\xdb6\x16\xc0\xff\x15C\xc0\x01w8Y%)R$\r\x1cpE\x97\xed\x8a5\xb7\xad\xcd0\x1c\x12C\xa0D\xcaQ,K\xaa\xbe$5\x82\xfc\xef\xf7H\xd9\xb1\xb39\xb56\xdc\xda\x03\x9c_b\x85\xe4#\xdf\x97\x0f\x1fi\xeb\xdd{\xf1\xcatM\x9e\xb6\xde\xec\xdeK\xd6\x9di\x83\xbc\\\x98\xb63:0\xb7\xa6\xec\xbc\x99\x88$\xf37}mW5\xbb\x1e)#\xf4\x00]\x8dQK]\xdd\x95n\x92\xb6Ve\\\xd5\xee\x19>\x02\x9d\xd8\xa7\xbe\xccA\xc0[\xe5E\x91\xb7&\xadJ\xed\xf9\xde\xad*z\xe3\xcd0\x0e\x18\xa10QWu\xaa\x08\xba|e\x8e\x89\x10\x1aH\xfc\xf0\x002\xd0\xde\x99O\x9d[\xae\xe9\xcb\xadp\xd2\xe7\x85\x06\xe90\x80\xd9\xc5\xe4\xaf+\x95\x97\xfe\xe4\\5\x13L&\x04\x11\xeaO0\x9e12C\xe4o\x93\xcb\xef\xde\xbc\x81\xf6\x80\x04h\x0ek\x94\xca\xce\xe1\xbd\xf9q\xdd]W%4t\xeb\xda6l\xa7\x07-L\xd3\xe6\xd0\xb5\x9d\xdf\xb3\xca7*uK\x9bOi\xd1\xb7\xf9\xad\x89\x07ep\xc0\x05\xf6\xbdk\xd5^\x83\x00U\xdc \x93\xa6R*\x8e\x15Q0[UC\xfb\xc7\xde\xf4&\xe8T\xbb\x0cRS\x98f\r\x1d\xce\x95\xb95C!\x13iP[\x1a\x14!cR\xdb\xd9\xa9\xae\x07\xb3\xbdj\xe9mV\x1f\xc6\x1a\x8eY$C#\x12#(\xa7Dq\x1d\x86$\xa4\x8a\xd1(\xa2\x88\xed\x0c\x1aTv^\xec\x8b\xbaq\xeen!\xb2\xcd\xda)\x02\xe16\xa5\x8ek\x00\x02dLy\x9b7U\xb9r\x91\xf7\xea\xa6\xd2}\xda\xe5\xce?\x0e\x87a\xf1$\x95Jr\x9c\x84\x89\xcah\x8a3\x11"\x8a"\x11\xa1,\xa3\x1cS\x1bB\x88V\xa3\xac\xa3\x06;\xa77\x95#D5\x0b\xb0\xe6r\xee{\xcb\xbb\xe1\xf9\xdez\x15\xf4\x887\x01yF5\x18\xd5\xae\xdb\x00dnA\xde{\x15\x806\xb7\xaf\x92\xbc|5\x08\xc0\x92\x109\xf8{W5K\xd3xs\x10X4Uo\x85c\xc0\'\xcb\x17.l\xe5\xb5*Sc\xed\xb3^\xfd\xfe\xdd\xcf\xb7\xf1\x87\xd7\xff\xb9\xfb\xe9\xf5\xeb\xe5\xdd\xf7\xef[\xc2\n\x1d\xfe\x1b\x99_>\x15?\xdc\xbc\xbd;\xbf9\xef\xce\xbf9\xeb\xce/\xbe\xfb\t\xe6v\xc6\x97\xe6\xae\xed\xd6\x85\x99A\xa4\xc2)\xc2S\x8c\xadvK\xb3\x1e\x9c\x83a`\x01\xce*\xe09/\xb3\xca\xfe[\xa5\xaa\x1bPz\xd6\xf3E\xb5X\x80\xde3\x0f\x9eWF\xb5}\xb3\xd5\xf2\xde+\xfbU\\e\xb1%\xa5\xdd\xdb4eU\x9a\xbd\r\x06`\xdb(\xc3VWZu\xce\xf9c\x16\xee\xf2\xae\xf8\xbc\xe3\xcbJ\x1b\x97\x13\xe2\xbclM\x03Kc\x8e%\x0b%\x11(\xc0\x9c\xca0\xf4\xbd\xbaP]V5+\x8b\xcdvK\x01?7&\xb5\xe3!:&5\xb0]\xf4S\xe1\x10\xc9\x90\xdb\xce\x02L\xb6Z$*]\xc2\xda\xff\x84\xbd\xcf\x02\xfc\xf7\xbe\\\x96\x90s\xecN\xd0KkQ\x0e\x89`\xd18\xa3,H\x9e\x03\xc2\xf7\x14\xa4\x07\xf0\x89\xef=n+mt_[\xf7\xe8\x1bU.\xaa\xc7\x87Xu\xd5*O\x1d\xa2\xa9\xa9AS\xb7\xb5\xac\xfb\x07\x7f\xac\x80\xf9\xc2\xb4\x16(\xa3s\xf7\xd9\xb7\x00\xfe\x10\xca\xb6\xd3E\x9eX\xb7]CB\xd4Vd\xfe\x98L6.\x1c\xec\x0f\x1e\x17\xae\xc1&\x05\xe9\x16\xf4\xbd\xdf\x0e\xad\xd7u>\x1b\xc6O\xadi\xfb\xe9\xc6\xe6(`j~\xa0m\x93.\x0e\x90\xed\xd8\xd3&S}\xd1Y4\xc9\x14\xa3)\xe1[\x91a\xf1-\x17+\xd3\xb6\xca\xda\x1b\xd8\xc8\xe6\xa5\xf3g\xb0Qm3\x89\xe3p;lx2\x81[\x85\xa1P\x19\x94\x85S\x81U6\xa5F\x90i\x9221Me\xa6\x18NS\xcd$9(\xdd\x18\xeb\x9e\xb4\xeamvA\xfb#`ow\xc6\xb2\xa3V\x1f\xebG\xef\x0e\xcba\n\x1b\x8dR!\x08B(\xa2\xbb\xde\x8d\xbe\xe7\x90\xf5/\\\x8b5\x16\x0cJ\x9b\xbc>F\xfd\xaf\xf3w\x18\xf0\x90\x8c\xcc\xdf\x80u\n\x9a\xbb\xc866)~>\x85\x83\x96\xf1F$Vm<\xc8x\xb3\xae\xe9\xcd\x93\xec\xaf\xb3\x14\'\x11\xce\x88\xc2Z\x0b=d\xff\xa6s\n\xc2\xd3\xaa~\xb2uP\xc4\xdd\xbe\xeb\x94\xcd\xa2e_\x14v+\x1f\x1c)p\x88\xe5\xef;=\x1e\xfc\x1d,:\t\x9e\xf0m\xb7R\xb2\x8bX]\xb5\xdd\xa21\xed\xc7\xc2jl\x1a`6PZ7\xd6C[\x91\xe9\xe6\xe3\xd0\xd8\xba\xb2\x19\xc5c4$\xff\xc3\xc0\xc3\xc6(m\xea\xf9m\xa4Y@\x1f\xe3\x9c\x80\xb1\n\xa5\x86F,\x830\xd3m\x9cur0\xb8\x07"42\xb8\x92\xc8\x84\xcb\x04\xf30\xca\x920BG\x83+xDG\x05\x97S\xecF\x9eRp?\x9c\xbd;{s1\xb9\xda(\x00\x17Q\xdbq\xe5\x05W\x90\x06\xaf<\xff`\x0f\x1c\xd0\xcfu\x15\n\x12|_\x83O\xcc\xb3\xe2\xfbc\xe2\xe4\xd9\xa9\xdca|\xe5M\xbe}\xff\xc3\xf9o\x07L~\xf9\xd7\xd9\xfb\xb3\xe7\xd5\x9b\xfcc\xf2\x97v\xf2\xee\xed\xf9\xdb\x8b\t\xc1\x07\xe0E\x01\xe7;|\xc3,\xa2T3f\xc2\x90&\xd4\xb0?\r\xdf$\x93\x91\x80U\x10S\x80\x91H\x8f\xe1\x0b\xd4\x89q\xb9\x893\xc4\xf8\x0b\xbe\'\x83/\xd9\xfb\x96\xf4\xc5\xf0U\x02Q\x82Cm\xd2,\x954\x95G\xf1e\x11##\xf1\x1d\x0e\xe1\x17|O\x04_\x12}y|\x05\xc6\x06\xee\x94\x0c\xa3DR\x91\x1d\xbd<\xf0(\xb4?\xe6\x8c\xc17\x8a\x08~\xc1\xf7t\xf0\xa5\xe2+\\\x1e\x94\t\x11\x97\x82\x03Z\x84$\xec8\xbe\x92\xe3q\xf8rrr_l~\xfe\xf1\x9b\xd7\x17\x07(\x98|8\xb3Po\x11\xb2,X\xc8\x9e\xd2y\xb0\xd9\x019\xc03\x86\xb0\x03`\xe1\x00\x87\xbb[)\xa3Ih\x941\x98\n\x92F\xcc\xfcy`!\x94At\x8dTZd\x02\xf1\xa3`\xc1w\xaa\x91`\x01\xac\xec\xc4\xc0:\xe5\xbc\x88\xb9\xfc\ny\x91\'\x11\x890\x11@e\xa6ut\x14_\t\xa9q\x1c\xbe\x92\xb0\x17|O\x07_\x82\xbe\xc2\x97*\x81Q\x14!-\xb5H\xb8J#|\x1c_6\xf2R*9;\xb5K\xe9\xff\xe7\xa9N0\xfe\xf2\xa7\xbaR\x8c$\x00\x83\x8e\xb4"R\x1e\xbd.\n\x84\xc8\xb8S]`b\x7f\xe3?)\xb0N9-J\xf4\x87\xbf\xed\xfc\xf1\xd782a\x84QmB\x1aJ\x91\x1c?\xd5\x05\x86c}\x1c\xbeD\xe0\x97S\xfd\x84\xf0\x8d\xc8\x97\xc7W\xc1\xcd\x91\xf0,\x03\x862\x0eq;\x8ao\x88\xc3q?\x95\n\x8a\xe4\xef}Q5?\xfa\x0e\xf4q\xeb\\^n\xde\xfd\xc7\xae\x9a$\xb7G\xce\xa8\x17\xd5s\xffrxC\x1eW\xc0q\\\xe4+WH\xf0\xad*Z3t\x0e58\xbe\xad\xc1\xb1\xff\xef\xaaU\xfc\xe7\xde/\xbba\r\xcc\xa9\\\xf5\x8c\xd3\xc6:\xc7M\xe7\xf6\xcb\xd3\t\xa6C\xd5\xca\x94s*t\x94E\t\x9dvM\xd1\xde\xb9\x89\x86b\x12\x7f(&\xb1\r\xfbE:\xfe~\x91\xce\xaf\x96\xfd\xbc~C\xd7l[z\xe1?Wza\xc7\xee\x8a\xa26\xf5R\x93MI\xd4^g\xb0\xb1h[Q5\x9f\x7f\x06\x05n\xab>\x8eT\x9e\xf8Ol\x197l(\xd3\xb0\x05jU\xdf\xa4\xae\xfc\t\x86\xbb\xca\xad\xc7j\xa8=\xf7\xec\xea+\xb8\xf7\xf0_\x80.\x96r'

以上为zlib 压缩格式， 解压代码：

from zlib import *
data = open('/mnt/d/a.zip', 'rb').read()
print(data) # 上面的输出
data = decompress(data)
print(data) # 下面的输出

还原解压后为json格式：

{"_metrics":{"bytes.ingested.event":8695,"bytes.stored.event":9960},"breakdowns":{"span_ops":{"ops.db":{"unit":"millisecond","value":11.524},"total.time":{"unit":"millisecond","value":24.91}}},"contexts":{"runtime":{"build":"3.11.8 (main, Mar 12 2024, 11:52:02) [GCC 12.2.0]","name":"CPython","type":"runtime","version":"3.11.8"},"trace":{"exclusive_time":1.781,"hash":"4a7e0ecc99a71a2a","op":"queue.task.celery","span_id":"a0e6d2029e060eec","status":"ok","trace_id":"e715693e8be84742a7d33234a5466405","type":"trace"}},"culprit":"sentry.tasks.send_ping","environment":"production","event_id":"bc9a971b3baf4c1f830406860ff4714d","extra":{"celery-job":{"args":[],"kwargs":{},"task_name":"sentry.tasks.send_ping"},"sys.argv":["/.venv/bin/sentry","run","worker"]},"grouping_config":{"enhancements":"KLUv_SAYwQAAkwKRs25ld3N0eWxlOjIwMjMtMDEtMTGQ","id":"newstyle:2023-01-11"},"key_id":"1","level":"info","location":"sentry.tasks.send_ping","logger":"","measurements":{"num_of_spans":{"unit":"none","value":12.0}},"metadata":{"location":"sentry.tasks.send_ping","title":"sentry.tasks.send_ping"},"nodestore_insert":1719539280.174933,"platform":"python","project":1,"received":1719539280.130937,"release":"backend@24.5.1+unknown","sdk":{"integrations":["argv","atexit","celery","dedupe","django","django_atomic","excepthook","logging","modules","redis","rust_info","stdlib","threading"],"name":"sentry.python.django","packages":[{"name":"pypi:sentry-sdk","version":"2.2.1"}],"version":"2.2.1"},"span_grouping_config":{"id":"default:2022-10-27"},"spans":[{"data":{"messaging.destination.name":"default","messaging.message.id":"503ae0f3-81af-4e82-bc58-c9fa51ccd592","messaging.message.retry.count":0,"messaging.system":"amqp","thread.id":"140234488200064","thread.name":"MainThread"},"description":"sentry.tasks.send_ping","exclusive_time":3.732,"hash":"4a7e0ecc99a71a2a","op":"queue.process","parent_span_id":"a0e6d2029e060eec","same_process_as_parent":true,"span_id":"adfc1b61f2a1dd8d","start_timestamp":1719539280.067933,"tags":null,"timestamp":1719539280.081319,"trace_id":"e715693e8be84742a7d33234a5466405"},{"data":{"db.name":"sentry","db.system":"postgresql","server.address":"sentry-sentry-postgresql","server.port":"5432","thread.id":"140234488200064","thread.name":"MainThread"},"description":"connect","exclusive_time":5.4,"hash":"b640a0ce465fa2a4","op":"db","parent_span_id":"adfc1b61f2a1dd8d","same_process_as_parent":true,"span_id":"929b79b1736fb360","start_timestamp":1719539280.068764,"tags":null,"timestamp":1719539280.074164,"trace_id":"e715693e8be84742a7d33234a5466405"},{"data":{"db.name":"sentry","db.system":"postgresql","server.address":"sentry-sentry-postgresql","server.port":"5432","thread.id":"140234488200064","thread.name":"MainThread"},"description":"SELECT \\"sentry_option\\".\\"id\\", \\"sentry_option\\".\\"key\\", \\"sentry_option\\".\\"last_updated\\", \\"sentry_option\\".\\"last_updated_by\\", \\"sentry_option\\".\\"value\\" FROM \\"sentry_option\\" WHERE \\"sentry_option\\".\\"key\\" = %s LIMIT 21","exclusive_time":0.774,"hash":"3f644d55e334b4e5","op":"db","parent_span_id":"adfc1b61f2a1dd8d","same_process_as_parent":true,"span_id":"bf968e3305a4a58c","start_timestamp":1719539280.074283,"tags":null,"timestamp":1719539280.075057,"trace_id":"e715693e8be84742a7d33234a5466405"},{"data":{"db.name":"sentry","db.system":"postgresql","server.address":"sentry-sentry-postgresql","server.port":"5432","thread.id":"140234488200064","thread.name":"MainThread"},"description":"SELECT \\"sentry_option\\".\\"id\\", \\"sentry_option\\".\\"key\\", \\"sentry_option\\".\\"last_updated\\", \\"sentry_option\\".\\"last_updated_by\\", \\"sentry_option\\".\\"value\\" FROM \\"sentry_option\\" WHERE \\"sentry_option\\".\\"key\\" = %s LIMIT 21","exclusive_time":0.281,"hash":"3f644d55e334b4e5","op":"db","parent_span_id":"adfc1b61f2a1dd8d","same_process_as_parent":true,"span_id":"a804213decfc94c9","start_timestamp":1719539280.075652,"tags":null,"timestamp":1719539280.075933,"trace_id":"e715693e8be84742a7d33234a5466405"},{"data":{"db.name":"sentry","db.system":"postgresql","server.address":"sentry-sentry-postgresql","server.port":"5432","thread.id":"140234488200064","thread.name":"MainThread"},"description":"SELECT \\"sentry_option\\".\\"id\\", \\"sentry_option\\".\\"key\\", \\"sentry_option\\".\\"last_updated\\", \\"sentry_option\\".\\"last_updated_by\\", \\"sentry_option\\".\\"value\\" FROM \\"sentry_option\\" WHERE \\"sentry_option\\".\\"key\\" = %s LIMIT 21","exclusive_time":0.226,"hash":"3f644d55e334b4e5","op":"db","parent_span_id":"adfc1b61f2a1dd8d","same_process_as_parent":true,"span_id":"811e202510b948f0","start_timestamp":1719539280.076395,"tags":null,"timestamp":1719539280.076621,"trace_id":"e715693e8be84742a7d33234a5466405"},{"data":{"db.name":"sentry","db.system":"postgresql","server.address":"sentry-sentry-postgresql","server.port":"5432","thread.id":"140234488200064","thread.name":"MainThread"},"description":"SELECT \\"sentry_option\\".\\"id\\", \\"sentry_option\\".\\"key\\", \\"sentry_option\\".\\"last_updated\\", \\"sentry_option\\".\\"last_updated_by\\", \\"sentry_option\\".\\"value\\" FROM \\"sentry_option\\" WHERE \\"sentry_option\\".\\"key\\" = %s LIMIT 21","exclusive_time":0.248,"hash":"3f644d55e334b4e5","op":"db","parent_span_id":"adfc1b61f2a1dd8d","same_process_as_parent":true,"span_id":"bae30798771522b5","start_timestamp":1719539280.076971,"tags":null,"timestamp":1719539280.077219,"trace_id":"e715693e8be84742a7d33234a5466405"},{"data":{"db.name":"sentry","db.system":"postgresql","server.address":"sentry-sentry-postgresql","server.port":"5432","thread.id":"140234488200064","thread.name":"MainThread"},"description":"UPDATE \\"sentry_option\\" SET \\"value\\" = %s, \\"last_updated\\" = %s, \\"last_updated_by\\" = %s WHERE \\"sentry_option\\".\\"key\\" = %s","exclusive_time":1.134,"hash":"54b3eaee1482c65e","op":"db","parent_span_id":"adfc1b61f2a1dd8d","same_process_as_parent":true,"span_id":"b00f332e9ad8f807","start_timestamp":1719539280.077641,"tags":null,"timestamp":1719539280.078775,"trace_id":"e715693e8be84742a7d33234a5466405"},{"data":{"db.name":"sentry","db.system":"postgresql","server.address":"sentry-sentry-postgresql","server.port":"5432","thread.id":"140234488200064","thread.name":"MainThread"},"description":"SELECT \\"sentry_option\\".\\"id\\", \\"sentry_option\\".\\"key\\", \\"sentry_option\\".\\"last_updated\\", \\"sentry_option\\".\\"last_updated_by\\", \\"sentry_option\\".\\"value\\" FROM \\"sentry_option\\" WHERE \\"sentry_option\\".\\"key\\" = %s LIMIT 21","exclusive_time":0.179,"hash":"3f644d55e334b4e5","op":"db","parent_span_id":"adfc1b61f2a1dd8d","same_process_as_parent":true,"span_id":"b7b626128641fdd6","start_timestamp":1719539280.079076,"tags":null,"timestamp":1719539280.079255,"trace_id":"e715693e8be84742a7d33234a5466405"},{"data":{"db.name":"sentry","db.system":"postgresql","server.address":"sentry-sentry-postgresql","server.port":"5432","thread.id":"140234488200064","thread.name":"MainThread"},"description":"SELECT \\"sentry_option\\".\\"id\\", \\"sentry_option\\".\\"key\\", \\"sentry_option\\".\\"last_updated\\", \\"sentry_option\\".\\"last_updated_by\\", \\"sentry_option\\".\\"value\\" FROM \\"sentry_option\\" WHERE \\"sentry_option\\".\\"key\\" = %s LIMIT 21","exclusive_time":0.201,"hash":"3f644d55e334b4e5","op":"db","parent_span_id":"adfc1b61f2a1dd8d","same_process_as_parent":true,"span_id":"810660d9d8b7ac61","start_timestamp":1719539280.07955,"tags":null,"timestamp":1719539280.079751,"trace_id":"e715693e8be84742a7d33234a5466405"},{"data":{"db.name":"sentry","db.system":"postgresql","server.address":"sentry-sentry-postgresql","server.port":"5432","thread.id":"140234488200064","thread.name":"MainThread"},"description":"UPDATE \\"sentry_option\\" SET \\"value\\" = %s, \\"last_updated\\" = %s, \\"last_updated_by\\" = %s WHERE \\"sentry_option\\".\\"key\\" = %s","exclusive_time":1.211,"hash":"54b3eaee1482c65e","op":"db","parent_span_id":"adfc1b61f2a1dd8d","same_process_as_parent":true,"span_id":"aa52b953d6da2995","start_timestamp":1719539280.080021,"tags":null,"timestamp":1719539280.081232,"trace_id":"e715693e8be84742a7d33234a5466405"},{"data":{"db.name":"sentry","db.system":"postgresql","server.address":"sentry-sentry-postgresql","server.port":"5432","thread.id":"140234488200064","thread.name":"MainThread"},"description":"SELECT \\"sentry_option\\".\\"id\\", \\"sentry_option\\".\\"key\\", \\"sentry_option\\".\\"last_updated\\", \\"sentry_option\\".\\"last_updated_by\\", \\"sentry_option\\".\\"value\\" FROM \\"sentry_option\\" WHERE \\"sentry_option\\".\\"key\\" = %s LIMIT 21","exclusive_time":0.908,"hash":"3f644d55e334b4e5","op":"db","parent_span_id":"a0e6d2029e060eec","same_process_as_parent":true,"span_id":"9b5254de34398bd6","start_timestamp":1719539280.081907,"tags":null,"timestamp":1719539280.082815,"trace_id":"e715693e8be84742a7d33234a5466405"},{"data":{"db.name":"sentry","db.system":"postgresql","server.address":"sentry-sentry-postgresql","server.port":"5432","thread.id":"140234488200064","thread.name":"MainThread"},"description":"SELECT \\"sentry_option\\".\\"id\\", \\"sentry_option\\".\\"key\\", \\"sentry_option\\".\\"last_updated\\", \\"sentry_option\\".\\"last_updated_by\\", \\"sentry_option\\".\\"value\\" FROM \\"sentry_option\\" WHERE \\"sentry_option\\".\\"key\\" = %s LIMIT 21","exclusive_time":0.962,"hash":"3f644d55e334b4e5","op":"db","parent_span_id":"a0e6d2029e060eec","same_process_as_parent":true,"span_id":"a25527ff4a5f7023","start_timestamp":1719539280.083132,"tags":null,"timestamp":1719539280.084094,"trace_id":"e715693e8be84742a7d33234a5466405"}],"start_timestamp":1719539280.0677,"tags":[["celery_task_id","503ae0f3-81af-4e82-bc58-c9fa51ccd592"],["spans_over_limit","False"],["status","ok"],["task_name","sentry.tasks.send_ping"],["transaction_id",null],["server_name","sentry-worker-7748d6f6b4-trlsw"],["level","info"],["environment","production"],["transaction","sentry.tasks.send_ping"],["sentry:release","backend@24.5.1+unknown"],["runtime","CPython 3.11.8"],["runtime.name","CPython"]],"timestamp":1719539280.084737,"title":"sentry.tasks.send_ping","transaction":"sentry.tasks.send_ping","transaction_info":{"source":"task"},"type":"transaction","version":"7"}

原json数据 9551字节
zlib 压缩后 1814字节， 19% 压缩率
base64转码后 2452字节，130% 膨胀率， 最终压缩效果 25%

$ cat a.zip |base64 |wc -c
2452