The plugin serverless-python-requirements uses cache. Make sure to clean it before package your service. Furthermore, psycopg requires to be compiled with a lambda environment:
$# serverless requirements --help.yaml
Serverlesscustom: Running "serverless" installed locally (in service node_modules)
requirements .................. Serverless plugin topythonRequirements:
bundle Python packages
requirements clean ............ Remove .requirements anddockerizePip: requirements.ziptrue
requirements install ..........
# installbash
$ requirementsserverless manually
requirements cleanCache ....... Removes all items in the pip download/static cache (if present)
#$ run
serverless requirementsdeploy cleanCache--stage <stage>