Le 13/10/2023 à 15:12, MichaelDBA a
écrit :
Turn off the OOM killer so you would get a nicer me ssage in PG log file instead of crashing the PG service.
Did this and now the process dies much quicker (without seemingly consume all the available memory)... Also I can not launch thunderbird anymore with this setting...
Anyway, I also reduced work_mem to 128Mb
You can find the corresponding logs attached.
Thanks for your help,
JC
--
|
Jean-Christophe Boggio Independant consultant and developer Office : +33 2 46 65 56 96 Mobile : +33 6 60 70 83 70 |
 |
104bis rue Avisseau 37000 Tours France |
2023-10-13 15:30:04.282 CEST [13487] cat@inpro_mymajor LOG: duration: 0.028 ms parse PRSTMTST24341012810: SELECT processdecomptesNew($1, $2, $3, $4, $5)
2023-10-13 15:30:04.282 CEST [13487] cat@inpro_mymajor LOG: duration: 0.018 ms parse PRSTMTST24341012811: SELECT processdecomptesNew($1, $2, $3, $4, $5)
2023-10-13 15:30:04.286 CEST [13487] cat@inpro_mymajor LOG: duration: 3.999 ms bind PRSTMTST24341012811/PORTALST24341012811: SELECT processdecomptesNew($1, $2, $3, $4, $5)
2023-10-13 15:30:04.286 CEST [13487] cat@inpro_mymajor DETAIL: parameters: $1 = '{111,486,203,250,55,129,136,306,143,349,105,66,420,88,72,319,82,15,262,183,280,106,76,36,357,181,57,348,307,48,31,124,80,69,147,70,75,210,26,332,426,102,7,11,466,84,196,425,417,455,138,132,100,388,465,123,85,191,101,109,16,391,44,117,404,128,254,338,51,199,54,90,477,424,32,194,207,130,83,202,359,164,64,472,38,344,118,189,467,89,396,18,474,146,40,206,317,483,398,65,184,53,13,428,167,176,25,331,192,448,169,23,17,437,419,435,46,163,151,454,24,154,81,457,93,162,479,481,453,471,120,174,452,113,484,247,303,438,480,127,334,257,188,201,39,150,468,119,68,121,485,177,178,45,318,122,462,309,153,249,393,337,87,469,310,173,135,58,304,104,326,145,71,311,74,330,395,97,133,433,473,131,140,20,251,94,142,487,347,459,422,470,99,52,482,444,445,302,394,21,61,256,96,60,103,360,190,148,458,50,361,362,86,305,172,193,451,321,42,73,440,62,95,19,463,351,22,166,423,489,261,168,112,363,34,343,180,170,6,152,29,43,399,98,160,333,107,211,116,134,335,30,392,212,139,259,108,63,312,12,141,114,78,208,258,478,436,175,165,456,27,47,56,447,37,79,255,115,49,144,313,430,418,461,35,33,41,125,149,204,439,253,252,464,137,182}', $2 = '{}', $3 = 't', $4 = '2022-07-01', $5 = '2022-12-31'
TopMemoryContext: 207592 total in 10 blocks; 35256 free (18 chunks); 172336 used
TopTransactionContext: 537144 total in 8 blocks; 238080 free (20 chunks); 299064 used
SPI Exec: 75563064 total in 20 blocks; 2999368 free (8 chunks); 72563696 used
ExecutorState: 63715808 total in 35 blocks; 6377320 free (39 chunks); 57338488 used
TupleSort main: 8192 total in 1 blocks; 6888 free (0 chunks); 1304 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6808 free (0 chunks); 26016 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
137071 more child contexts containing 6743479840 total in 540511 blocks; 3048645288 free (68 chunks); 3694834552 used
JoinRelHashTable: 16384 total in 2 blocks; 7648 free (1 chunks); 8736 used
SPI Proc: 380344 total in 6 blocks; 63832 free (24 chunks); 316512 used
expanded record: 8192 total in 1 blocks; 7048 free (6 chunks); 1144 used
PLpgSQL per-statement data: 170600 total in 2 blocks; 7928 free (0 chunks); 162672 used
Combo CIDs: 65536 total in 4 blocks; 23488 free (9 chunks); 42048 used
AfterTriggerEvents: 24576 total in 2 blocks; 24272 free (7 chunks); 304 used
ExecutorState: 524288 total in 7 blocks; 139144 free (7 chunks); 385144 used
ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
SQL function: 81976 total in 5 blocks; 5240 free (4 chunks); 76736 used: jsonb_delete_left
SQL function: 81976 total in 5 blocks; 5240 free (6 chunks); 76736 used: jsonb_delete_left
SQL function: 81976 total in 5 blocks; 5240 free (6 chunks); 76736 used: jsonb_delete_left
ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
SPI Exec: 16384 total in 2 blocks; 4920 free (0 chunks); 11464 used
ExecutorState: 8192 total in 1 blocks; 3952 free (0 chunks); 4240 used
ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
SPI Proc: 8192 total in 1 blocks; 7240 free (0 chunks); 952 used
SPI TupTable: 8192 total in 1 blocks; 6536 free (0 chunks); 1656 used
PLpgSQL per-statement data: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
pgstat TabStatusArray lookup hash table: 16384 total in 2 blocks; 4400 free (3 chunks); 11984 used
PL/pgSQL function: 32768 total in 3 blocks; 10968 free (1 chunks); 21800 used: dcbiw_helper(text,text,text,text,text)
PL/pgSQL function: 131072 total in 5 blocks; 41952 free (1 chunks); 89120 used: dynamiccondition_byid_where(integer)
Attopt cache: 8192 total in 1 blocks; 1576 free (0 chunks); 6616 used
LocalBufferContext: 4071704 total in 6 blocks; 7928 free (0 chunks); 4063776 used
Local Buffer Lookup Table: 1048576 total in 8 blocks; 508144 free (28 chunks); 540432 used
PL/pgSQL function: 272336 total in 7 blocks; 106112 free (5 chunks); 166224 used: prepstatement(text,text,boolean,date,date)
PL/pgSQL function: 65536 total in 4 blocks; 29024 free (2 chunks); 36512 used: audit.if_modified_func()
PL/pgSQL function: 65536 total in 4 blocks; 28992 free (2 chunks); 36544 used: audit.if_modified_func()
PL/pgSQL function: 65536 total in 4 blocks; 28896 free (2 chunks); 36640 used: audit.if_modified_func()
Sequence values: 8192 total in 1 blocks; 1576 free (0 chunks); 6616 used
Record information cache: 8192 total in 1 blocks; 1576 free (0 chunks); 6616 used
Operator lookup cache: 40960 total in 3 blocks; 18888 free (10 chunks); 22072 used
Type information cache: 24376 total in 2 blocks; 2616 free (0 chunks); 21760 used
PL/pgSQL function: 65536 total in 4 blocks; 28992 free (4 chunks); 36544 used: audit.if_modified_func()
RI compare cache: 16384 total in 2 blocks; 6656 free (3 chunks); 9728 used
RI query cache: 8192 total in 1 blocks; 1576 free (0 chunks); 6616 used
RI constraint cache: 40648 total in 2 blocks; 2616 free (0 chunks); 38032 used
PL/pgSQL function: 65536 total in 4 blocks; 24296 free (3 chunks); 41240 used: createconditions()
PL/pgSQL function: 8192 total in 1 blocks; 3160 free (1 chunks); 5032 used: setrole(text)
PLpgSQL cast info: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
PLpgSQL cast cache: 8192 total in 1 blocks; 1576 free (0 chunks); 6616 used
PL/pgSQL function: 131072 total in 5 blocks; 53376 free (4 chunks); 77696 used: processdecomptesnew(text,text,boolean,date,date)
CFuncHash: 8192 total in 1 blocks; 552 free (0 chunks); 7640 used
Rendezvous variable hash: 8192 total in 1 blocks; 552 free (0 chunks); 7640 used
PLpgSQL function hash: 24528 total in 2 blocks; 2616 free (0 chunks); 21912 used
TableSpace cache: 8192 total in 1 blocks; 2088 free (0 chunks); 6104 used
Prepared Queries: 16384 total in 2 blocks; 6656 free (3 chunks); 9728 used
RowDescriptionContext: 8192 total in 1 blocks; 6888 free (0 chunks); 1304 used
MessageContext: 8192 total in 1 blocks; 6616 free (0 chunks); 1576 used
Operator class cache: 8192 total in 1 blocks; 552 free (0 chunks); 7640 used
smgr relation table: 65536 total in 4 blocks; 28992 free (14 chunks); 36544 used
TransactionAbortContext: 32768 total in 1 blocks; 32504 free (0 chunks); 264 used
Portal hash: 8192 total in 1 blocks; 552 free (0 chunks); 7640 used
TopPortalContext: 8192 total in 1 blocks; 7656 free (2 chunks); 536 used
PortalContext: 2184 total in 2 blocks; 168 free (0 chunks); 2016 used: PORTALST24341012811
ExecutorState: 8192 total in 1 blocks; 2912 free (0 chunks); 5280 used
printtup: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Relcache by OID: 32768 total in 3 blocks; 15688 free (6 chunks); 17080 used
CacheMemoryContext: 2137568 total in 13 blocks; 235488 free (10 chunks); 1902080 used
index info: 2048 total in 2 blocks; 528 free (1 chunks); 1520 used: pg_toast_1884171_index
CachedPlan: 2048 total in 2 blocks; 592 free (0 chunks); 1456 used: FinalSql
CachedPlan: 2048 total in 2 blocks; 592 free (0 chunks); 1456 used: FinalSQL
CachedPlan: 34768 total in 6 blocks; 6488 free (5 chunks); 28280 used: FinalSql := ' CREATE TEMP TABLE ventesparcondition AS WITH calcdealamont AS ( SELECT ts.idsu...
CachedPlan: 2048 total in 2 blocks; 176 free (1 chunks); 1872 used: clock_timestamp()-startat
CachedPlan: 2048 total in 2 blocks; 176 free (1 chunks); 1872 used: clock_timestamp()-startat
CachedPlan: 2048 total in 2 blocks; 152 free (0 chunks); 1896 used: TRIM(WhereClause)=''
CachedPlan: 2048 total in 2 blocks; 560 free (0 chunks); 1488 used: poids := 2000
CachedPlan: 2048 total in 2 blocks; 336 free (1 chunks); 1712 used: res_poids := res_poids - 400
CachedPlan: 2048 total in 2 blocks; 336 free (1 chunks); 1712 used: res_poids := res_poids - 2000
CachedPlan: 2048 total in 2 blocks; 560 free (0 chunks); 1488 used: poids:=10000
CachedPlan: 2048 total in 2 blocks; 520 free (0 chunks); 1528 used: addprefix := 't1.'
CachedExpression: 1024 total in 1 blocks; 488 free (0 chunks); 536 used
CachedPlan: 2048 total in 2 blocks; 528 free (0 chunks); 1520 used: WhereClause IS NULL
CachedPlan: 8192 total in 4 blocks; 3896 free (1 chunks); 4296 used: WhereClause := WhereClause || ' WHEN ( cv.iddyncondition = ' || eachcond.iddyncondition ||...
CachedPlan: 2048 total in 2 blocks; 416 free (1 chunks); 1632 used: SELECT conditions,res_poids
CachedPlan: 2048 total in 2 blocks; 96 free (1 chunks); 1952 used: NOT foundfieldnames @> ARRAY['idtypedistributeur']
CachedPlan: 2048 total in 2 blocks; 96 free (1 chunks); 1952 used: NOT foundfieldnames @> ARRAY['idpays']
CachedPlan: 2048 total in 2 blocks; 336 free (1 chunks); 1712 used: res_poids := res_poids - 10000
CachedPlan: 2048 total in 2 blocks; 96 free (1 chunks); 1952 used: NOT foundfieldnames @> ARRAY['iddistributeur']
CachedPlan: 4096 total in 3 blocks; 1232 free (0 chunks); 2864 used: expression := '(ABS( COALESCE(NULLIF(t1.ppd,0),t1.montant/CASE WHEN t1.qte=0 THEN 1 ELSE t1.qte END)...
CachedPlan: 2048 total in 2 blocks; 272 free (1 chunks); 1776 used: conditions := conditions || ' AND '
CachedPlan: 2048 total in 2 blocks; 328 free (0 chunks); 1720 used: c := c || ')'
CachedPlan: 2048 total in 2 blocks; 64 free (1 chunks); 1984 used: UPPER(lcondop) IN ('BETWEEN','NOT BETWEEN')
CachedPlan: 2048 total in 2 blocks; 608 free (0 chunks); 1440 used: doquote
CachedPlan: 2048 total in 2 blocks; 176 free (1 chunks); 1872 used: c := c || TRIM(eachfield.value1)
CachedPlan: 2048 total in 2 blocks; 608 free (0 chunks); 1440 used: doquote
CachedPlan: 2048 total in 2 blocks; 528 free (0 chunks); 1520 used: eachfield.value1 IS NOT NULL
CachedPlan: 2048 total in 2 blocks; 224 free (1 chunks); 1824 used: lcondop NOT IN ('IS NULL','IS NOT NULL')
CachedPlan: 2048 total in 2 blocks; 256 free (1 chunks); 1792 used: lcondop IN ('IN','NOT IN')
CachedPlan: 4096 total in 3 blocks; 1280 free (0 chunks); 2816 used: c := '('|| addprefix || eachfield.fieldname || ' ' || lcondop || ' '
CachedPlan: 2048 total in 2 blocks; 528 free (0 chunks); 1520 used: eachfield.nullvalue IS NULL
CachedPlan: 2048 total in 2 blocks; 536 free (0 chunks); 1512 used: addprefix := ''
CachedPlan: 4096 total in 3 blocks; 984 free (0 chunks); 3112 used: POSITION('t1.' IN LOWER(eachfield.fieldname))=0 AND POSITION('(' IN LOWER(eachfield.fieldname))=0
CachedPlan: 2048 total in 2 blocks; 584 free (0 chunks); 1464 used: lcondop := eachfield.condop
CachedPlan: 2048 total in 2 blocks; 40 free (0 chunks); 2008 used: POSITION(',' IN eachfield.value1)>0
CachedPlan: 2048 total in 2 blocks; 160 free (1 chunks); 1888 used: doquote := ftype IN ('text','varchar','date','timestamp')
CachedExpression: 1024 total in 1 blocks; 600 free (0 chunks); 424 used
CachedPlan: 262144 total in 9 blocks; 110176 free (0 chunks); 151968 used: SELECT udt_name FROM information_schema.columns WHERE table_schema ILIKE 'pub...
CachedPlan: 2048 total in 2 blocks; 304 free (0 chunks); 1744 used: fieldname := 'COALESCE(es.forcediddistributeurcoffret,COALESCE(t1.idtypedistributeur,dist.idtypedist...
CachedPlan: 2048 total in 2 blocks; 256 free (1 chunks); 1792 used: fieldname ILIKE 'idtypedistributeur'
CachedPlan: 4096 total in 3 blocks; 1840 free (1 chunks); 2256 used: fieldname ILIKE 'ppd' AND condop = 'BETWEEN'
CachedPlan: 2048 total in 2 blocks; 560 free (0 chunks); 1488 used: poids := 200
CachedPlan: 2048 total in 2 blocks; 544 free (1 chunks); 1504 used: value1 IS NULL
CachedPlan: 2048 total in 2 blocks; 288 free (1 chunks); 1760 used: fieldname='idtypedistributeur'
CachedPlan: 2048 total in 2 blocks; 368 free (1 chunks); 1680 used: conditions := conditions || c
CachedPlan: 2048 total in 2 blocks; 328 free (0 chunks); 1720 used: conditions<>''
CachedPlan: 2048 total in 2 blocks; 592 free (0 chunks); 1456 used: c := expression
CachedPlan: 2048 total in 2 blocks; 528 free (0 chunks); 1520 used: expression IS NOT NULL
CachedPlan: 2048 total in 2 blocks; 144 free (0 chunks); 1904 used: foundfieldnames := foundfieldnames || ARRAY[eachfield.originalfieldname]
CachedPlan: 2048 total in 2 blocks; 96 free (1 chunks); 1952 used: res_poids := res_poids + poids + 1
CachedPlan: 4096 total in 3 blocks; 1840 free (1 chunks); 2256 used: expression := 't1.idpays IN ( SELECT idpays FROM paysingdp WHERE idgroupedepays=' || value1 || ' )'
CachedPlan: 4096 total in 3 blocks; 1504 free (0 chunks); 2592 used: fieldname ILIKE 'idpays' AND condop='=' AND value1::INT>=10000
CachedPlan: 8192 total in 4 blocks; 3152 free (0 chunks); 5040 used: poids := 1000+200-(SELECT COUNT(*) FROM paysingdp WHERE idgroupedepays=value1::INT)
CachedPlan: 2048 total in 2 blocks; 288 free (1 chunks); 1760 used: value1::INT >= 10000
CachedPlan: 2048 total in 2 blocks; 544 free (1 chunks); 1504 used: value1 IS NULL
CachedPlan: 2048 total in 2 blocks; 304 free (1 chunks); 1744 used: fieldname='idpays'
CachedPlan: 2048 total in 2 blocks; 288 free (1 chunks); 1760 used: fieldname='iddistributeur'
CachedPlan: 2048 total in 2 blocks; 560 free (0 chunks); 1488 used: poids := 0
CachedPlan: 2048 total in 2 blocks; 128 free (0 chunks); 1920 used: value1 := NULLIF(TRIM(value1),'')
CachedPlan: 4096 total in 3 blocks; 40 free (0 chunks); 4056 used: SELECT * FROM dcbiw_helper(eachfield.fieldname,eachfield.condop,eachfield.value1,eachfield.value2,ea...
CachedPlan: 8192 total in 4 blocks; 1936 free (0 chunks); 6256 used: SELECT fieldname,fieldname AS originalfieldname,condop ,REGEXP_REPLACE(value1,'[\n\r]','','...
CachedPlan: 2048 total in 2 blocks; 488 free (0 chunks); 1560 used: foundfieldnames := ARRAY[]::TEXT[]
CachedPlan: 2048 total in 2 blocks; 560 free (0 chunks); 1488 used: res_poids := 0
CachedPlan: 2048 total in 2 blocks; 520 free (0 chunks); 1528 used: conditions := ''
CachedPlan: 2048 total in 2 blocks; 544 free (1 chunks); 1504 used: pkey IS NULL
CachedPlan: 4096 total in 3 blocks; 776 free (0 chunks); 3320 used: SELECT primarykey,tablename,name FROM dynconditions WHERE iddyncondi...
CachedPlan: 32768 total in 6 blocks; 14792 free (0 chunks); 17976 used: SELECT iddyncondition, wc_sql, wc_poids FROM dynconditions dc CROSS JOIN dynamiccondition_byid...
CachedPlan: 2048 total in 2 blocks; 520 free (0 chunks); 1528 used: WhereClause := ''
CachedPlan: 2048 total in 2 blocks; 176 free (1 chunks); 1872 used: clock_timestamp()-startat
index info: 2048 total in 2 blocks; 824 free (0 chunks); 1224 used: ix_tmp_supportstitres_idcontrat
index info: 2048 total in 2 blocks; 448 free (1 chunks); 1600 used: ix_tmp_supportstitres_idtitre
index info: 2048 total in 2 blocks; 448 free (1 chunks); 1600 used: ix_tmp_supportstitres_idsupport
index info: 2048 total in 2 blocks; 528 free (1 chunks); 1520 used: pg_toast_1884155_index
CachedPlan: 2048 total in 2 blocks; 176 free (1 chunks); 1872 used: clock_timestamp()-startat
index info: 2048 total in 2 blocks; 840 free (0 chunks); 1208 used: ix_tmp_extsup
index info: 2048 total in 2 blocks; 528 free (1 chunks); 1520 used: pg_toast_1884146_index
CachedPlan: 66560 total in 7 blocks; 23080 free (0 chunks); 43480 used: CREATE TEMP TABLE tmp_extsup AS WITH precoffrets AS ( SELECT idcoffret, SUM(COALESCE(coeffcoffr...
CachedPlan: 2048 total in 2 blocks; 176 free (1 chunks); 1872 used: clock_timestamp()-startat
CachedPlan: 2048 total in 2 blocks; 384 free (1 chunks); 1664 used: startat := clock_timestamp()
CachedPlan: 8192 total in 4 blocks; 1392 free (0 chunks); 6800 used: (SELECT TauxPDetail FROM config)
CachedExpression: 1024 total in 1 blocks; 248 free (0 chunks); 776 used
CachedPlan: 8192 total in 4 blocks; 1424 free (1 chunks); 6768 used: (SELECT TauxGSDRM FROM config)
CachedPlan: 6144 total in 3 blocks; 1824 free (1 chunks); 4320 used: SELECT prepstatement( pidbeneficiaires, pidcontrats, pforcedatedebut, pdatemin, pdatemax)
CachedPlan: 2048 total in 2 blocks; 568 free (0 chunks); 1480 used: NULL
CachedPlan: 2048 total in 2 blocks; 312 free (0 chunks); 1736 used: audit_row.changed_fields = '{}'
CachedPlan: 4096 total in 3 blocks; 1944 free (0 chunks); 2152 used: audit_row.changed_fields = public.jsonb_delete_left( row_to_json(NEW.*)::jsonb , audit_row.row_data...
CachedPlan: 2048 total in 2 blocks; 336 free (1 chunks); 1712 used: audit_row.row_data = row_to_json(OLD.*)::jsonb
CachedPlan: 4096 total in 3 blocks; 1840 free (1 chunks); 2256 used: (TG_OP = 'UPDATE' AND TG_LEVEL = 'ROW')
CachedPlan: 4096 total in 3 blocks; 1896 free (2 chunks); 2200 used: NOT TG_ARGV[0]::boolean IS DISTINCT FROM 'f'::boolean
CachedPlan: 11264 total in 4 blocks; 3736 free (1 chunks); 7528 used: audit_row = ROW( nextval('audit.logs_event_id_seq'), -- event_id TG_TABLE_SCHEMA::text, ...
CachedPlan: 2048 total in 2 blocks; 304 free (1 chunks); 1744 used: TG_WHEN <> 'AFTER'
CachedPlan: 2048 total in 2 blocks; 328 free (0 chunks); 1720 used: skipaudit <> ''
CachedPlan: 2048 total in 2 blocks; 224 free (1 chunks); 1824 used: current_setting('myvars.skipaudit',TRUE)
CachedPlan: 16384 total in 5 blocks; 6560 free (0 chunks); 9824 used: WITH precalc AS ( SELECT idgroupedepays,count(*) cnt FROM paysingdp GROUP BY idgroupedepays...
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: tmpbenef_pkey
index info: 2048 total in 2 blocks; 528 free (1 chunks); 1520 used: pg_toast_1884136_index
index info: 2048 total in 2 blocks; 824 free (0 chunks); 1224 used: tmplistebenefs_pkey
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: tmpven_pkey
index info: 2048 total in 2 blocks; 528 free (1 chunks); 1520 used: pg_toast_1884116_index
670 more child contexts containing 3602136 total in 1838 blocks; 1024536 free (306 chunks); 2577600 used
WAL record construction: 49768 total in 2 blocks; 6360 free (0 chunks); 43408 used
PrivateRefCount: 8192 total in 1 blocks; 1576 free (0 chunks); 6616 used
MdSmgr: 8192 total in 1 blocks; 4304 free (3 chunks); 3888 used
LOCALLOCK hash: 65536 total in 4 blocks; 37216 free (14 chunks); 28320 used
Timezones: 104120 total in 2 blocks; 2616 free (0 chunks); 101504 used
ErrorContext: 8192 total in 1 blocks; 7928 free (8 chunks); 264 used
Grand total: 6903039152 bytes in 543234 blocks; 3063497704 free (711 chunks); 3839541448 used
TopMemoryContext: 207592 total in 10 blocks; 35256 free (18 chunks); 172336 used
TopTransactionContext: 537144 total in 8 blocks; 238080 free (20 chunks); 299064 used
SPI Exec: 75563064 total in 20 blocks; 2999368 free (8 chunks); 72563696 used
ExecutorState: 63715808 total in 35 blocks; 6377320 free (39 chunks); 57338488 used
TupleSort main: 8192 total in 1 blocks; 6888 free (0 chunks); 1304 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6808 free (0 chunks); 26016 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
TupleSort main: 32824 total in 2 blocks; 6744 free (0 chunks); 26080 used
TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Caller tuples: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
137071 more child contexts containing 6743479840 total in 540511 blocks; 3048645288 free (68 chunks); 3694834552 used
JoinRelHashTable: 16384 total in 2 blocks; 7648 free (1 chunks); 8736 used
SPI Proc: 380344 total in 6 blocks; 63832 free (24 chunks); 316512 used
expanded record: 8192 total in 1 blocks; 7048 free (6 chunks); 1144 used
PLpgSQL per-statement data: 170600 total in 2 blocks; 7928 free (0 chunks); 162672 used
Combo CIDs: 65536 total in 4 blocks; 23488 free (9 chunks); 42048 used
AfterTriggerEvents: 24576 total in 2 blocks; 24272 free (7 chunks); 304 used
ExecutorState: 524288 total in 7 blocks; 139144 free (7 chunks); 385144 used
ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
SQL function: 81976 total in 5 blocks; 5240 free (4 chunks); 76736 used: jsonb_delete_left
SQL function: 81976 total in 5 blocks; 5240 free (6 chunks); 76736 used: jsonb_delete_left
SQL function: 81976 total in 5 blocks; 5240 free (6 chunks); 76736 used: jsonb_delete_left
ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
SPI Exec: 16384 total in 2 blocks; 4920 free (0 chunks); 11464 used
ExecutorState: 8192 total in 1 blocks; 3952 free (0 chunks); 4240 used
ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
SPI Proc: 8192 total in 1 blocks; 7240 free (0 chunks); 952 used
SPI TupTable: 8192 total in 1 blocks; 6536 free (0 chunks); 1656 used
PLpgSQL per-statement data: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
pgstat TabStatusArray lookup hash table: 16384 total in 2 blocks; 4400 free (3 chunks); 11984 used
PL/pgSQL function: 32768 total in 3 blocks; 10968 free (1 chunks); 21800 used: dcbiw_helper(text,text,text,text,text)
PL/pgSQL function: 131072 total in 5 blocks; 41952 free (1 chunks); 89120 used: dynamiccondition_byid_where(integer)
Attopt cache: 8192 total in 1 blocks; 1576 free (0 chunks); 6616 used
LocalBufferContext: 4071704 total in 6 blocks; 7928 free (0 chunks); 4063776 used
Local Buffer Lookup Table: 1048576 total in 8 blocks; 508144 free (28 chunks); 540432 used
PL/pgSQL function: 272336 total in 7 blocks; 106112 free (5 chunks); 166224 used: prepstatement(text,text,boolean,date,date)
PL/pgSQL function: 65536 total in 4 blocks; 29024 free (2 chunks); 36512 used: audit.if_modified_func()
PL/pgSQL function: 65536 total in 4 blocks; 28992 free (2 chunks); 36544 used: audit.if_modified_func()
PL/pgSQL function: 65536 total in 4 blocks; 28896 free (2 chunks); 36640 used: audit.if_modified_func()
Sequence values: 8192 total in 1 blocks; 1576 free (0 chunks); 6616 used
Record information cache: 8192 total in 1 blocks; 1576 free (0 chunks); 6616 used
Operator lookup cache: 40960 total in 3 blocks; 18888 free (10 chunks); 22072 used
Type information cache: 24376 total in 2 blocks; 2616 free (0 chunks); 21760 used
PL/pgSQL function: 65536 total in 4 blocks; 28992 free (4 chunks); 36544 used: audit.if_modified_func()
RI compare cache: 16384 total in 2 blocks; 6656 free (3 chunks); 9728 used
RI query cache: 8192 total in 1 blocks; 1576 free (0 chunks); 6616 used
RI constraint cache: 40648 total in 2 blocks; 2616 free (0 chunks); 38032 used
PL/pgSQL function: 65536 total in 4 blocks; 24296 free (3 chunks); 41240 used: createconditions()
PL/pgSQL function: 8192 total in 1 blocks; 3160 free (1 chunks); 5032 used: setrole(text)
PLpgSQL cast info: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
PLpgSQL cast cache: 8192 total in 1 blocks; 1576 free (0 chunks); 6616 used
PL/pgSQL function: 131072 total in 5 blocks; 53376 free (4 chunks); 77696 used: processdecomptesnew(text,text,boolean,date,date)
CFuncHash: 8192 total in 1 blocks; 552 free (0 chunks); 7640 used
Rendezvous variable hash: 8192 total in 1 blocks; 552 free (0 chunks); 7640 used
PLpgSQL function hash: 24528 total in 2 blocks; 2616 free (0 chunks); 21912 used
TableSpace cache: 8192 total in 1 blocks; 2088 free (0 chunks); 6104 used
Prepared Queries: 16384 total in 2 blocks; 6656 free (3 chunks); 9728 used
RowDescriptionContext: 8192 total in 1 blocks; 6888 free (0 chunks); 1304 used
MessageContext: 8192 total in 1 blocks; 6616 free (0 chunks); 1576 used
Operator class cache: 8192 total in 1 blocks; 552 free (0 chunks); 7640 used
smgr relation table: 65536 total in 4 blocks; 28992 free (14 chunks); 36544 used
TransactionAbortContext: 32768 total in 1 blocks; 32504 free (0 chunks); 264 used
Portal hash: 8192 total in 1 blocks; 552 free (0 chunks); 7640 used
TopPortalContext: 8192 total in 1 blocks; 7656 free (2 chunks); 536 used
PortalContext: 2184 total in 2 blocks; 168 free (0 chunks); 2016 used: PORTALST24341012811
ExecutorState: 8192 total in 1 blocks; 2912 free (0 chunks); 5280 used
printtup: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
Relcache by OID: 32768 total in 3 blocks; 15688 free (6 chunks); 17080 used
CacheMemoryContext: 2137568 total in 13 blocks; 235488 free (10 chunks); 1902080 used
index info: 2048 total in 2 blocks; 528 free (1 chunks); 1520 used: pg_toast_1884171_index
CachedPlan: 2048 total in 2 blocks; 592 free (0 chunks); 1456 used: FinalSql
CachedPlan: 2048 total in 2 blocks; 592 free (0 chunks); 1456 used: FinalSQL
CachedPlan: 34768 total in 6 blocks; 6488 free (5 chunks); 28280 used: FinalSql := ' CREATE TEMP TABLE ventesparcondition AS WITH calcdealamont AS ( SELECT ts.idsu...
CachedPlan: 2048 total in 2 blocks; 176 free (1 chunks); 1872 used: clock_timestamp()-startat
CachedPlan: 2048 total in 2 blocks; 176 free (1 chunks); 1872 used: clock_timestamp()-startat
CachedPlan: 2048 total in 2 blocks; 152 free (0 chunks); 1896 used: TRIM(WhereClause)=''
CachedPlan: 2048 total in 2 blocks; 560 free (0 chunks); 1488 used: poids := 2000
CachedPlan: 2048 total in 2 blocks; 336 free (1 chunks); 1712 used: res_poids := res_poids - 400
CachedPlan: 2048 total in 2 blocks; 336 free (1 chunks); 1712 used: res_poids := res_poids - 2000
CachedPlan: 2048 total in 2 blocks; 560 free (0 chunks); 1488 used: poids:=10000
CachedPlan: 2048 total in 2 blocks; 520 free (0 chunks); 1528 used: addprefix := 't1.'
CachedExpression: 1024 total in 1 blocks; 488 free (0 chunks); 536 used
CachedPlan: 2048 total in 2 blocks; 528 free (0 chunks); 1520 used: WhereClause IS NULL
CachedPlan: 8192 total in 4 blocks; 3896 free (1 chunks); 4296 used: WhereClause := WhereClause || ' WHEN ( cv.iddyncondition = ' || eachcond.iddyncondition ||...
CachedPlan: 2048 total in 2 blocks; 416 free (1 chunks); 1632 used: SELECT conditions,res_poids
CachedPlan: 2048 total in 2 blocks; 96 free (1 chunks); 1952 used: NOT foundfieldnames @> ARRAY['idtypedistributeur']
CachedPlan: 2048 total in 2 blocks; 96 free (1 chunks); 1952 used: NOT foundfieldnames @> ARRAY['idpays']
CachedPlan: 2048 total in 2 blocks; 336 free (1 chunks); 1712 used: res_poids := res_poids - 10000
CachedPlan: 2048 total in 2 blocks; 96 free (1 chunks); 1952 used: NOT foundfieldnames @> ARRAY['iddistributeur']
CachedPlan: 4096 total in 3 blocks; 1232 free (0 chunks); 2864 used: expression := '(ABS( COALESCE(NULLIF(t1.ppd,0),t1.montant/CASE WHEN t1.qte=0 THEN 1 ELSE t1.qte END)...
CachedPlan: 2048 total in 2 blocks; 272 free (1 chunks); 1776 used: conditions := conditions || ' AND '
CachedPlan: 2048 total in 2 blocks; 328 free (0 chunks); 1720 used: c := c || ')'
CachedPlan: 2048 total in 2 blocks; 64 free (1 chunks); 1984 used: UPPER(lcondop) IN ('BETWEEN','NOT BETWEEN')
CachedPlan: 2048 total in 2 blocks; 608 free (0 chunks); 1440 used: doquote
CachedPlan: 2048 total in 2 blocks; 176 free (1 chunks); 1872 used: c := c || TRIM(eachfield.value1)
CachedPlan: 2048 total in 2 blocks; 608 free (0 chunks); 1440 used: doquote
CachedPlan: 2048 total in 2 blocks; 528 free (0 chunks); 1520 used: eachfield.value1 IS NOT NULL
CachedPlan: 2048 total in 2 blocks; 224 free (1 chunks); 1824 used: lcondop NOT IN ('IS NULL','IS NOT NULL')
CachedPlan: 2048 total in 2 blocks; 256 free (1 chunks); 1792 used: lcondop IN ('IN','NOT IN')
CachedPlan: 4096 total in 3 blocks; 1280 free (0 chunks); 2816 used: c := '('|| addprefix || eachfield.fieldname || ' ' || lcondop || ' '
CachedPlan: 2048 total in 2 blocks; 528 free (0 chunks); 1520 used: eachfield.nullvalue IS NULL
CachedPlan: 2048 total in 2 blocks; 536 free (0 chunks); 1512 used: addprefix := ''
CachedPlan: 4096 total in 3 blocks; 984 free (0 chunks); 3112 used: POSITION('t1.' IN LOWER(eachfield.fieldname))=0 AND POSITION('(' IN LOWER(eachfield.fieldname))=0
CachedPlan: 2048 total in 2 blocks; 584 free (0 chunks); 1464 used: lcondop := eachfield.condop
CachedPlan: 2048 total in 2 blocks; 40 free (0 chunks); 2008 used: POSITION(',' IN eachfield.value1)>0
CachedPlan: 2048 total in 2 blocks; 160 free (1 chunks); 1888 used: doquote := ftype IN ('text','varchar','date','timestamp')
CachedExpression: 1024 total in 1 blocks; 600 free (0 chunks); 424 used
CachedPlan: 262144 total in 9 blocks; 110176 free (0 chunks); 151968 used: SELECT udt_name FROM information_schema.columns WHERE table_schema ILIKE 'pub...
CachedPlan: 2048 total in 2 blocks; 304 free (0 chunks); 1744 used: fieldname := 'COALESCE(es.forcediddistributeurcoffret,COALESCE(t1.idtypedistributeur,dist.idtypedist...
CachedPlan: 2048 total in 2 blocks; 256 free (1 chunks); 1792 used: fieldname ILIKE 'idtypedistributeur'
CachedPlan: 4096 total in 3 blocks; 1840 free (1 chunks); 2256 used: fieldname ILIKE 'ppd' AND condop = 'BETWEEN'
CachedPlan: 2048 total in 2 blocks; 560 free (0 chunks); 1488 used: poids := 200
CachedPlan: 2048 total in 2 blocks; 544 free (1 chunks); 1504 used: value1 IS NULL
CachedPlan: 2048 total in 2 blocks; 288 free (1 chunks); 1760 used: fieldname='idtypedistributeur'
CachedPlan: 2048 total in 2 blocks; 368 free (1 chunks); 1680 used: conditions := conditions || c
CachedPlan: 2048 total in 2 blocks; 328 free (0 chunks); 1720 used: conditions<>''
CachedPlan: 2048 total in 2 blocks; 592 free (0 chunks); 1456 used: c := expression
CachedPlan: 2048 total in 2 blocks; 528 free (0 chunks); 1520 used: expression IS NOT NULL
CachedPlan: 2048 total in 2 blocks; 144 free (0 chunks); 1904 used: foundfieldnames := foundfieldnames || ARRAY[eachfield.originalfieldname]
CachedPlan: 2048 total in 2 blocks; 96 free (1 chunks); 1952 used: res_poids := res_poids + poids + 1
CachedPlan: 4096 total in 3 blocks; 1840 free (1 chunks); 2256 used: expression := 't1.idpays IN ( SELECT idpays FROM paysingdp WHERE idgroupedepays=' || value1 || ' )'
CachedPlan: 4096 total in 3 blocks; 1504 free (0 chunks); 2592 used: fieldname ILIKE 'idpays' AND condop='=' AND value1::INT>=10000
CachedPlan: 8192 total in 4 blocks; 3152 free (0 chunks); 5040 used: poids := 1000+200-(SELECT COUNT(*) FROM paysingdp WHERE idgroupedepays=value1::INT)
CachedPlan: 2048 total in 2 blocks; 288 free (1 chunks); 1760 used: value1::INT >= 10000
CachedPlan: 2048 total in 2 blocks; 544 free (1 chunks); 1504 used: value1 IS NULL
CachedPlan: 2048 total in 2 blocks; 304 free (1 chunks); 1744 used: fieldname='idpays'
CachedPlan: 2048 total in 2 blocks; 288 free (1 chunks); 1760 used: fieldname='iddistributeur'
CachedPlan: 2048 total in 2 blocks; 560 free (0 chunks); 1488 used: poids := 0
CachedPlan: 2048 total in 2 blocks; 128 free (0 chunks); 1920 used: value1 := NULLIF(TRIM(value1),'')
CachedPlan: 4096 total in 3 blocks; 40 free (0 chunks); 4056 used: SELECT * FROM dcbiw_helper(eachfield.fieldname,eachfield.condop,eachfield.value1,eachfield.value2,ea...
CachedPlan: 8192 total in 4 blocks; 1936 free (0 chunks); 6256 used: SELECT fieldname,fieldname AS originalfieldname,condop ,REGEXP_REPLACE(value1,'[\n\r]','','...
CachedPlan: 2048 total in 2 blocks; 488 free (0 chunks); 1560 used: foundfieldnames := ARRAY[]::TEXT[]
CachedPlan: 2048 total in 2 blocks; 560 free (0 chunks); 1488 used: res_poids := 0
CachedPlan: 2048 total in 2 blocks; 520 free (0 chunks); 1528 used: conditions := ''
CachedPlan: 2048 total in 2 blocks; 544 free (1 chunks); 1504 used: pkey IS NULL
CachedPlan: 4096 total in 3 blocks; 776 free (0 chunks); 3320 used: SELECT primarykey,tablename,name FROM dynconditions WHERE iddyncondi...
CachedPlan: 32768 total in 6 blocks; 14792 free (0 chunks); 17976 used: SELECT iddyncondition, wc_sql, wc_poids FROM dynconditions dc CROSS JOIN dynamiccondition_byid...
CachedPlan: 2048 total in 2 blocks; 520 free (0 chunks); 1528 used: WhereClause := ''
CachedPlan: 2048 total in 2 blocks; 176 free (1 chunks); 1872 used: clock_timestamp()-startat
index info: 2048 total in 2 blocks; 824 free (0 chunks); 1224 used: ix_tmp_supportstitres_idcontrat
index info: 2048 total in 2 blocks; 448 free (1 chunks); 1600 used: ix_tmp_supportstitres_idtitre
index info: 2048 total in 2 blocks; 448 free (1 chunks); 1600 used: ix_tmp_supportstitres_idsupport
index info: 2048 total in 2 blocks; 528 free (1 chunks); 1520 used: pg_toast_1884155_index
CachedPlan: 2048 total in 2 blocks; 176 free (1 chunks); 1872 used: clock_timestamp()-startat
index info: 2048 total in 2 blocks; 840 free (0 chunks); 1208 used: ix_tmp_extsup
index info: 2048 total in 2 blocks; 528 free (1 chunks); 1520 used: pg_toast_1884146_index
CachedPlan: 66560 total in 7 blocks; 23080 free (0 chunks); 43480 used: CREATE TEMP TABLE tmp_extsup AS WITH precoffrets AS ( SELECT idcoffret, SUM(COALESCE(coeffcoffr...
CachedPlan: 2048 total in 2 blocks; 176 free (1 chunks); 1872 used: clock_timestamp()-startat
CachedPlan: 2048 total in 2 blocks; 384 free (1 chunks); 1664 used: startat := clock_timestamp()
CachedPlan: 8192 total in 4 blocks; 1392 free (0 chunks); 6800 used: (SELECT TauxPDetail FROM config)
CachedExpression: 1024 total in 1 blocks; 248 free (0 chunks); 776 used
CachedPlan: 8192 total in 4 blocks; 1424 free (1 chunks); 6768 used: (SELECT TauxGSDRM FROM config)
CachedPlan: 6144 total in 3 blocks; 1824 free (1 chunks); 4320 used: SELECT prepstatement( pidbeneficiaires, pidcontrats, pforcedatedebut, pdatemin, pdatemax)
CachedPlan: 2048 total in 2 blocks; 568 free (0 chunks); 1480 used: NULL
CachedPlan: 2048 total in 2 blocks; 312 free (0 chunks); 1736 used: audit_row.changed_fields = '{}'
CachedPlan: 4096 total in 3 blocks; 1944 free (0 chunks); 2152 used: audit_row.changed_fields = public.jsonb_delete_left( row_to_json(NEW.*)::jsonb , audit_row.row_data...
CachedPlan: 2048 total in 2 blocks; 336 free (1 chunks); 1712 used: audit_row.row_data = row_to_json(OLD.*)::jsonb
CachedPlan: 4096 total in 3 blocks; 1840 free (1 chunks); 2256 used: (TG_OP = 'UPDATE' AND TG_LEVEL = 'ROW')
CachedPlan: 4096 total in 3 blocks; 1896 free (2 chunks); 2200 used: NOT TG_ARGV[0]::boolean IS DISTINCT FROM 'f'::boolean
CachedPlan: 11264 total in 4 blocks; 3736 free (1 chunks); 7528 used: audit_row = ROW( nextval('audit.logs_event_id_seq'), -- event_id TG_TABLE_SCHEMA::text, ...
CachedPlan: 2048 total in 2 blocks; 304 free (1 chunks); 1744 used: TG_WHEN <> 'AFTER'
CachedPlan: 2048 total in 2 blocks; 328 free (0 chunks); 1720 used: skipaudit <> ''
CachedPlan: 2048 total in 2 blocks; 224 free (1 chunks); 1824 used: current_setting('myvars.skipaudit',TRUE)
CachedPlan: 16384 total in 5 blocks; 6560 free (0 chunks); 9824 used: WITH precalc AS ( SELECT idgroupedepays,count(*) cnt FROM paysingdp GROUP BY idgroupedepays...
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: tmpbenef_pkey
index info: 2048 total in 2 blocks; 528 free (1 chunks); 1520 used: pg_toast_1884136_index
index info: 2048 total in 2 blocks; 824 free (0 chunks); 1224 used: tmplistebenefs_pkey
index info: 2048 total in 2 blocks; 920 free (0 chunks); 1128 used: tmpven_pkey
index info: 2048 total in 2 blocks; 528 free (1 chunks); 1520 used: pg_toast_1884116_index
670 more child contexts containing 3602136 total in 1838 blocks; 1024536 free (306 chunks); 2577600 used
WAL record construction: 49768 total in 2 blocks; 6360 free (0 chunks); 43408 used
PrivateRefCount: 8192 total in 1 blocks; 1576 free (0 chunks); 6616 used
MdSmgr: 8192 total in 1 blocks; 4304 free (3 chunks); 3888 used
LOCALLOCK hash: 65536 total in 4 blocks; 37216 free (14 chunks); 28320 used
Timezones: 104120 total in 2 blocks; 2616 free (0 chunks); 101504 used
ErrorContext: 8192 total in 1 blocks; 6712 free (5 chunks); 1480 used
Grand total: 6903039152 bytes in 543234 blocks; 3063496488 free (708 chunks); 3839542664 used
2023-10-13 15:31:18.132 CEST [13487] cat@inpro_mymajor ERROR: out of memory
2023-10-13 15:31:18.132 CEST [13487] cat@inpro_mymajor DETAIL: Failed on request of size 262144 in memory context "ErrorContext".
