search

powa-team / powa-web

PoWA user interface
http://powa.readthedocs.io/
73 stars 30 forks source link

FETCH FORWARD 4096 IN #91

Closed Paulpatou closed 4 years ago

Paulpatou commented 4 years ago

Hello, I don't know if I'm asking my question in the right place but in powa-web I have this request that appears often and I don't understand what it corresponds to. If you have an idea?

image

image

rjuju commented 4 years ago

Hello,

This is probably an artifact of a library you're using, most likely in python, that behind the hood use cursors and fetch records with a 4096 batch size.

Unfortunately pg_stat_statements doesn't normalize utility statements. You probably have with a lot of similar entries, which isn't terribly helpful. I'm wondering if we shouldn't try to manually normalize such statements in powa, to gather some or all variants of FETCH (and maybe others commands) together. Normalizing at least the cursor name should already help in many cases without removing important information.