more work on analysis, example w/postgres