powa-team / powa-web

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

Add join clause on srvid when joining with powa_statements. #117

Closed anayrat closed 3 years ago

anayrat commented 3 years ago

Several queries are built from powa_getdata_detailed_db by passing srvid. Later we join with powa_statements but join on srvid was missing which often lead to a seqscan on powa_statements.

Thanks to join on srvid we can use powa_statements PK.

rjuju commented 3 years ago

Nice catch, this should bring yet more speedup!

Thanks a lot @anayrat !