Hello,
I recently upgraded from pgsql 12 to pgsql 17. It's a Percona TDE enabled database. However, after the upgrade the query planning time has shot up by 10x when I check explain analyze output.
The difference in planning time is visible here. The first case is pgsql 17 with TDE. The second case pgsql 12 with TDE.
s14=> explain analyze select invoicenum from ltlinvoice where pseq=1400000224216382;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Index Scan using ltlinvoice_pseq on ltlinvoice (cost=0.43..10.10 rows=9 width=12) (actual time=0.040..0.040 rows=0 loops=1)
Index Cond: (pseq = '1400000224216382'::bigint)
Planning Time: 158.199 ms
Execution Time: 0.051 ms
s14=> explain analyze select invoicenum from ltlinvoice where pseq=1400000224216382;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Index Scan using ltlinvoice_pseq on ltlinvoice (cost=0.43..10.10 rows=9 width=12) (actual time=0.023..0.023 rows=0 loops=1)
Index Cond: (pseq = '1400000224216382'::bigint)
Planning Time: 0.195 ms
Execution Time: 0.046 ms
Any pointers about this would be helpful.
Regards,
Ashish
