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
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: (pgbench_branches.bid = 59)
No additional resources available.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →