Check out our free resources and eBooks like: "Effective Indexing in Postgres"

T84: EXPLAIN plan for slow query

Work in Progress

This documentation page is currently being worked on. We apologize for the page being incomplete or not available yet.

Category: Statement Events
Urgency: low

Example Postgres Log Output:

LOG: duration: 1681.452 ms  plan:
  Query Text: UPDATE pgbench_branches SET bbalance = bbalance + 2656 WHERE bid = 59;
  Update on public.pgbench_branches  (cost=0.27..8.29 rows=1 width=370) (actual rows=0 loops=1)
    Buffers: shared hit=7
    ->  Index Scan using pgbench_branches_pkey on public.pgbench_branches  (cost=0.27..8.29 rows=1 width=370) (actual rows=1 loops=1)
          Output: bid, (bbalance + 2656), filler, ctid
          Index Cond: ( = 59)



Recommended Action:


Learn More:

No additional resources available.

Download Free eBook: The Top 6 Postgres Log Events
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →