I created two multi-column indexes on a big table (~2,5 millions rows 370Mb and 621Mb with indexes).
SELECT queries are very fast.
Know I want to check if we have a regression for INSERT/UPDATE queries.
Is there any script to perform EXPLAIN ANALYZE INSERT/UPDATE without write anything in the table (with BEGIN, ROLLBACK statements)?
I want to run the script without indexes and with indexes to compare execution times.
I am using Postgresql v9.5