Sergey Burladyan <eshkin...@gmail.com> writes: > Hot standby: ... > ' -> Index Only Scan using items_user_id_idx on public.items > (cost=0.00..24165743.48 rows=200673143 width=8) (actual > time=56064.499..56064.499 rows=1 loops=1)' > ' Output: public.items.user_id' > ' Index Cond: (public.items.user_id IS NOT NULL)' > ' Heap Fetches: 8256426' > ' Buffers: shared hit=3694164 read=6591224 written=121652' > 'Total runtime: 56064.571 ms' > > Master: > ... > ' -> Index Only Scan using items_user_id_idx on public.items > (cost=0.00..24166856.02 rows=200680528 width=8) (actual time=202.756..202.756 > rows=1 loops=1)' > ' Output: public.items.user_id' > ' Index Cond: (public.items.user_id IS NOT NULL)' > ' Heap Fetches: 0' > ' Buffers: shared hit=153577 read=1' > 'Total runtime: 202.786 ms'
Looks like visibility map is not replicated into slave somehow? If it matters, Master was restarted yesterday, Standby was not. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
