Possible bug in postgres || libpq
| От | fredrik chabot |
|---|---|
| Тема | Possible bug in postgres || libpq |
| Дата | |
| Msg-id | 382734D6.D2AB8401@f6.nl обсуждение исходный текст |
| Список | pgsql-bugs |
Hi I'm started to try to use postgres as a backend for an bussiness application run up to what i think could be a bug in either postgres or libpq Mainly a > NOTICE: Buffer Leak: [012] (freeNext=-3, freePrev=-3, relname=dsrbk, > blockNum=0, flags=0x4, refcount=64 3) or similar following a COMMIT and a core after some time. It is reproducable when running the same commands thrue the psql util. Log included, i know it isn't pretty sql code but it should work right? All cursors are on unique indexes. Iff this is a mailing list of some sort pls cc any answer to my e-mail address. Thank's --- Met vriendelijke groet, Fredrik Chabot BEGIN; -- 6 | 942067922.071267 - 942067922.073599 | 0.002332 | 0.002332 DECLARE c_000 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'dossier afsluiten' ); -- 123 | 942067922.073762 - 942067922.365804 | 0.292042 | 0.294374 FETCH 1 IN c_000; -- 17 | 942067922.365954 - 942067922.378620 | 0.012666 | 0.307040 CLOSE c_000; -- 12 | 942067923.048869 - 942067923.049762 | 0.000893 | 0.307933 DECLARE c_001 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'offerte maken' ) ; -- 119 | 942067923.049909 - 942067923.054671 | 0.004762 | 0.312695 FETCH 1 IN c_001; -- 17 | 942067923.054792 - 942067923.055930 | 0.001138 | 0.313833 CLOSE c_001; -- 12 | 942067923.130952 - 942067923.131923 | 0.000971 | 0.314804 DECLARE c_002 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'infoblad' ) ; -- 114 | 942067923.132066 - 942067923.134337 | 0.002271 | 0.317075 FETCH 1 IN c_002; -- 17 | 942067923.134492 - 942067923.135552 | 0.001060 | 0.318135 DECLARE c_003 CURSOR FOR SELECT "afd", "txt", "sta", "stb", "stc", "std", "ste" FROM dsafd WHERE ( "afd" = 'fb' ) ; -- 115 | 942067925.413073 - 942067925.502053 | 0.088980 | 0.407115 FETCH 1 IN c_003; -- 17 | 942067925.502188 - 942067925.549679 | 0.047491 | 0.454606 CLOSE c_002; -- 12 | 942067925.549942 - 942067925.550595 | 0.000653 | 0.455259 DECLARE c_004 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'dossier afdeling fb') ; -- 125 | 942067925.550736 - 942067925.553903 | 0.003167 | 0.458426 FETCH 1 IN c_004; -- 17 | 942067925.554022 - 942067925.555236 | 0.001214 | 0.459640 DECLARE c_005 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 0 ) ; -- 138 | 942067925.555980 - 942067925.572755 | 0.016775 | 0.476415 FETCH 1 IN c_005; -- 17 | 942067925.572886 - 942067925.582957 | 0.010071 | 0.486486 DECLARE c_006 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ; -- 82 | 942067925.583220 - 942067925.645981 | 0.062761 | 0.549247 FETCH 1 IN c_006; -- 17 | 942067925.646117 - 942067925.647173 | 0.001056 | 0.550303 CLOSE c_005; -- 12 | 942067925.647400 - 942067925.647975 | 0.000575 | 0.550878 DECLARE c_007 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 1 ) ; -- 138 | 942067925.648111 - 942067925.650894 | 0.002783 | 0.553661 FETCH 1 IN c_007; -- 17 | 942067925.651036 - 942067925.652091 | 0.001055 | 0.554716 CLOSE c_006; -- 12 | 942067925.652276 - 942067925.652845 | 0.000569 | 0.555285 DECLARE c_008 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ; -- 82 | 942067925.652977 - 942067925.654883 | 0.001906 | 0.557191 FETCH 1 IN c_008; -- 17 | 942067925.655001 - 942067925.655894 | 0.000893 | 0.558084 CLOSE c_007; -- 12 | 942067926.382828 - 942067926.383656 | 0.000828 | 0.558912 DECLARE c_009 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 0 ) ; -- 138 | 942067926.383834 - 942067926.386734 | 0.002900 | 0.561812 FETCH 1 IN c_009; -- 17 | 942067926.386855 - 942067926.387820 | 0.000965 | 0.562777 CLOSE c_008; -- 12 | 942067926.388014 - 942067926.388587 | 0.000573 | 0.563350 DECLARE c_010 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ; -- 82 | 942067926.388717 - 942067926.390598 | 0.001881 | 0.565231 FETCH 1 IN c_010; -- 17 | 942067926.390716 - 942067926.391669 | 0.000953 | 0.566184 CLOSE c_009; -- 12 | 942067926.391880 - 942067926.392447 | 0.000567 | 0.566751 DECLARE c_011 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 0 ) ; -- 138 | 942067926.392576 - 942067926.395185 | 0.002609 | 0.569360 FETCH 1 IN c_011; -- 17 | 942067926.395305 - 942067926.396223 | 0.000918 | 0.570278 CLOSE c_010; -- 12 | 942067926.396468 - 942067926.397049 | 0.000581 | 0.570859 DECLARE c_012 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ; -- 82 | 942067926.397182 - 942067926.399069 | 0.001887 | 0.572746 FETCH 1 IN c_012; -- 17 | 942067926.399190 - 942067926.400118 | 0.000928 | 0.573674 CLOSE c_011; -- 12 | 942067926.400328 - 942067926.400901 | 0.000573 | 0.574247 DECLARE c_013 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 1 ) ; -- 138 | 942067926.401761 - 942067926.404424 | 0.002663 | 0.576910 FETCH 1 IN c_013; -- 17 | 942067926.404547 - 942067926.405480 | 0.000933 | 0.577843 CLOSE c_012; -- 12 | 942067926.405670 - 942067926.406242 | 0.000572 | 0.578415 DECLARE c_014 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ; -- 82 | 942067926.406376 - 942067926.408232 | 0.001856 | 0.580271 FETCH 1 IN c_014; -- 17 | 942067926.408352 - 942067926.409238 | 0.000886 | 0.581157 CLOSE c_013; -- 12 | 942067926.409509 - 942067926.410099 | 0.000590 | 0.581747 DECLARE c_015 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 1 ) ; -- 138 | 942067926.410231 - 942067926.412881 | 0.002650 | 0.584397 FETCH 1 IN c_015; -- 17 | 942067926.413004 - 942067926.413934 | 0.000930 | 0.585327 CLOSE c_014; -- 12 | 942067926.414119 - 942067926.414689 | 0.000570 | 0.585897 DECLARE c_016 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ; -- 82 | 942067926.414821 - 942067926.416669 | 0.001848 | 0.587745 FETCH 1 IN c_016; -- 17 | 942067926.416789 - 942067926.417676 | 0.000887 | 0.588632 DECLARE mycursor CURSOR FOR SELECT "afd", "dss", "usr", "dat", "anc", "rel", "refa", "refb", "refc", "refd", "sta", "stb","stc", "std", "ste", "fsa", "fsb", "fsc", "fsd", "fse", "vko", "vkk", "nko", "nkk", "vzo", "vzk", "daa", "dab" FROMdskop WHERE ( "afd" = 'fb' and "dss" >= 0 ) or ( "afd" > 'fb' ) ORDER BY "afd" ASC , "dss" ASC ; -- 345 | 942067927.163193 - 942067927.302727 | 0.139534 | 0.728166 FETCH 15 in mycursor; -- 21 | 942067927.302866 - 942067927.855583 | 0.552717 | 1.280883 FETCH 14 in mycursor; -- 21 | 942067928.562389 - 942067928.568760 | 0.006371 | 1.287254 CLOSE c_004; -- 12 | 942067929.502468 - 942067929.503137 | 0.000669 | 1.287923 CLOSE c_003; -- 12 | 942067929.503252 - 942067929.503924 | 0.000672 | 1.288595 CLOSE c_015; -- 12 | 942067929.504033 - 942067929.504585 | 0.000552 | 1.289147 CLOSE c_016; -- 12 | 942067929.504690 - 942067929.505236 | 0.000546 | 1.289693 COMMIT; NOTICE: Buffer Leak: [012] (freeNext=-3, freePrev=-3, relname=dsrbk, blockNum=0, flags=0x4, refcount=64 3) -- 7 | 942067929.505331 - 942067929.506955 | 0.001624 | 1.291317 BEGIN; -- 6 | 942067929.507357 - 942067929.507982 | 0.000625 | 1.291942 DECLARE c_017 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'dossier afdeling fb') ; -- 125 | 942067929.508118 - 942067929.511895 | 0.003777 | 1.295719 FETCH 1 IN c_017; -- 17 | 942067929.512048 - 942067929.513329 | 0.001281 | 1.297000 DECLARE c_018 CURSOR FOR SELECT "afd", "dss", "usr", "dat", "anc", "rel", "refa", "refb", "refc", "refd", "sta", "stb", "stc","std", "ste", "fsa", "fsb", "fsc", "fsd", "fse", "vko", "vkk", "nko", "nkk", "vzo", "vzk", "daa", "dab" FROM dskopWHERE ( "afd" = 'fb' and "dss" = 61 ) ; -- 288 | 942067929.513675 - 942067929.520480 | 0.006805 | 1.303805 FETCH 1 IN c_018; -- 17 | 942067929.520603 - 942067929.523423 | 0.002820 | 1.306625 DECLARE c_019 CURSOR FOR SELECT "afd", "txt", "sta", "stb", "stc", "std", "ste" FROM dsafd WHERE ( "afd" = 'fb' ) ; -- 115 | 942067929.523690 - 942067929.526013 | 0.002323 | 1.308948 FETCH 1 IN c_019; -- 17 | 942067929.526132 - 942067929.527071 | 0.000939 | 1.309887 DECLARE c_020 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 0 ) ; -- 138 | 942067929.527773 - 942067929.530716 | 0.002943 | 1.312830 FETCH 1 IN c_020; -- 17 | 942067929.530865 - 942067929.533120 | 0.002255 | 1.315085 DECLARE c_021 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ; -- 82 | 942067929.533322 - 942067929.535316 | 0.001994 | 1.317079 FETCH 1 IN c_021; -- 17 | 942067929.535429 - 942067929.536398 | 0.000969 | 1.318048 CLOSE c_020; -- 12 | 942067929.536602 - 942067929.537204 | 0.000602 | 1.318650 DECLARE c_022 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 0 ) ; -- 138 | 942067929.537340 - 942067929.540150 | 0.002810 | 1.321460 FETCH 1 IN c_022; -- 17 | 942067929.540267 - 942067929.541413 | 0.001146 | 1.322606 DECLARE c_023 CURSOR FOR SELECT "afd", "dss", "rbk", "ref" FROM dsrbi WHERE ( "afd" = 'fb' and "dss" = 61 and "rbk"= 'zknm' ) ; -- 135 | 942067929.541638 - 942067929.567375 | 0.025737 | 1.348343 FETCH 1 IN c_023; -- 17 | 942067929.567500 - 942067929.610969 | 0.043469 | 1.391812 CLOSE c_022; -- 12 | 942067929.611222 - 942067929.611920 | 0.000698 | 1.392510 DECLARE c_024 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 1 ) ; -- 138 | 942067929.612060 - 942067929.614951 | 0.002891 | 1.395401 FETCH 1 IN c_024; -- 17 | 942067929.615087 - 942067929.616152 | 0.001065 | 1.396466 CLOSE c_021; -- 12 | 942067929.616332 - 942067929.616926 | 0.000594 | 1.397060 DECLARE c_025 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ; -- 82 | 942067929.617061 - 942067929.618970 | 0.001909 | 1.398969 FETCH 1 IN c_025; -- 17 | 942067929.619085 - 942067929.620003 | 0.000918 | 1.399887 CLOSE c_024; -- 12 | 942067929.620205 - 942067929.620796 | 0.000591 | 1.400478 DECLARE c_026 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 1 ) ; -- 138 | 942067929.620930 - 942067929.624025 | 0.003095 | 1.403573 FETCH 1 IN c_026; -- 17 | 942067929.624140 - 942067929.625106 | 0.000966 | 1.404539 CLOSE c_023; -- 12 | 942067929.625343 - 942067929.626051 | 0.000708 | 1.405247 DECLARE c_027 CURSOR FOR SELECT "afd", "dss", "rbk", "ref" FROM dsrbi WHERE ( "afd" = 'fb' and "dss" = 61 and "rbk"= 'team' ) ; -- 135 | 942067929.626187 - 942067929.629731 | 0.003544 | 1.408791 FETCH 1 IN c_027; -- 17 | 942067929.629849 - 942067929.630946 | 0.001097 | 1.409888 CLOSE c_026; -- 12 | 942067930.255096 - 942067930.255787 | 0.000691 | 1.410579 DECLARE c_028 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 0 ) ; -- 138 | 942067930.255923 - 942067930.258988 | 0.003065 | 1.413644 FETCH 1 IN c_028; -- 17 | 942067930.259102 - 942067930.260110 | 0.001008 | 1.414652 CLOSE c_025; -- 12 | 942067930.260299 - 942067930.260895 | 0.000596 | 1.415248 DECLARE c_029 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ; -- 82 | 942067930.261443 - 942067930.263417 | 0.001974 | 1.417222 FETCH 1 IN c_029; -- 17 | 942067930.263563 - 942067930.264530 | 0.000967 | 1.418189 CLOSE c_028; -- 12 | 942067930.264730 - 942067930.265330 | 0.000600 | 1.418789 DECLARE c_030 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 1 ) ; -- 138 | 942067930.265459 - 942067930.268189 | 0.002730 | 1.421519 FETCH 1 IN c_030; -- 17 | 942067930.268300 - 942067930.269290 | 0.000990 | 1.422509 CLOSE c_029; -- 12 | 942067930.269467 - 942067930.270055 | 0.000588 | 1.423097 DECLARE c_031 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ; -- 82 | 942067930.270185 - 942067930.272871 | 0.002686 | 1.425783 FETCH 1 IN c_031; -- 17 | 942067930.272982 - 942067930.273916 | 0.000934 | 1.426717 CLOSE c_019; -- 12 | 942067930.673025 - 942067930.673590 | 0.000565 | 1.427282 DECLARE c_032 CURSOR FOR SELECT "afd", "txt", "sta", "stb", "stc", "std", "ste" FROM dsafd WHERE ( "afd" = 'fb' ) ; -- 115 | 942067930.673721 - 942067930.676058 | 0.002337 | 1.429619 FETCH 1 IN c_032; -- 17 | 942067930.676254 - 942067930.677222 | 0.000968 | 1.430587 CLOSE c_017; -- 12 | 942067930.677440 - 942067930.678085 | 0.000645 | 1.431232 DECLARE c_033 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'dossier afdeling fb') ; -- 125 | 942067930.678224 - 942067930.680550 | 0.002326 | 1.433558 FETCH 1 IN c_033; -- 17 | 942067930.680669 - 942067930.682129 | 0.001460 | 1.435018 CLOSE c_030; -- 12 | 942067930.682692 - 942067930.683361 | 0.000669 | 1.435687 DECLARE c_034 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 0 ) ; -- 138 | 942067930.683498 - 942067930.686268 | 0.002770 | 1.438457 FETCH 1 IN c_034; -- 17 | 942067930.686384 - 942067930.687442 | 0.001058 | 1.439515 CLOSE c_031; -- 12 | 942067930.687630 - 942067930.688240 | 0.000610 | 1.440125 DECLARE c_035 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ; -- 82 | 942067930.688376 - 942067930.690294 | 0.001918 | 1.442043 FETCH 1 IN c_035; -- 17 | 942067930.690411 - 942067930.692015 | 0.001604 | 1.443647 CLOSE c_034; -- 12 | 942067930.692217 - 942067930.692850 | 0.000633 | 1.444280 DECLARE c_036 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 1 ) ; -- 138 | 942067930.692986 - 942067930.695687 | 0.002701 | 1.446981 FETCH 1 IN c_036; -- 17 | 942067930.695804 - 942067930.696804 | 0.001000 | 1.447981 CLOSE c_035; -- 12 | 942067930.696987 - 942067930.697599 | 0.000612 | 1.448593 DECLARE c_037 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ; -- 82 | 942067930.697733 - 942067930.699588 | 0.001855 | 1.450448 FETCH 1 IN c_037; -- 17 | 942067930.699706 - 942067930.700625 | 0.000919 | 1.451367 CLOSE c_036; -- 12 | 942067931.092810 - 942067931.093485 | 0.000675 | 1.452042 DECLARE c_038 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 0 ) ; -- 138 | 942067931.093622 - 942067931.096847 | 0.003225 | 1.455267 FETCH 1 IN c_038; -- 17 | 942067931.096965 - 942067931.097994 | 0.001029 | 1.456296 CLOSE c_037; -- 12 | 942067931.098182 - 942067931.098791 | 0.000609 | 1.456905 DECLARE c_039 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ; -- 82 | 942067931.098924 - 942067931.100829 | 0.001905 | 1.458810 FETCH 1 IN c_039; -- 17 | 942067931.100946 - 942067931.102063 | 0.001117 | 1.459927 CLOSE c_038; -- 12 | 942067931.102269 - 942067931.102864 | 0.000595 | 1.460522 DECLARE c_040 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 0 ) ; -- 138 | 942067931.102996 - 942067931.105840 | 0.002844 | 1.463366 FETCH 1 IN c_040; -- 17 | 942067931.105956 - 942067931.106942 | 0.000986 | 1.464352 CLOSE c_039; -- 12 | 942067931.107121 - 942067931.107722 | 0.000601 | 1.464953 DECLARE c_041 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ; -- 82 | 942067931.107853 - 942067931.109743 | 0.001890 | 1.466843 FETCH 1 IN c_041; -- 17 | 942067931.109857 - 942067931.110810 | 0.000953 | 1.467796 CLOSE c_040; -- 12 | 942067931.111630 - 942067931.112281 | 0.000651 | 1.468447 DECLARE c_042 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 1 ) ; -- 138 | 942067931.112413 - 942067931.115128 | 0.002715 | 1.471162 FETCH 1 IN c_042; -- 17 | 942067931.115351 - 942067931.116379 | 0.001028 | 1.472190 CLOSE c_041; -- 12 | 942067931.116559 - 942067931.117169 | 0.000610 | 1.472800 DECLARE c_043 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ; -- 82 | 942067931.117299 - 942067931.119155 | 0.001856 | 1.474656 FETCH 1 IN c_043; -- 17 | 942067931.119269 - 942067931.120191 | 0.000922 | 1.475578 CLOSE c_042; -- 12 | 942067931.120396 - 942067931.121155 | 0.000759 | 1.476337 DECLARE c_044 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 1 ) ; -- 138 | 942067931.121288 - 942067931.124044 | 0.002756 | 1.479093 FETCH 1 IN c_044; -- 17 | 942067931.124160 - 942067931.125280 | 0.001120 | 1.480213 CLOSE c_043; -- 12 | 942067931.125461 - 942067931.126077 | 0.000616 | 1.480829 DECLARE c_045 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ; -- 82 | 942067931.126207 - 942067931.128058 | 0.001851 | 1.482680 FETCH 1 IN c_045; -- 17 | 942067931.128174 - 942067931.129103 | 0.000929 | 1.483609 DECLARE mycursor CURSOR FOR SELECT "afd", "dss", "usr", "dat", "anc", "rel", "refa", "refb", "refc", "refd", "sta", "stb","stc", "std", "ste", "fsa", "fsb", "fsc", "fsd", "fse", "vko", "vkk", "nko", "nkk", "vzo", "vzk", "daa", "dab" FROMdskop WHERE ( "afd" = 'fb' and "dss" >= 0 ) or ( "afd" > 'fb' ) ORDER BY "afd" ASC , "dss" ASC ; -- 345 | 942067931.343068 - 942067931.352445 | 0.009377 | 1.492986 FETCH 15 in mycursor; -- 21 | 942067931.352579 - 942067931.681772 | 0.329193 | 1.822179 FETCH 14 in mycursor; -- 21 | 942067932.241788 - 942067932.247901 | 0.006113 | 1.828292 FETCH 14 in mycursor; -- 21 | 942067932.562508 - 942067932.568717 | 0.006209 | 1.834501 CLOSE c_033; -- 12 | 942067933.352205 - 942067933.352882 | 0.000677 | 1.835178 CLOSE c_018; -- 12 | 942067933.353000 - 942067933.353714 | 0.000714 | 1.835892 CLOSE c_032; -- 12 | 942067933.353827 - 942067933.354384 | 0.000557 | 1.836449 CLOSE c_044; -- 12 | 942067933.354497 - 942067933.355046 | 0.000549 | 1.836998 CLOSE c_045; -- 12 | 942067933.355157 - 942067933.355715 | 0.000558 | 1.837556 CLOSE c_027; -- 12 | 942067933.355827 - 942067933.356409 | 0.000582 | 1.838138 COMMIT; NOTICE: Buffer Leak: [012] (freeNext=-3, freePrev=-3, relname=dsrbk, blockNum=0, flags=0x4, refcount=73 3) -- 7 | 942067933.356511 - 942067933.357929 | 0.001418 | 1.839556 BEGIN; -- 6 | 942067933.358296 - 942067933.358924 | 0.000628 | 1.840184 DECLARE c_046 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'dossier afdeling fb') ; -- 125 | 942067933.359067 - 942067933.363003 | 0.003936 | 1.844120 FETCH 1 IN c_046; -- 17 | 942067933.363125 - 942067933.364413 | 0.001288 | 1.845408 DECLARE c_047 CURSOR FOR SELECT "afd", "dss", "usr", "dat", "anc", "rel", "refa", "refb", "refc", "refd", "sta", "stb", "stc","std", "ste", "fsa", "fsb", "fsc", "fsd", "fse", "vko", "vkk", "nko", "nkk", "vzo", "vzk", "daa", "dab" FROM dskopWHERE ( "afd" = 'fb' and "dss" = 77 ) ; -- 288 | 942067933.364765 - 942067933.372189 | 0.007424 | 1.852832 FETCH 1 IN c_047; -- 17 | 942067933.372313 - 942067933.374445 | 0.002132 | 1.854964 DECLARE c_048 CURSOR FOR SELECT "afd", "txt", "sta", "stb", "stc", "std", "ste" FROM dsafd WHERE ( "afd" = 'fb' ) ; -- 115 | 942067933.374751 - 942067933.377074 | 0.002323 | 1.857287 FETCH 1 IN c_048; -- 17 | 942067933.377195 - 942067933.378140 | 0.000945 | 1.858232 DECLARE c_049 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 0 ) ; -- 138 | 942067933.378799 - 942067933.402605 | 0.023806 | 1.882038 FETCH 1 IN c_049; -- 17 | 942067933.402756 - 942067933.403903 | 0.001147 | 1.883185 DECLARE c_050 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ; -- 82 | 942067933.404128 - 942067933.406118 | 0.001990 | 1.885175 FETCH 1 IN c_050; -- 17 | 942067933.406237 - 942067933.407207 | 0.000970 | 1.886145 CLOSE c_049; -- 12 | 942067933.407420 - 942067933.408031 | 0.000611 | 1.886756 DECLARE c_051 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 0 ) ; -- 138 | 942067933.408171 - 942067933.410989 | 0.002818 | 1.889574 FETCH 1 IN c_051; -- 17 | 942067933.411130 - 942067933.412094 | 0.000964 | 1.890538 DECLARE c_052 CURSOR FOR SELECT "afd", "dss", "rbk", "ref" FROM dsrbi WHERE ( "afd" = 'fb' and "dss" = 77 and "rbk"= 'zknm' ) ; -- 135 | 942067933.412318 - 942067933.416005 | 0.003687 | 1.894225 FETCH 1 IN c_052; -- 17 | 942067933.416163 - 942067933.418417 | 0.002254 | 1.896479 CLOSE c_051; -- 12 | 942067933.418640 - 942067933.419269 | 0.000629 | 1.897108 DECLARE c_053 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 1 ) ; -- 138 | 942067933.419409 - 942067933.422382 | 0.002973 | 1.900081 FETCH 1 IN c_053; -- 17 | 942067933.422499 - 942067933.423471 | 0.000972 | 1.901053 CLOSE c_050; -- 12 | 942067933.423654 - 942067933.424248 | 0.000594 | 1.901647 DECLARE c_054 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ; -- 82 | 942067933.424388 - 942067933.426306 | 0.001918 | 1.903565 FETCH 1 IN c_054; -- 17 | 942067933.426423 - 942067933.427345 | 0.000922 | 1.904487 CLOSE c_053; -- 12 | 942067933.427544 - 942067933.428145 | 0.000601 | 1.905088 DECLARE c_055 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 1 ) ; -- 138 | 942067933.428282 - 942067933.431055 | 0.002773 | 1.907861 FETCH 1 IN c_055; -- 17 | 942067933.431173 - 942067933.432173 | 0.001000 | 1.908861 CLOSE c_052; -- 12 | 942067933.432382 - 942067933.433017 | 0.000635 | 1.909496 DECLARE c_056 CURSOR FOR SELECT "afd", "dss", "rbk", "ref" FROM dsrbi WHERE ( "afd" = 'fb' and "dss" = 77 and "rbk"= 'team' ) ; -- 135 | 942067933.433163 - 942067933.437002 | 0.003839 | 1.913335 FETCH 1 IN c_056; -- 17 | 942067933.437126 - 942067933.438270 | 0.001144 | 1.914479 CLOSE c_055; -- 12 | 942067934.573200 - 942067934.573843 | 0.000643 | 1.915122 DECLARE c_057 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 0 ) ; -- 138 | 942067934.573980 - 942067934.577026 | 0.003046 | 1.918168 FETCH 1 IN c_057; -- 17 | 942067934.577142 - 942067934.578162 | 0.001020 | 1.919188 CLOSE c_054; -- 12 | 942067934.578351 - 942067934.578956 | 0.000605 | 1.919793 DECLARE c_058 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ; -- 82 | 942067934.579094 - 942067934.581199 | 0.002105 | 1.921898 FETCH 1 IN c_058; -- 17 | 942067934.581314 - 942067934.582291 | 0.000977 | 1.922875 CLOSE c_056; -- 12 | 942067934.582487 - 942067934.583126 | 0.000639 | 1.923514 DECLARE c_059 CURSOR FOR SELECT "afd", "dss", "rbk", "ref" FROM dsrbi WHERE ( "afd" = 'fb' and "dss" = 77 and "rbk"= 'zknm' ) ; -- 135 | 942067934.583258 - 942067934.586832 | 0.003574 | 1.927088 FETCH 1 IN c_059; -- 17 | 942067934.586949 - 942067934.588116 | 0.001167 | 1.928255 CLOSE c_046; -- 12 | 942067934.723540 - 942067934.724291 | 0.000751 | 1.929006 CLOSE c_047; -- 12 | 942067934.724406 - 942067934.725071 | 0.000665 | 1.929671 CLOSE c_048; -- 12 | 942067934.725185 - 942067934.725739 | 0.000554 | 1.930225 CLOSE c_057; -- 12 | 942067934.725851 - 942067934.726389 | 0.000538 | 1.930763 CLOSE c_058; -- 12 | 942067934.726504 - 942067934.727052 | 0.000548 | 1.931311 CLOSE c_059; -- 12 | 942067934.727165 - 942067934.727743 | 0.000578 | 1.931889 COMMIT; NOTICE: Buffer Leak: [061] (freeNext=-3, freePrev=-3, relname=dsafr, blockNum=0, flags=0x4, refcount=8 3) -- 7 | 942067934.727870 - 942067934.728713 | 0.000843 | 1.932732 BEGIN; -- 6 | 942067934.728791 - 942067934.729337 | 0.000546 | 1.933278 UPDATE dsrbi SET "afd" = 'fb', "dss" = 77, "rbk" = 'zknm', "ref" = 'bowling' WHERE ( "afd" = 'fb' and "dss" = 77 and "rbk" = 'zknm' ) ; -- 149 | 942067934.729570 - 942067934.960004 | 0.230434 | 2.163712 COMMIT; -- 7 | 942067934.960173 - 942067934.963364 | 0.003191 | 2.166903 BEGIN; -- 6 | 942067934.963560 - 942067934.964195 | 0.000635 | 2.167538 DECLARE c_060 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb' and"vnr" = 1 ) ; -- 138 | 942067934.964335 - 942067934.968985 | 0.004650 | 2.172188 FETCH 1 IN c_060; -- 17 | 942067934.969105 - 942067934.970128 | 0.001023 | 2.173211 DECLARE c_061 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ; -- 82 | 942067934.970337 - 942067934.980919 | 0.010582 | 2.183793 FETCH 1 IN c_061; -- 17 | 942067934.981193 - 942067934.982232 | 0.001039 | 2.184832 DECLARE c_062 CURSOR FOR SELECT "afd", "dss", "rbk", "ref" FROM dsrbi WHERE ( "afd" = 'fb' and "dss" = 77 and "rbk"= 'team' ) ; -- 135 | 942067934.982449 - 942067934.986014 | 0.003565 | 2.188397 FETCH 1 IN c_062; -- 17 | 942067934.986134 - 942067934.987801 | 0.001667 | 2.190064 DECLARE c_063 CURSOR FOR SELECT "rbk", "num", "len", "ref" FROM dsrbc WHERE ( "rbk" = 'team' and "num" = '1' ) ; -- 112 | 942067935.643476 - 942067935.686930 | 0.043454 | 2.233518 FETCH 1 IN c_063; -- 17 | 942067935.687065 - 942067935.722401 | 0.035336 | 2.268854 CLOSE c_063; -- 12 | 942067935.722621 - 942067935.723304 | 0.000683 | 2.269537 DECLARE c_064 CURSOR FOR SELECT "rbk", "num", "len", "ref" FROM dsrbc WHERE ( "rbk" = 'team' and "num" > '1' ) or ( "rbk"> 'team' ) ORDER BY "rbk" ASC , "num" ASC ; -- 167 | 942067935.723444 - 942067935.727508 | 0.004064 | 2.273601 FETCH 1 IN c_064; -- 17 | 942067935.727668 - 942067935.729082 | 0.001414 | 2.275015 CLOSE c_060; -- 12 | 942067935.730191 - 942067935.730874 | 0.000683 | 2.275698 CLOSE c_061; -- 12 | 942067935.730995 - 942067935.731582 | 0.000587 | 2.276285 CLOSE c_062; -- 12 | 942067935.731698 - 942067935.732293 | 0.000595 | 2.276880 CLOSE c_064; -- 12 | 942067935.732409 - 942067935.732977 | 0.000568 | 2.277448 COMMIT; NOTICE: Buffer Leak: [009] (freeNext=-3, freePrev=-3, relname=dsrbi_primary, blockNum=1, flags=0x4, refcount=312 1) NOTICE: Buffer Leak: [013] (freeNext=-3, freePrev=-3, relname=dsrbi, blockNum=7, flags=0x4, refcount=44 1) -- 7 | 942067935.733079 - 942067935.734087 | 0.001008 | 2.278456 BEGIN; -- 6 | 942067935.734167 - 942067935.734715 | 0.000548 | 2.279004 UPDATE dsrbi SET "afd" = 'fb', "dss" = 77, "rbk" = 'team', "ref" = '1' WHERE ( "afd" = 'fb' and "dss" = 77and "rbk" = 'team' ) ; -- 143 | 942067935.734914 - 942067935.766429 | 0.031515 | 2.310519 COMMIT; -- 7 | 942067935.766597 - 942067935.769107 | 0.002510 | 2.313029 BEGIN; -- 6 | 942067935.769221 - 942067935.769844 | 0.000623 | 2.313652 COMMIT; -- 7 | 942067935.769951 - 942067935.770441 | 0.000490 | 2.314142 BEGIN; -- 6 | 942067935.770536 - 942067935.771066 | 0.000530 | 2.314672 UPDATE dskop SET "afd" = 'fb', "dss" = 77, "usr" = 'helga', "dat" = '19971229101433', "anc" = 0, "rel" = 'hogekamp', "refa" = 'Bowlingcentrum', "refb" = 'Lelystad', "refc" = '', "refd" = 'F.O. Harryvan', "sta" = 0, "stb" = 1, "stc" = 1, "std" = 0, "ste" = 0, "fsa" = 0, "fsb" = 0, "fsc" = 0, "fsd" = 0, "fse" = 0, "vko" = 5577.10,"vkk" = 0.00, "nko" = 5577.10, "nkk" = 0.00, "vzo" = 0.00, "vzk" = 0.00, "daa" = '0000000000000000',"dab" = '0000000000000000' WHERE ( "afd" = 'fb' and "dss" = 77 ) ; -- 559 | 942067935.771974 - 942067935.848941 | 0.076967 | 2.391639 COMMIT; -- 7 | 942067935.849079 - 942067935.853348 | 0.004269 | 2.395908 BEGIN; -- 6 | 942067935.940634 - 942067935.941461 | 0.000827 | 2.396735 DECLARE c_065 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'dossier regels bij nu') ; -- 127 | 942067935.941598 - 942067935.945317 | 0.003719 | 2.400454 FETCH 1 IN c_065; -- 17 | 942067935.945437 - 942067935.946720 | 0.001283 | 2.401737 DECLARE c_066 CURSOR FOR SELECT "afd", "dss", "dat", "srt", "akt", "oms", "anc", "vkk", "vkka", "vkkt", "vkkv", "vkkr", "fav","ibs", "nkk", "nkkv", "nkkr", "vko", "vkoa", "vkot", "vkov", "vkor", "faa", "vbs", "sta", "nko", "nkov", "nkor", "stb","stc", "std", "ste", "fsa", "fsb", "fsc", "fsd", "fse" FROM dsrgl WHERE ( "afd" = 'fb' and "dss" = 77 and "dat"< '1999110114321500' ) or ( "afd" = 'fb' and "dss" < 77 ) or ( "afd" < 'fb' ) ORDER BY "afd" DESC , "dss"DESC , "dat" DESC ; -- 501 | 942067935.947220 - 942067936.025509 | 0.078289 | 2.480026 FETCH 1 IN c_066; -- 17 | 942067936.025659 - 942067937.547247 | 1.521588 | 4.001614 DECLARE mycursor CURSOR FOR SELECT "afd", "dss", "dat", "srt", "akt", "oms", "anc", "vkk", "vkka", "vkkt", "vkkv", "vkkr","fav", "ibs", "nkk", "nkkv", "nkkr", "vko", "vkoa", "vkot", "vkov", "vkor", "faa", "vbs", "sta", "nko", "nkov", "nkor","stb", "stc", "std", "ste", "fsa", "fsb", "fsc", "fsd", "fse" FROM dsrgl WHERE ( "afd" = 'fb' and "dss" = 77and "dat" >= '19980114135309' ) or ( "afd" = 'fb' and "dss" > 77 ) or ( "afd" > 'fb' ) ORDER BY "afd" ASC , "dss"ASC , "dat" ASC ; -- 500 | 942067937.547907 - 942067937.563798 | 0.015891 | 4.017505 FETCH 11 in mycursor; -- 21 | 942067937.563939 - 942067951.436013 | 13.872074 | 17.889579 CLOSE c_065; -- 12 | 942067953.072421 - 942067953.073304 | 0.000883 | 17.890462 CLOSE c_066; -- 12 | 942067953.073424 - 942067953.074296 | 0.000872 | 17.891334 COMMIT; -- 7 | 942067953.074403 - 942067953.295072 | 0.220669 | 18.112003 BEGIN; -- 6 | 942067953.295201 - 942067953.295944 | 0.000743 | 18.112746 DECLARE mycursor CURSOR FOR SELECT "afd", "dss", "dat", "srt", "akt", "oms", "anc", "vkk", "vkka", "vkkt", "vkkv", "vkkr","fav", "ibs", "nkk", "nkkv", "nkkr", "vko", "vkoa", "vkot", "vkov", "vkor", "faa", "vbs", "sta", "nko", "nkov", "nkor","stb", "stc", "std", "ste", "fsa", "fsb", "fsc", "fsd", "fse" FROM dsrgl WHERE ( "afd" = 'fb' and "dss" = 77and "dat" <= '19980114135309' ) or ( "afd" = 'fb' and "dss" < 77 ) or ( "afd" < 'fb' ) ORDER BY "afd" DESC ,"dss" DESC , "dat" DESC ; -- 503 | 942067953.296340 - 942067953.310466 | 0.014126 | 18.126872 FETCH 11 in mycursor; -- 21 | 942067953.310603 - 942067954.521575 | 1.210972 | 19.337844 COMMIT; -- 7 | 942067954.522578 - 942067954.523757 | 0.001179 | 19.339023 BEGIN; -- 6 | 942067954.523852 - 942067954.524411 | 0.000559 | 19.339582 DECLARE mycursor CURSOR FOR SELECT "afd", "dss", "dat", "srt", "akt", "oms", "anc", "vkk", "vkka", "vkkt", "vkkv", "vkkr","fav", "ibs", "nkk", "nkkv", "nkkr", "vko", "vkoa", "vkot", "vkov", "vkor", "faa", "vbs", "sta", "nko", "nkov", "nkor","stb", "stc", "std", "ste", "fsa", "fsb", "fsc", "fsd", "fse" FROM dsrgl WHERE ( "afd" = 'fb' and "dss" = 77and "dat" >= '19971229101433' ) or ( "afd" = 'fb' and "dss" > 77 ) or ( "afd" > 'fb' ) ORDER BY "afd" ASC , "dss"ASC , "dat" ASC ; -- 500 | 942067954.524791 - 942067954.564314 | 0.039523 | 19.379105 FETCH 11 in mycursor; -- 21 | 942067954.564476 - 942067967.715107 | 13.150631 | 32.529736 COMMIT; -- 7 | 942067975.132611 - 942067976.605505 | 1.472894 | 34.002630 BEGIN; -- 6 | 942067976.605797 - 942067976.606633 | 0.000836 | 34.003466 DECLARE c_067 CURSOR FOR SELECT "oms", "srt", "grp", "fi1", "fi2", "fi3", "fi4", "st1", "st2" FROM dsakt WHERE ( "oms" ='vaste post' ) ; -- 137 | 942067976.606773 - 942067976.814521 | 0.207748 | 34.211214 FETCH 1 IN c_067; -- 17 | 942067976.814668 - 942067976.829493 | 0.014825 | 34.226039 DECLARE c_068 CURSOR FOR SELECT "ste", "afd", "dss", "srt", "oma", "omb", "omc", "vku", "amv", "con", "fqa", "fqb", "daf","vla", "vlb", "vlc", "vld", "vle", "ref", "dop", "dlv", "tga", "tgb", "dpr", "vwn", "tgc", "dbf", "tgd", "tge", "a1z","a1n", "a11", "a12", "a13", "a14", "a15" FROM obdtr WHERE ( "ste" = 11012 ) ; -- 323 | 942067976.830425 - 942067977.018777 | 0.188352 | 34.414391 FETCH 1 IN c_068; -- 17 | 942067977.018919 - 942067977.151796 | 0.132877 | 34.547268 DECLARE c_069 CURSOR FOR SELECT "key", "tel" FROM alftl WHERE ( "key" = 'plkop' ) ; -- 83 | 942067979.084260 - 942067979.143590 | 0.059330 | 34.606598 FETCH 1 IN c_069; -- 17 | 942067979.143727 - 942067979.164500 | 0.020773 | 34.627371 CLOSE c_067; -- 12 | 942067979.164661 - 942067979.165445 | 0.000784 | 34.628155 CLOSE c_068; -- 12 | 942067979.165564 - 942067979.166169 | 0.000605 | 34.628760 CLOSE c_069; -- 12 | 942067979.166284 - 942067979.166842 | 0.000558 | 34.629318 COMMIT; NOTICE: Buffer Leak: [016] (freeNext=-3, freePrev=-3, relname=obdtr, blockNum=417, flags=0x4, refcount=1 1) NOTICE: Buffer Leak: [044] (freeNext=-3, freePrev=-3, relname=obdtr_primary, blockNum=44, flags=0x4, refcount=1 1) -- 7 | 942067979.166942 - 942067979.175343 | 0.008401 | 34.637719 BEGIN; -- 6 | 942067979.175426 - 942067979.175907 | 0.000481 | 34.638200 UPDATE alftl SET "key" = 'plkop', "tel" = 520 WHERE ( "key" = 'plkop' ) ; -- 79 | 942067979.176061 - 942067979.217475 | 0.041414 | 34.679614 COMMIT; -- 7 | 942067979.217615 - 942067979.219458 | 0.001843 | 34.681457 BEGIN; -- 6 | 942067979.219796 - 942067979.220385 | 0.000589 | 34.682046 DECLARE c_070 CURSOR FOR SELECT "ste", "afd", "dss", "srt", "oma", "omb", "omc", "vku", "amv", "con", "fqa", "fqb", "daf","vla", "vlb", "vlc", "vld", "vle", "ref", "dop", "dlv", "tga", "tgb", "dpr", "vwn", "tgc", "dbf", "tgd", "tge", "a1z","a1n", "a11", "a12", "a13", "a14", "a15" FROM obdtr WHERE ( "ste" = 11012 ) ; -- 323 | 942067979.220540 - 942067979.225083 | 0.004543 | 34.686589 FETCH 1 IN c_070; -- 17 | 942067979.225210 - 942067979.227433 | 0.002223 | 34.688812 CLOSE c_070; -- 12 | 942067979.227674 - 942067979.228349 | 0.000675 | 34.689487 COMMIT; -- 7 | 942067979.228634 - 942067979.229213 | 0.000579 | 34.690066 BEGIN; -- 6 | 942067979.229304 - 942067979.229829 | 0.000525 | 34.690591 UPDATE obdtr SET "ste" = 11012, "afd" = 'fb', "dss" = 77, "srt" = 'VP', "oma" = 'op 1 januari 1998.', "omb" ='2 personen van 00:00 uur tot 08:00 uur a fl. 89,50.', "omc" = '', "vku" = 0.0, "amv" = 0.00, "con" = 'groepsleider',"fqa" = 0, "fqb" = 0, "daf" = '1998010113485600', "vla" = 0, "vlb" = 0, "vlc" = 0, "vld"= 0, "vle" = 520, "ref" = '', "dop" = '19980114134856', "dlv" = '19980114134856', "tga" = 0, "tgb" = 0, "dpr" = '0000000000000000', "vwn" = '', "tgc" = 0, "dbf" = '0000000000000000', "tgd" = 0, "tge"= 0, "a1z" = '', "a1n" = 0, "a11" = '', "a12" = '', "a13" = '', "a14" = '', "a15" = '' WHERE ( "ste" = 11012 ) ; -- 718 | 942067979.230853 - 942067979.340244 | 0.109391 | 34.799982 COMMIT; -- 7 | 942067979.340380 - 942067979.348796 | 0.008416 | 34.808398 BEGIN; -- 6 | 942067979.349147 - 942067979.349749 | 0.000602 | 34.809000 DECLARE c_071 CURSOR FOR SELECT "ste", "afd", "dss", "srt", "oma", "omb", "omc", "vku", "amv", "con", "fqa", "fqb", "daf","vla", "vlb", "vlc", "vld", "vle", "ref", "dop", "dlv", "tga", "tgb", "dpr", "vwn", "tgc", "dbf", "tgd", "tge", "a1z","a1n", "a11", "a12", "a13", "a14", "a15" FROM obdtr WHERE ( "ste" = 11012 ) ; -- 323 | 942067979.349906 - 942067979.354375 | 0.004469 | 34.813469 FETCH 1 IN c_071; -- 17 | 942067979.354500 - 942067979.356248 | 0.001748 | 34.815217 DECLARE c_072 CURSOR FOR SELECT "pln", "ste", "afd", "dss", "oms", "std", "end", "vla", "vlb", "vlc", "vld", "vle" FROM plkopWHERE ( "pln" = 520 ) ; -- 155 | 942067979.356724 - 942067979.450560 | 0.093836 | 34.909053 FETCH 1 IN c_072; -- 17 | 942067979.450693 - 942067979.485086 | 0.034393 | 34.943446 DECLARE mycursor CURSOR FOR SELECT "pln", "rgl", "snr", "niv", "ste", "afd", "dss", "oms", "std", "end", "frq", "frs", "wma","wdi", "wwo", "wdo", "wvr", "wza", "wzo", "mns", "tyd", "vla", "vlb", "vlc", "vld", "vle" FROM plrgl WHERE ( "pln"= 520 and "rgl" = 0 and "snr" = 0 and "niv" >= 0 ) or ( "pln" = 520 and "rgl" = 0 and "snr"> 0 ) or ( "pln" = 520 and "rgl" > 0 ) or ( "pln" > 520 ) ORDER BY "pln" ASC , "rgl" ASC ,"snr" ASC , "niv" ASC ; -- 499 | 942067985.803581 - 942067985.898486 | 0.094905 | 35.038351 FETCH 5 in mycursor; -- 20 | 942067985.898640 - 942067986.031992 | 0.133352 | 35.171703 CLOSE c_071; -- 12 | 942067990.502407 - 942067990.503110 | 0.000703 | 35.172406 CLOSE c_072; -- 12 | 942067990.503232 - 942067990.503952 | 0.000720 | 35.173126 COMMIT; NOTICE: Buffer Leak: [032] (freeNext=-3, freePrev=-3, relname=plkop_primary, blockNum=1, flags=0x4, refcount=1 1) NOTICE: Buffer Leak: [057] (freeNext=-3, freePrev=-3, relname=plkop, blockNum=7, flags=0x4, refcount=1 1) -- 7 | 942067990.504056 - 942067990.505499 | 0.001443 | 35.174569 BEGIN; -- 6 | 942067990.515930 - 942067990.516560 | 0.000630 | 35.175199 DECLARE mycursor CURSOR FOR SELECT "pln", "rgl", "snr", "zkn", "niv", "ste", "afd", "dss", "std", "end", "frq", "frs", "wma","wdi", "wwo", "wdo", "wvr", "wza", "wzo", "tyd", "uus", "vla", "vlb", "vlc", "vld", "vle" FROM plrgw WHERE ( "pln"= 520 and "rgl" = 1 and "snr" = 0 and "zkn" = '' and "niv" >= 0 ) or ( "pln" = 520 and "rgl"= 1 and "snr" = 0 and "zkn" > '' ) or ( "pln" = 520 and "rgl" = 1 and "snr" > 0 ) or ( "pln"= 520 and "rgl" > 1 ) or ( "pln" > 520 ) ORDER BY "pln" ASC , "rgl" ASC , "snr" ASC , "zkn" ASC , "niv"ASC ; -- 605 | 942067990.517028 - 942067991.135802 | 0.618774 | 35.793973 FETCH 8 in mycursor; -- 20 | 942067991.135966 - 942067991.698780 | 0.562814 | 36.356787 COMMIT; -- 7 | 942068001.412908 - 942068001.415601 | 0.002693 | 36.359480 BEGIN; -- 6 | 942068002.413115 - 942068002.413956 | 0.000841 | 36.360321 DECLARE mycursor CURSOR FOR SELECT "pln", "rgl", "snr", "zkn", "niv", "ste", "afd", "dss", "std", "end", "frq", "frs", "wma","wdi", "wwo", "wdo", "wvr", "wza", "wzo", "tyd", "uus", "vla", "vlb", "vlc", "vld", "vle" FROM plrgw WHERE ( "pln"= 520 and "rgl" = 1 and "snr" = 0 and "zkn" = '' and "niv" >= 0 ) or ( "pln" = 520 and "rgl"= 1 and "snr" = 0 and "zkn" > '' ) or ( "pln" = 520 and "rgl" = 1 and "snr" > 0 ) or ( "pln"= 520 and "rgl" > 1 ) or ( "pln" > 520 ) ORDER BY "pln" ASC , "rgl" ASC , "snr" ASC , "zkn" ASC , "niv"ASC ; -- 605 | 942068002.414439 - 942068002.807903 | 0.393464 | 36.753785 FETCH 8 in mycursor; -- 20 | 942068002.808062 - 942068003.145200 | 0.337138 | 37.090923 COMMIT; -- 7 | 942068003.812559 - 942068003.815264 | 0.002705 | 37.093628 BEGIN; -- 6 | 942068011.314002 - 942068011.314922 | 0.000920 | 37.094548 DECLARE mycursor CURSOR FOR SELECT "snr", "zkn", "niv", "std", "end", "reg", "vla", "vlb", "vlc", "vld", "vle", "vlf", "vlg","vlh", "vli", "vlj" FROM plwnp WHERE ( "zkn" = 'DENEE' and "snr" >= 0 ) or ( "zkn" > 'DENEE' ) ORDER BY "zkn"ASC , "snr" ASC ; -- 263 | 942068011.315149 - 942068011.365929 | 0.050780 | 37.145328 FETCH 7 in mycursor; -- 20 | 942068011.366063 - 942068011.489367 | 0.123304 | 37.268632 COMMIT; -- 7 | 942068021.501069 - 942068021.505709 | 0.004640 | 37.273272
В списке pgsql-bugs по дате отправления: