Detecting Hotspots With Active Session History In YugabyteDB

In a previous post, I explained that the default PgBench workload is not scalable, with all sessions updating the same row, and how to solve it:

  
    
      
      
        
      
    
  
  
    
      Avoiding hotspots in pgbench on PostgreSQL or YugabyteDB
      Franck Pachot for YugabyteDB ・ Mar 10 '22
      
        #postgres
        #yugabytedb
        #sql
        #database
      
    
  

This table row is a hotspot in a distributed database. In the following article, I demonstrate how to detect hotspots in YugabyteDB using Active Session History.
I launch a single-node YugabyteDB...