Symptom
Information on the EXPLAIN PERFORMANCE at a site is as follows: As shown in the red boxes, two performance bottlenecks are scan operations in a table.
Optimization Analysis
After further analysis, we found that the filter condition acct_id ='A012709548':: bpchar exists in the two tables.
Try to add the partial clustering key in the acct_id column of the two tables, and run the VACUUM FULL statement to make the local clustering take effect. The table performance is improved.