Why explain analyze and execution query time is different

Question

I have a query with two tables join based on condition b.customer_id = a.customer_id, there is index(btree) on both table on both columns customer_id.

When I ran explain analyze it says 15 ms:

But when I execute query it took 26 secs:

Successfully run. Total query runtime: 26 secs 168 msec.
30038 rows affected.

Laurenz Albe · Accepted Answer · 2021-07-01 14:39:25Z

2

That is because you are using pgAdmin or a similar client tool that takes a long time to render 30038 rows.

answered Jul 1, 2021 at 14:39

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

MAK Over a year ago

Then which time should be noted as actual query execution time? I got confused between query execution time in PgAdmin and Explain Analyze Execution time.

Laurenz Albe Over a year ago

That depends on your use case. If your actual use case is to view 30000 with pgAdmin, take the 26 seconds. The execution time on the server cannot contain the network latency or the time it takes the client to process the result.

Collectives™ on Stack Overflow

Why explain analyze and execution query time is different

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related