From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Display of buffers for planning time show nothing for second run |
Date: | 2020-04-14 08:17:35 |
Message-ID: | CAFj8pRApToC6vGJHNC5OqVRQcH0BF4YbgqER-n4X2zi3R3bW9Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi
I am testing some features from Postgres 13, and I am not sure if I
understand well to behave of EXPLAIN(ANALYZE, BUFFERS)
When I run following statement first time in session I get
postgres=# EXPLAIN (BUFFERS, ANALYZE) SELECT * FROM obce WHERE okres_id =
'CZ0201';
┌──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ QUERY PLAN
│
╞══════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════╡
│ Index Scan using obce_okres_id_idx on obce (cost=0.28..14.49 rows=114
width=41) (actual time=0.072..0.168 rows=114 loops=1) │
│ Index Cond: ((okres_id)::text = 'CZ0201'::text)
│
│ Buffers: shared hit=4
│
│ Planning Time: 0.539 ms
│
│ Buffers: shared hit=13
│
│ Execution Time: 0.287 ms
│
└──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
(6 rows)
And I see share hit 13 in planning time.
For second run I get
postgres=# EXPLAIN (BUFFERS, ANALYZE) SELECT * FROM obce WHERE okres_id =
'CZ0201';
┌──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ QUERY PLAN
│
╞══════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════╡
│ Index Scan using obce_okres_id_idx on obce (cost=0.28..14.49 rows=114
width=41) (actual time=0.044..0.101 rows=114 loops=1) │
│ Index Cond: ((okres_id)::text = 'CZ0201'::text)
│
│ Buffers: shared hit=4
│
│ Planning Time: 0.159 ms
│
│ Execution Time: 0.155 ms
│
└──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
(5 rows)
Now, there is not any touch in planning time. Does it mean so this all
these data are cached somewhere in session memory?
Regards
Pavel
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2020-04-14 08:27:41 | Re: Display of buffers for planning time show nothing for second run |
Previous Message | Amit Langote | 2020-04-14 07:39:46 | Re: index paths and enable_indexscan |