explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H2rr

Settings
# exclusive inclusive rows x rows loops node
1. 239.966 3,894.377 ↑ 2,132.8 21 1

Seq Scan on slrkadr t (cost=0.00..67,780,846,492.12 rows=44,788 width=701) (actual time=3,689.136..3,894.377 rows=21 loops=1)

  • Filter: (((alternatives: SubPlan 2 or hashed SubPlan 4) OR ((lworker)::text = 'N'::text)) AND (instr((upper((snm)::text))::character varying, 'УВАРОВ'::character varying) <> 0))
  • Rows Removed by Filter: 87597
2.          

SubPlan (for Seq Scan)

3. 0.000 0.000 ↓ 0.0 0

Seq Scan on slrcard ap__ (cost=0.00..773,603.50 rows=1 width=0) (never executed)

  • Filter: ((SubPlan 1) AND (idkadr = t.id))
4.          

SubPlan (for Seq Scan)

5. 0.000 0.000 ↓ 0.0 0

Index Scan using fk_slrmovement_card on slrmovement (cost=0.42..15.64 rows=7 width=9) (never executed)

  • Index Cond: (idcard = ap__.id)
  • Filter: (iddepartment <> ALL ('{1941001,1741001,101001,1201001,1981001,601001,681001,721001,621001,1241001,1261001,741001,781001,581001,29320001,28838001,27723001,27531001,25335001,27111001,28787001,25328001,27045001,25223001,26835001,25146001,28765001,25233001,25110001,25087001,24914001,24671001,25307001,24946001,24674001,25317001,25308001,25222001,27113001,25134001,24680001,28780001,25299001,28785001,25283001,28776001,26847001,25329001,25128001,28829001,25133001,27547001,25191001,33856001,38096001,36682001,35780001,25056001,31191001,30958001,35578001,25409001,25438001,27715001,35985001,33816001,36184001,25088001,33881001,35509001,11541001,24551001,25333001,361001,2001,4001,181001,161001,241001,261001,281001,301001,321001,341001,121001,541001,401001,561001,441001,461001,481001,501001,521001,641001,661001,701001,2301001,821001,1001001,1021001,801001,961001,981001,841001,861001,881001,901001,921001,1221001,1141001,2281001,1181001,1121001,1081001,1101001,1161001,1041001,1061001,1321001,1461001,1401001,1481001,1301001,1341001,1361001,1381001,1421001,1621001,1701001,1501001,1581001,1601001,1661001,1541001,1521001,1561001,1721001,1641001,1861001,1881001,1901001,1921001,2021001,2261001,1761001,1801001,1781001,1821001,1841001,2162001,2201001,2121001,2181001,2141001,2221001,2161001,2241001,2041001,2061001,2081001,2101001,28601001,30438001,33527001,28766001,24590001,30122001,28654001,31193001,34191001,28773001,28771001,34190001,25657001,30612001,28772001,28781001,33838001,27569001,27571001,35821001,35820001,36706001,27319001,36689001,30458001,35410001,36707001,36695001,36119001,30637001,26092001,30967001,24654001,25352001,24666001,30954001,25432001,30876001,36190001,26155001,24676001,26158001,30874001,26156001,36189001,26159001,36186001,36191001,36185001,36188001,36112001,32413001,25885001,36113001,24697001,25887001,31194001,38029001,33119001,38038001,38031001,38032001,38037001,38030001,38027001,31192001,38061001,33121001,38035001,38028001,38036001,38026001,25898001,31129001,33122001,25897001,30465001,38094001,38093001,33103001,31190001,33123001,30249001,36232001,38033001,38034001,24721001,30243001,38095001,33099001,30250001,36378001,29754001,28234001,33101001,33104001,33105001,29752001,33100001,29758001,33108001,33098001,33107001,24786001,30887001,33097001,30679001,24802001,25354001,30829001,25391001,30674001,25388001,24807001,24799001,27191001,35938001,35939001,35936001,27249001,35935001,30673001,24808001,27214001,35987001,35917001,35914001,27253001,27251001,27250001,35918001,35984001,35932001,35925001,27256001,27254001,35927001,35931001,35920001,35928001,35941001,35732001,27184001,35733001,27185001,35942001,30675001,35948001,35728001,24810001,31667001,35696001,37392001,37404001,35738001,35735001,24811001,27181001,30677001,37405001,35747001,28350001,24918001,35745001,37395001,32657001,32648001,30686001,27182001,32519001,32566001,30379001,30372001,32527001,27231001,28361001,28364001,32535001,31345001,37266001,35514001,31344001,35508001,37267001,35511001,27232001,27720001,37099001,35320001,27721001,31767001,36915001,37265001,37097001,37264001,31341001,36916001,35132001,37268001,37261001,37259001,37294001,37262001,37255001,31343001,36933001,31765001,38699001,37289001,31506001,36788001,38697001,37290001,38811001,37286001,35137001,30943001,35073001,37287001,38860001,27714001,35369001,24961001,35198001,35368001,35377001,35370001,30875001,35382001,35383001,35378001,35200001,35379001,27724001,25001001,35381001,30945001,30963001,35201001,30956001,25420001,30951001,35204001,30953001,35205001,25418001,30669001,32925001,35575001,35576001,30734001,25078001,29232001,25061001,27460001,32923001,26079001,37999001,38000001,33953001,37996001,25083001,31303001,31299001,33952001,37993001,37997001,36198001,37992001,36247001,37994001,27624001,37991001,31304001,28883001,33955001,25090001,36299001,33957001,30635001,36300001,25398001,30670001,25093001,33966001,28609001,28611001,33939001,27461001,35580001,33935001,30640001,33963001,33946001,30646001,33969001,33945001,33972001,28613001,33940001,33947001,27063001,36126001,36173001,36128001,36142001,36092001,27060001,30616001,36107001,35850001,35868001,35849001,27239001,27242001,35853001,35855001,27243001,30665001,35869001,27216001,35424001,35453001,33830001,27225001,28728001,33831001,35427001,35457001,28730001,33832001,25126001,33833001,28877001,28732001,33829001,30603001,33835001,33871001,33828001,28882001,34008001,34007001,33982001,33976001,33979001,28880001,34006001,34005001,34037001,34003001,33999001,33984001,30569001,33986001,33990001,28885001,34001001,34002001,27761001,34840001,28843001,35272001,34842001,35271001,27762001,27764001,34850001,33892001,34841001,33928001,33922001,33895001,30619001,25148001,28721001,33820001,28719001,25150001,33822001,33824001,30597001,30606001,33826001,33852001,33900001,33851001,33854001,30639001,33853001,28598001,28803001,33898001,28739001,33896001,36913001,33906001,25164001,33897001,30656001,32352001,33907001,36987001,36967001,36949001,36968001,32432001,32391001,36952001,28743001,36963001,32421001,36911001,32437001,28748001,32389001,33868001,36924001,36917001,36973001,36918001,36984001,29738001,33869001,33112001,33111001,36931001,36979001,36929001,25180001,33879001,33874001,33113001,33876001,30620001,35582001,27462001,35584001,30555001,28862001,33556001,33144001,33558001,26261001,33797001,33145001,33798001,25186001,28864001,33799001,33804001,33801001,33802001,28866001,28868001,33993001,28870001,33800001,33994001,28872001,30587001,33998001,33995001,33997001,33796001,33795001,28775001,25257001,25255001,28847001,26100001,28777001,33768001,27342001,30204001,28759001,35781001,36209001,36206001,33759001,33774001,37040001,36891001,30615001,33770001,37031001,33772001,37023001,32362001,28849001,26003001,32295001,33765001,28807001,35203001,35202001,37306001,25259001,33763001,37302001,37384001,37314001,37319001,37391001,34045001,37323001,37307001,37388001,37310001,34016001,34046001,28810001,28813001,37355001,34048001,37358001,34047001,34013001,25442001,34042001,34051001,34054001,25280001,30553001,34040001,30667001,28779001,34152001,29024001,34148001,34149001,34151001,34150001,29021001,29023001,33841001,30565001,25356001,25288001,28853001,33842001,30224001,34153001,25298001,28855001,33792001,33788001,33813001,33790001,33818001,28859001,28857001,30634001,33809001,33811001,28770001,30560001,33840001,33839001,27236001,30650001,35890001,28794001,35888001,28793001,27237001,28979001,35847001,35844001,27238001,35846001,35843001,34034001,33918001,30611001,26162001,36181001,36183001,36177001,26168001,36180001,36178001,26165001,26163001,36174001,26170001,36118001,36115001,36116001,36175001,30574001,34038001,25368001,34039001,30376001,25152001,28600001,28796001,32356001,28840001,28593001,25235001,26315001,32480001,28726001,28836001,29321001,28800001,26877001,32338001,33848001,36073001,31510001,28804001,32365001,27722001,31409001,26599001,28736001,27827001,32373001,26314001,33844001,27112001,28820001,26316001,28832001,28791001,28799001,28778001,28845001,28592001,36538001,30743001,33843001,32366001,31505001,30392001,28763001,28816001,25097001,27066001,28764001,25111001,26876001,28725001,30577001,25997001,28750001,32395001,28767001,35072001,33837001,30740001,32340001,32331001,28769001,32341001,32240001,28828001,30596001,32333001,28837001,27784001,24600001,28797001,28817001,32336001,28846001,30642001,28831001,27458001,28734001,30613001,27457001,29266001,32375001,28768001,28818001,28821001,28835001,32359001,28839001,32374001,32364001,32357001,26834001,30579001,30632001,29267001,30548001,32303001,29334001,28795001,32334001,31311001,29324001,29322001,30614001,28735001,29323001,31504001,32412001,27749001,28819001,36661001,34025001,32377001,28792001,25101001,28724001,33846001,32384001}'::numeric[]))
6. 114.991 3,654.411 ↓ 1.2 58,034 1

Seq Scan on slrcard ap___1 (cost=0.00..773,364.35 rows=47,830 width=8) (actual time=0.104..3,654.411 rows=58,034 loops=1)

  • Filter: (SubPlan 3)
  • Rows Removed by Filter: 37626
7.          

SubPlan (for Seq Scan)

8. 3,539.420 3,539.420 ↑ 7.0 1 95,660

Index Scan using fk_slrmovement_card on slrmovement slrmovement_1 (cost=0.42..15.64 rows=7 width=9) (actual time=0.037..0.037 rows=1 loops=95,660)

  • Index Cond: (idcard = ap___1.id)
  • Filter: (iddepartment <> ALL ('{1941001,1741001,101001,1201001,1981001,601001,681001,721001,621001,1241001,1261001,741001,781001,581001,29320001,28838001,27723001,27531001,25335001,27111001,28787001,25328001,27045001,25223001,26835001,25146001,28765001,25233001,25110001,25087001,24914001,24671001,25307001,24946001,24674001,25317001,25308001,25222001,27113001,25134001,24680001,28780001,25299001,28785001,25283001,28776001,26847001,25329001,25128001,28829001,25133001,27547001,25191001,33856001,38096001,36682001,35780001,25056001,31191001,30958001,35578001,25409001,25438001,27715001,35985001,33816001,36184001,25088001,33881001,35509001,11541001,24551001,25333001,361001,2001,4001,181001,161001,241001,261001,281001,301001,321001,341001,121001,541001,401001,561001,441001,461001,481001,501001,521001,641001,661001,701001,2301001,821001,1001001,1021001,801001,961001,981001,841001,861001,881001,901001,921001,1221001,1141001,2281001,1181001,1121001,1081001,1101001,1161001,1041001,1061001,1321001,1461001,1401001,1481001,1301001,1341001,1361001,1381001,1421001,1621001,1701001,1501001,1581001,1601001,1661001,1541001,1521001,1561001,1721001,1641001,1861001,1881001,1901001,1921001,2021001,2261001,1761001,1801001,1781001,1821001,1841001,2162001,2201001,2121001,2181001,2141001,2221001,2161001,2241001,2041001,2061001,2081001,2101001,28601001,30438001,33527001,28766001,24590001,30122001,28654001,31193001,34191001,28773001,28771001,34190001,25657001,30612001,28772001,28781001,33838001,27569001,27571001,35821001,35820001,36706001,27319001,36689001,30458001,35410001,36707001,36695001,36119001,30637001,26092001,30967001,24654001,25352001,24666001,30954001,25432001,30876001,36190001,26155001,24676001,26158001,30874001,26156001,36189001,26159001,36186001,36191001,36185001,36188001,36112001,32413001,25885001,36113001,24697001,25887001,31194001,38029001,33119001,38038001,38031001,38032001,38037001,38030001,38027001,31192001,38061001,33121001,38035001,38028001,38036001,38026001,25898001,31129001,33122001,25897001,30465001,38094001,38093001,33103001,31190001,33123001,30249001,36232001,38033001,38034001,24721001,30243001,38095001,33099001,30250001,36378001,29754001,28234001,33101001,33104001,33105001,29752001,33100001,29758001,33108001,33098001,33107001,24786001,30887001,33097001,30679001,24802001,25354001,30829001,25391001,30674001,25388001,24807001,24799001,27191001,35938001,35939001,35936001,27249001,35935001,30673001,24808001,27214001,35987001,35917001,35914001,27253001,27251001,27250001,35918001,35984001,35932001,35925001,27256001,27254001,35927001,35931001,35920001,35928001,35941001,35732001,27184001,35733001,27185001,35942001,30675001,35948001,35728001,24810001,31667001,35696001,37392001,37404001,35738001,35735001,24811001,27181001,30677001,37405001,35747001,28350001,24918001,35745001,37395001,32657001,32648001,30686001,27182001,32519001,32566001,30379001,30372001,32527001,27231001,28361001,28364001,32535001,31345001,37266001,35514001,31344001,35508001,37267001,35511001,27232001,27720001,37099001,35320001,27721001,31767001,36915001,37265001,37097001,37264001,31341001,36916001,35132001,37268001,37261001,37259001,37294001,37262001,37255001,31343001,36933001,31765001,38699001,37289001,31506001,36788001,38697001,37290001,38811001,37286001,35137001,30943001,35073001,37287001,38860001,27714001,35369001,24961001,35198001,35368001,35377001,35370001,30875001,35382001,35383001,35378001,35200001,35379001,27724001,25001001,35381001,30945001,30963001,35201001,30956001,25420001,30951001,35204001,30953001,35205001,25418001,30669001,32925001,35575001,35576001,30734001,25078001,29232001,25061001,27460001,32923001,26079001,37999001,38000001,33953001,37996001,25083001,31303001,31299001,33952001,37993001,37997001,36198001,37992001,36247001,37994001,27624001,37991001,31304001,28883001,33955001,25090001,36299001,33957001,30635001,36300001,25398001,30670001,25093001,33966001,28609001,28611001,33939001,27461001,35580001,33935001,30640001,33963001,33946001,30646001,33969001,33945001,33972001,28613001,33940001,33947001,27063001,36126001,36173001,36128001,36142001,36092001,27060001,30616001,36107001,35850001,35868001,35849001,27239001,27242001,35853001,35855001,27243001,30665001,35869001,27216001,35424001,35453001,33830001,27225001,28728001,33831001,35427001,35457001,28730001,33832001,25126001,33833001,28877001,28732001,33829001,30603001,33835001,33871001,33828001,28882001,34008001,34007001,33982001,33976001,33979001,28880001,34006001,34005001,34037001,34003001,33999001,33984001,30569001,33986001,33990001,28885001,34001001,34002001,27761001,34840001,28843001,35272001,34842001,35271001,27762001,27764001,34850001,33892001,34841001,33928001,33922001,33895001,30619001,25148001,28721001,33820001,28719001,25150001,33822001,33824001,30597001,30606001,33826001,33852001,33900001,33851001,33854001,30639001,33853001,28598001,28803001,33898001,28739001,33896001,36913001,33906001,25164001,33897001,30656001,32352001,33907001,36987001,36967001,36949001,36968001,32432001,32391001,36952001,28743001,36963001,32421001,36911001,32437001,28748001,32389001,33868001,36924001,36917001,36973001,36918001,36984001,29738001,33869001,33112001,33111001,36931001,36979001,36929001,25180001,33879001,33874001,33113001,33876001,30620001,35582001,27462001,35584001,30555001,28862001,33556001,33144001,33558001,26261001,33797001,33145001,33798001,25186001,28864001,33799001,33804001,33801001,33802001,28866001,28868001,33993001,28870001,33800001,33994001,28872001,30587001,33998001,33995001,33997001,33796001,33795001,28775001,25257001,25255001,28847001,26100001,28777001,33768001,27342001,30204001,28759001,35781001,36209001,36206001,33759001,33774001,37040001,36891001,30615001,33770001,37031001,33772001,37023001,32362001,28849001,26003001,32295001,33765001,28807001,35203001,35202001,37306001,25259001,33763001,37302001,37384001,37314001,37319001,37391001,34045001,37323001,37307001,37388001,37310001,34016001,34046001,28810001,28813001,37355001,34048001,37358001,34047001,34013001,25442001,34042001,34051001,34054001,25280001,30553001,34040001,30667001,28779001,34152001,29024001,34148001,34149001,34151001,34150001,29021001,29023001,33841001,30565001,25356001,25288001,28853001,33842001,30224001,34153001,25298001,28855001,33792001,33788001,33813001,33790001,33818001,28859001,28857001,30634001,33809001,33811001,28770001,30560001,33840001,33839001,27236001,30650001,35890001,28794001,35888001,28793001,27237001,28979001,35847001,35844001,27238001,35846001,35843001,34034001,33918001,30611001,26162001,36181001,36183001,36177001,26168001,36180001,36178001,26165001,26163001,36174001,26170001,36118001,36115001,36116001,36175001,30574001,34038001,25368001,34039001,30376001,25152001,28600001,28796001,32356001,28840001,28593001,25235001,26315001,32480001,28726001,28836001,29321001,28800001,26877001,32338001,33848001,36073001,31510001,28804001,32365001,27722001,31409001,26599001,28736001,27827001,32373001,26314001,33844001,27112001,28820001,26316001,28832001,28791001,28799001,28778001,28845001,28592001,36538001,30743001,33843001,32366001,31505001,30392001,28763001,28816001,25097001,27066001,28764001,25111001,26876001,28725001,30577001,25997001,28750001,32395001,28767001,35072001,33837001,30740001,32340001,32331001,28769001,32341001,32240001,28828001,30596001,32333001,28837001,27784001,24600001,28797001,28817001,32336001,28846001,30642001,28831001,27458001,28734001,30613001,27457001,29266001,32375001,28768001,28818001,28821001,28835001,32359001,28839001,32374001,32364001,32357001,26834001,30579001,30632001,29267001,30548001,32303001,29334001,28795001,32334001,31311001,29324001,29322001,30614001,28735001,29323001,31504001,32412001,27749001,28819001,36661001,34025001,32377001,28792001,25101001,28724001,33846001,32384001}'::numeric[]))
  • Rows Removed by Filter: 1
Planning time : 24.261 ms
Execution time : 3,899.640 ms