BUG #15301: Scanning all partition when more than 100 items in "whereid in ()" clause

Поиск
Список
Период
Сортировка
От	PG Bug reporting form
Тема	BUG #15301: Scanning all partition when more than 100 items in "whereid in ()" clause
Дата	27 июля 2018 г. 02:42:35
Msg-id	153263775564.1395.12795650852001905509@wrigleys.postgresql.org обсуждение исходный текст
Ответы	Re: BUG #15301: Scanning all partition when more than 100 items in "where id in ()" clause (Tom Lane <tgl@sss.pgh.pa.us>)
Список	pgsql-bugs
Дерево обсуждения
The following bug has been logged on the website:

Bug reference:      15301
Logged by:          soni harriz
Email address:      diptatapa@gmail.com
PostgreSQL version: 9.6.9
Operating system:   Red Hat Enterprise Linux Server release 7.5
Description:

explain analyze select * from attachment where entity_id in

(189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,

190900401,190900785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,

190915471,190915715,190916292,190917756,190921775,190924593,190924867,190937455,190939665,190941432,190946157,190946578,190947077,

190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,

191078249,191078327,191079035,191080060,191082010,191082170,191082475,191088364,191090035,191094751,191095227,191095960,191096543,

191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,191128562,191128563,
191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687);

QUERY PLAN


-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------
 Append  (cost=0.00..3062.89 rows=24943 width=134) (actual
time=0.101..6.938 rows=258 loops=1)
   ->  Seq Scan on attachment  (cost=0.00..0.00 rows=1 width=880) (actual
time=0.005..0.005 rows=0 loops=1)
         Filter: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900785,

190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,1909374

55,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,1910

34716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,191082170,1

91082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,19112856
2,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687}'::integer[]))
   ->  Index Scan using attachment_entity_id_180m_195m_by_entity_id on
attachment_entity_id_180m_195m  (cost=0.57..3062.89 rows=24942 width=134)
(actual time=0.095..6.900 rows=258 loops=1
)
         Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900

785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,190

937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1910821

70,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,1911

28562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687}'::integer[]))
 Planning time: 12.969 ms
 Execution time: 7.062 ms
(7 rows)

Adding only one more item in the "where id in ()" clause, with total 101
items, query will do index scan on all partitions

explain analyze select * from attachment where entity_id in

(189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,

190900401,190900785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,

190915471,190915715,190916292,190917756,190921775,190924593,190924867,190937455,190939665,190941432,190946157,190946578,190947077,

190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,

191078249,191078327,191079035,191080060,191082010,191082170,191082475,191088364,191090035,191094751,191095227,191095960,191096543,

191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,191128562,191128563,
191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685);

QUERY PLAN


-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------------------------
 Append  (cost=0.00..26203.63 rows=221704 width=131) (actual
time=1.412..50.966 rows=258 loops=1)
   ->  Seq Scan on attachment  (cost=0.00..0.00 rows=1 width=880) (actual
time=0.002..0.002 rows=0 loops=1)
         Filter: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900785,

190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,1909374

55,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,1910

34716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,191082170,1

91082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,19112856

2,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Index Scan using attachment_entity_id_null_by_entity_id on
attachment_entity_id_null  (cost=0.42..443.69 rows=1 width=172) (actual
time=0.089..0.089 rows=0 loops=1)
         Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900

785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,190

937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1910821

70,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,1911

28562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Bitmap Heap Scan on attachment_entity_id_less_45m
(cost=277.83..599.33 rows=143 width=132) (actual time=0.070..0.070 rows=0
loops=1)
         Recheck Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,1909

00785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,1

90937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,19102710

3,191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,19108

2170,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,19

1128562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
         ->  Bitmap Index Scan on
attachment_entity_id_less_45m_by_entity_id  (cost=0.00..277.79 rows=143
width=0) (actual time=0.070..0.070 rows=0 loops=1)
               Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,

190900785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,1909248

67,190937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,1910

27103,191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1

91082170,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,19112850

1,191128562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Index Scan using attachment_entity_id_45m_60m_by_entity_id on
attachment_entity_id_45m_60m  (cost=0.57..1885.49 rows=20391 width=129)
(actual time=0.121..0.121 rows=0 loops=1)
         Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900

785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,190

937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1910821

70,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,1911

28562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Index Scan using attachment_entity_id_60m_75m_by_entity_id on
attachment_entity_id_60m_75m  (cost=0.57..1704.44 rows=24498 width=130)
(actual time=0.126..0.126 rows=0 loops=1)
         Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900

