Стоп, что?! Кусок реального плана:

Question

Стоп, что?! Кусок реального плана:

-> Bitmap Heap Scan on sc_2019_hj_1_d c_2 (cost=1720.81..454218.68 rows=19720 width=30) (actual time=42.138..151.655 rows=8901 loops=1)
Recheck Cond: ((((COALESCE((fid)::bigint, fk) % '12'::bigint) = ANY ('{1,1}'::bigint[])) AND (qid = ANY ('{67,25,84,53}'::integer[])) AND (s_date >= '2019-05-23 00:00:00'::timestamp without time zone)) OR ((slml = 5) AND o AND ((COALESCE((fid)::bigint, fk) % '12'::bigint) = ANY ('{1,1}'::bigint[]))))
Filter: ((fid IS NOT NULL) AND (nav_id IS NOT NULL) AND (slml = 5) AND (((qid = ANY ('{67,25,84,53}'::integer[])) AND (NOT (alternatives: SubPlan 2 or hashed SubPlan 3)) AND (s_date >= '2019-05-23 00:00:00'::timestamp without time zone) AND (NOT o)) OR (o AND (qid = 564) AND (NOT (alternatives: SubPlan 4 or hashed SubPlan 5)) AND (s_date >= '2018-06-06 00:00:00'::timestamp without time zone))))
Rows Removed by Filter: 28292
Heap Blocks: exact=23615
Buffers: shared hit=41434
-> BitmapOr (cost=1720.81..1720.81 rows=45983 width=0) (actual time=9.525..9.525 rows=0 loops=1)
Buffers: shared hit=1373
-> Bitmap Index Scan on sc_2019_hj_1_d_expr_qid_s_date_idx1 (cost=0.00..1707.86 rows=45983 width=0) (actual time=9.464..9.464 rows=46519 loops=1)
Index Cond: (((COALESCE((fid)::bigint, fk) % '12'::bigint) = ANY ('{1,1}'::bigint[])) AND (qid = ANY ('{67,25,84,53}'::integer[])) AND (s_date >= '2019-05-23 00:00:00'::timestamp without time zone))
Buffers: shared hit=1368
-> Bitmap Index Scan on sc_2019_hj_1_d_slml_o_expr_idx1 (cost=0.00..3.09 rows=1 width=0) (actual time=0.050..0.050 rows=0 loops=1)
Index Cond: ((slml = 5) AND (o = true) AND ((COALESCE((fid)::bigint, fk) % '12'::bigint) = ANY ('{1,1}'::bigint[])))
Buffers: shared hit=5
Я вот ясно вижу actual rows в "Bitmap Index Scan on sc_2019_hj_1_d_expr_qid_s_date_idx1 (cost=0.00..1707.86 rows=45983 width=0) (actual time=9.464..9.464 rows=46519 loops=1)", а Вы? ;)

#backend #devops #pgsql #programming #russian

0

12.05.2020

1 ответов

24 просмотра

Denis Smirnov · Accepted Answer

Denis Smirnov

А, да, я нагнал - все сказанное справедливо только для BitmapOr и bitmapAnd узлов плана.

0

12.05.2020

172 похожих чатов

Стоп, что?! Кусок реального плана:

1 ответов

Похожие вопросы