VPIP will only be 100% if you also filter for being in the SB position. tourney_hand_summary.str_actors_p LIKE '9%' only filters to hands where the SB was the first player to act, but it will include all players in those hands.
That looks like you lost connection to the download - if you reboot your computer and run PT4 again does the PostgreSQL installer run again? If not, you can download the latest PostgreSQL 12 version (12.18 currently) from this page and run that to install PostgreSQL manually. We recommend using our ...
Please enable logging (Configure > Options) and restart PT4. Reproduce the problem and then create a Support Bundle and attach it to a Support Ticket so that we can check your log and see what is going on. I think the most likely cause might be having an incorrect hand history folder configured. It ...
Most, if not all, "By Tournament" reports will include the finish position by default; for example the Overview report grouped By Tournament, or Statistics > Summary > Group by Tournament. If you don't see it in a tournament report you can right click > Configure Report and add any stats y...
I may have been a little hasty earlier, although I still think there isn't a straightforward way to do this. You may be correct that the hand strength information would be stored for for all players in that case; however comparing hero's hand strength against that of all other players in the hand, a...
Unfortunately cashout hands are not currently possible to support accurately due to the lack of rake in iPoker hands. I understand that they are adding rake to their hand histories and when that rolls out we will update PT4 to support these hands. If you wish to be notified when that is available pl...