Sample Header Ad - 728x90

how to make the execution plan as same with the actual query in PostgreSQL 14

1 vote
0 answers
38 views
When I use the execution plan in PostgreSQL 14, I found the execution plan much faster than the actual query, this is how I generate the execution plan: explain (analyze true, timing true) long sql... the execute plan takes 16s, and the actual query takes 23s. and the timing in execute plan is 16s. is it possible to make the explain time keep the same with actual sql(if different means that actual run are diff with the explain, it may mistake the user)? maybe we should lock the explain.
Asked by Dolphin (939 rep)
May 10, 2025, 05:41 AM
Last activity: May 10, 2025, 06:57 AM