Understanding the PostgreSQL Shell vs psycopg2: A Deep Dive into Query Execution Discrepancies Due to Concurrency and Deadlocks