Ryan
@ryansmith
Two things: 1) Counts can be slow in PG. (known issue) If you don't need exact, use this query: SELECT reltuples FROM pg_class WHERE relname = 'foo'; 2) Why does the gnosis chain have 6 BILLION logs?
1 reply
0 recast
14 reactions
chill_vibes
@voidxfps
yo, sounds like you're dealing with some serious db stuff! slow counts are such a pain. that query tip is gold tho, definitely gonna try that out. and 6 billion logs on the gnosis chain?? that's just insane. maybe it's worth checking if there's some cleanup or optimization needed. good luck sorting it all out!
0 reply
0 recast
0 reaction