785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,190

937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1910821

70,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,1911

28562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Index Scan using attachment_entity_id_75m_90m_by_entity_id on
attachment_entity_id_75m_90m  (cost=0.57..1570.17 rows=13695 width=131)
(actual time=0.126..0.126 rows=0 loops=1)
         Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900

785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,190

937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1910821

70,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,1911

28562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Index Scan using attachment_entity_id_90m_105m_by_entity_id on
attachment_entity_id_90m_105m  (cost=0.57..2390.10 rows=13579 width=133)
(actual time=0.123..0.123 rows=0 loops=1)
         Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900

785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,190

937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1910821

70,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,1911

28562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Index Scan using attachment_entity_id_105m_120m_by_entity_id on
attachment_entity_id_105m_120m  (cost=0.57..1824.95 rows=20334 width=133)
(actual time=0.134..0.134 rows=0 loops=1)
         Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900

785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,190

937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1910821

70,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,1911

28562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Index Scan using attachment_entity_id_120m_135m_by_entity_id on
attachment_entity_id_120m_135m  (cost=0.57..2474.61 rows=23011 width=131)
(actual time=0.124..0.124 rows=0 loops=1)
         Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900

785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,190

937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1910821

70,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,1911

28562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Index Scan using attachment_entity_id_135m_150m_by_entity_id on
attachment_entity_id_135m_150m  (cost=0.57..2019.61 rows=23681 width=132)
(actual time=0.125..0.125 rows=0 loops=1)
         Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900

785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,190

937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1910821

70,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,1911

28562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Index Scan using attachment_entity_id_150m_165m_by_entity_id on
attachment_entity_id_150m_165m  (cost=0.57..5090.89 rows=27380 width=133)
(actual time=0.172..0.172 rows=0 loops=1)
         Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900

785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,190

937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1910821

70,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,1911

28562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Index Scan using attachment_entity_id_165m_180m_by_entity_id on
attachment_entity_id_165m_180m  (cost=0.57..3104.96 rows=29790 width=132)
(actual time=0.134..0.134 rows=0 loops=1)
         Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900

785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,190

937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1910821

70,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,1911

28562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Index Scan using attachment_entity_id_180m_195m_by_entity_id on
attachment_entity_id_180m_195m  (cost=0.57..3094.11 rows=25198 width=134)
(actual time=0.063..49.565 rows=258 loops=
1)
         Index Cond: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900

785,190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,190

937455,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,

191034716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,1910821

70,191082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,1911

28562,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
   ->  Seq Scan on attachment_entity_id_885m_900m  (cost=0.00..1.27 rows=2
width=164) (actual time=0.013..0.013 rows=0 loops=1)
         Filter: (entity_id = ANY

('{189740255,190007498,190419209,190454048,190498132,190589677,190741801,190757628,190792101,190806372,190808350,190823698,190897323,190900401,190900785,

190901387,190905482,190907623,190908303,190909243,190910238,190910853,190912027,190912553,190913738,190915283,190915471,190915715,190916292,190917756,190921775,190924593,190924867,1909374

55,190939665,190941432,190946157,190946578,190947077,190948243,190950786,190951360,190951819,190952605,190953382,190965451,190966957,190968387,191015655,191015973,191024345,191027103,1910

34716,191035208,191037555,191043749,191044743,191044833,191045116,191045389,191045513,191071499,191072143,191073777,191076136,191078249,191078327,191079035,191080060,191082010,191082170,1

91082475,191088364,191090035,191094751,191095227,191095960,191096543,191097152,191097484,191104018,191116600,191128391,191128416,191128441,191128442,191128458,191128498,191128501,19112856

2,191128563,191128580,191128591,191139565,191145651,191152454,191152613,191155619,191156217,191156687,191156685}'::integer[]))
         Rows Removed by Filter: 2
 Planning time: 60.537 ms
 Execution time: 51.401 ms
(34 rows)
В списке pgsql-bugs по дате отправления:
Предыдущее

От: Andres Freund
Дата: 27 июля 2018 г., 02:23:23
Сообщение: Re: BUG #15299: relation does not exist errors
Следующее

От: Jeff Frost
Дата: 27 июля 2018 г., 02:53:00
Сообщение: Re: BUG #15299: relation does not exist errors
Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

BUG #15301: Scanning all partition when more than 100 items in "whereid in ()" clause

Предыдущее

Следующее
