[GENERAL] Question about detecting database changes

hanks very much! -- --Dave Peticolas

[GENERAL] Analyzing performance regression from 9.2 to 9.6

Hi, I am trying to analyze a performance regression from 9.2.21 to 9.6.3. The query and execution plans are below with 9.6.3 first. If the query looks a bit odd, it was generated by an ORM and the names have been modified. The slight difference in row counts is because they are from snapshots taken

Re: [GENERAL] Analyzing performance regression from 9.2 to 9.6

(product_id IS NOT NULL) -> Hash (cost=6.87..6.87 rows=387 width=4) (actual time=0.195..0.195 rows=387 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 14kB -> Seq Scan on kbdata_skill_aspects (cost=0