explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GZpI : Optimization for: Optimization for: Optimization for: plan #7Omt; plan #USUY; plan #c1oo4

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.185 390.902 ↑ 1.0 1 1

Aggregate (cost=190,684.74..190,684.75 rows=1 width=32) (actual time=390.902..390.902 rows=1 loops=1)

  • Functions: 80
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 6.143 ms, Inlining 0.000 ms, Optimization 1.774 ms, Emission 39.135 ms, Total 47.053 ms
2.          

CTE filtered_pdv

3. 0.225 78.848 ↑ 1.5 132 1

Group (cost=7,690.90..7,693.63 rows=200 width=78) (actual time=78.501..78.848 rows=132 loops=1)

  • Group Key: p_2.code_pdv
4. 1.815 78.623 ↓ 5.1 2,778 1

Sort (cost=7,690.90..7,692.27 rows=546 width=78) (actual time=78.493..78.623 rows=2,778 loops=1)

  • Sort Key: p_2.code_pdv
  • Sort Method: quicksort Memory: 314kB
5. 2.178 76.808 ↓ 5.1 2,778 1

Nested Loop (cost=7,180.88..7,666.08 rows=546 width=78) (actual time=59.571..76.808 rows=2,778 loops=1)

6. 35.547 71.852 ↓ 111.1 2,778 1

Nested Loop (cost=7,180.60..7,643.85 rows=25 width=4) (actual time=59.497..71.852 rows=2,778 loops=1)

7. 5.286 30.749 ↓ 111.1 2,778 1

Bitmap Heap Scan on data_73 d (cost=7,180.18..7,432.85 rows=25 width=8) (actual time=25.587..30.749 rows=2,778 loops=1)

  • Recheck Cond: ((vague = 3) AND (id_readings = ANY ('{1151333,1151334,1151336,1151337,1151338,1151339,1151340,1151341,1151343,1151344,1151345,1151346,1151347,1151349,1151350,1151351,1151352,1151353,1151354,1151355,1152922,1152923,1152924,1152925,1152926,1152927,1152928,1152929,1153651,1153652,1153653,1153654,1153655,1153656,1153657,1153658,1153659,1153660,1153661,1153662,1153663,1153664,1153665,1153666,1153667,1154345,1154346,1154347,1154348,1154349,1154350,1154351,1154353,1154354,1154355,1154356,1154357,1154358,1154359,1154360,1154361,1154362,1154363,1154364,1155701,1155707,1155743,1155757,1155800,1155845,1155865,1155869,1155886,1155892,1155898,1155901,1155912,1155915,1155920,1155924,1155937,1155944,1155966,1155972,1155979,1155984,1155992,1155995,1156003,1156012,1156013,1156025,1156029,1156036,1156039,1156054,1156057,1156091,1156098,1158423,1158424,1158425,1158426,1158427,1161143,1161144,1161145,1161146,1161147,1161148,1161149,1161150,1161151,1161152,1161153,1161154,1161155,1161156,1161157,1161159,1161160,1161161,1161162,1162631,1162632,1162633,1162634,1162635,1163167,1163168,1163169,1163170,1163172,1163173,1163174,1163175,1163176,1163824,1163825,1163828,1163829,1163830,1163831,1163832,1165083,1165088,1165105,1165109,1165121,1165127,1165129,1165133,1165137,1165140,1165147,1165153,1165157,1165162,1165172,1165178,1165186,1165189,1165194,1165210,1165211,1165214,1165227,1165234,1165250,1165252,1165265,1165269,1165301,1165303,1165320,1165371,1165387,1165396,1165398,1165403,1165406,1165418,1165419,1165422,1165428,1167332,1167334,1167335,1168914,1168915,1171479,1171480,1171481,1171483,1171484,1171485,1174551,1174552,1174554,1174555,1174556,1174557,1174558,1174559,1174560,1174562,1174563,1174564,1174565,1174793,1174794,1174795,1174796,1174797,1174819,1174820,1174821,1174822,1174823,1174824,1174825,1174826,1174827,1174828,1174829,1174830,1174831,1174832,1174833,1175119,1175120,1175121,1175122,1175123,1175124,1175125,1175126,1176795,1176803,1176818,1176825,1176835,1176841,1176851,1176887,1176889,1176894,1176904,1176909,1176914,1176928,1176934,1176938,1176943,1176950,1176956,1176970,1176975,1176978,1176984,1176988,1176994,1176999,1177003,1177008,1177012,1177023,1177026,1177441,1177442,1178183,1178184,1178185,1178186,1178187,1178188,1178189,1178190,1178191,1178192,1178193,1178194,1178195,1178196,1178197,1178198,1178199,1178200,1178201,1178202,1178203,1178204,1178205,1178206,1178207,1178208,1178209,1178211,1178212,1178213,1178217,1178218,1178219,1178220,1178221,1178222,1181102,1181118,1181120,1181133,1181137,1181140,1181158,1181159,1181168,1181172,1181176,1181201,1181216,1181223,1181234,1181272,1181288,1181295,1181306,1181331,1181357,1181363,1181376,1181380,1181382,1181383,1181414,1181429,1185039,1185040,1185041,1185042,1185043,1185044,1185045,1185046,1185048,1185049,1185050,1185051,1185052,1185053,1185054,1185055,1185056,1185057,1185059,1185060,1185061,1185062,1185063,1185064,1185065,1185066,1185067,1185068,1185069,1185070,1185071,1185072,1185073,1185074,1185075,1185076,1185078,1185079,1189693,1189695,1189696,1189697,1189699,1189700,1189701,1189702,1189703,1189704,1189705,1189706,1189707,1189708,1189709,1189710,1189711,1189712,1189713,1189714,1189715,1189716,1189864,1189869,1189898,1189900,1189904,1189938,1189945,1189952,1189956,1189969,1189985,1189995,1190005,1190009,1190022,1190026,1190032,1190102,1190107,1190115,1190121,1190128,1190139,1190143,1190151,1190157,1190163,1190169,1190175,1192265,1192267,1192269,1192270,1192271,1192272,1192273,1192274,1195484,1195485,1195486,1195487,1195488,1195490,1195491,1195691,1195692,1195693,1195694,1195695,1195696,1195697,1195699,1195700,1195701,1195702,1195703,1195704,1195705,1195708,1195709,1195710,1195711,1195713,1195714,1195715,1195716,1195718,1195719,1195720,1195721,1195722,1195724,1195725,1195726,1195727,1195728,1195729,1195730,1195731,1195732,1195733,1195734,1195735,1195736,1195737,1195738,1195739,1195740,1195741,1195742,1195743,1195745,1195746,1195747,1195748,1195749,1195750,1195751,1195752,1195753,1195754,1195755,1195756,1195757,1195758,1195759,1195761,1195762,1195763,1195764,1195766,1195767,1195768,1195770,1195771,1195772,1195773,1195774,1195775,1195777,1198444,1198445,1198446,1198447,1198448,1198449,1198450,1198451,1198453,1198454,1198556,1198557,1198558,1198559,1198561,1198562,1198563,1198564,1198566,1198567,1198568,1198569,1198570,1198572,1198573,1199022,1201257,1201258,1201259,1201261,1201262,1201264,1201265,1205881,1205882,1205883,1205884,1205885,1205886,1205887,1205888,1205889,1205890,1210153,1210154,1210155,1210156,1210158,1210159,1210160,1210161,1210162,1210163,1210164,1210165,1210166,1210168,1210169,1210170,1210171,1210172,1210173,1210174,1210175,1215103,1215104,1215221,1215222,1215223,1215225,1215295,1215296,1215297,1215298,1215299,1215300,1215301,1215302,1215303,1215304,1215433,1215434,1215435,1215436,1216464,1216465,1216637,1216638,1216640,1216641,1216642,1216643,1216644,1216645,1216646,1216647,1216649,1216650,1216651,1216652,1216653,1216654,1216655,1216656,1216657,1216658,1216659,1216660,1216661,1221276,1221277,1221278,1221279,1221280,1221281,1221282,1221283,1221284,1223184,1223185,1223186,1223187,1223188,1223189,1223190,1223191,1223193,1223194,1223195,1223196,1223197,1223198,1223199,1223200,1223201,1223202,1223203,1223204,1223205,1223206,1223207,1223209,1223210,1223211,1223212,1223213,1223214,1223215,1224451,1224452,1224453,1224454,1224455,1224457,1224459,1224460,1224462,1224463,1224464,1224465,1224466,1224467,1224468,1224469,1224470,1224472,1224473,1224474,1224475,1224476,1224477,1224478,1224479,1224481,1224482,1225602,1225603,1225604,1225605,1225607,1225608,1225609,1225610,1225611,1225612,1225613,1228305,1228306,1228308,1228696,1228697,1231250,1231251,1231252,1231253,1231254,1231255,1231256,1231257,1231258,1231259,1232249,1232250,1232251,1232252,1232253,1232255,1232256,1232257,1232258,1232259,1232260,1232261,1232262,1232263,1232264,1232265,1232266,1232267,1232268,1232269,1232270,1232271,1232273,1232274,1232275,1232276,1232277,1232278,1232279,1232281,1232282,1232283,1232284,1232285,1232286,1232287,1232288,1232289,1232290,1232291,1232292,1232293,1232294,1232296,1232297,1232298,1232299,1232300,1232301,1232302,1232303,1232304,1232305,1232306,1233380,1233381,1233382,1233383,1233385,1233386,1242291,1242292,1242293,1242294,1242295,1242296,1242297,1242298,1242299,1242301,1242302,1242303,1242304,1242305,1242306,1242309,1242310,1242311,1242312,1242313,1242314,1242315,1242316,1242317,1242318,1242319,1242320,1242321,1242323,1242324,1242325,1242326,1242327,1242328,1242329,1244911,1244912,1244913,1244915,1244916,1244917,1244918,1244919,1244920,1244921,1244922,1244923,1244924,1244925,1244926,1244927,1244928,1244929,1244930,1244931,1244932,1244934,1244935,1244936,1244937,1244938,1244939,1244940,1244941,1244942,1244944,1244945,1244946,1244947,1244948,1244949,1244950,1244951,1244952,1245850,1245851,1245852,1245853,1245855,1245856,1245857,1245858,1245859,1245861,1245862,1245863,1245864,1245865,1245869,1245870,1245871,1245872,1245873,1245874,1245875,1245876,1245877,1245878,1245879,1245880,1245881,1245882,1245884,1245885,1245887,1245888,1245889,1245890,1245891,1246543,1246549,1246555,1246561,1246566,1246578,1246592,1246598,1246607,1246609,1246616,1246629,1246636,1246646,1246652,1246670,1246688,1246722,1246724,1246727,1246733,1246739,1246741,1246746,1246750,1246753,1246759,1246762,1246772,1246780,1247032,1247033,1247034,1247035,1247036,1247037,1247038,1247039,1247040,1247041,1247042,1247045,1247046,1247047,1247048,1247049,1247050,1247051,1247052,1247053,1248010,1248011,1248012,1248014,1248016,1248017,1248018,1248318,1248319,1248320,1248322,1248323,1248324,1248326,1249187,1249188,1249190,1249191,1249192,1249193,1249194,1249195,1249197,1249198,1249199,1249200,1249201,1249202,1249203,1249204,1249205,1249206,1249207,1249209,1249210,1249211,1249212,1249213,1249214,1249215,1249216,1249217,1249218,1249219,1249220,1249221,1249223,1249224,1249225,1249227,1249228,1249229,1249230,1249231,1253852,1253854,1253855,1253856,1253857,1253858,1255161,1255162,1255164,1255165,1255166,1255167,1255168,1255169,1255170,1255171,1255172,1255174,1255175,1255176,1255177,1255178,1255179,1255180,1255181,1255182,1255183,1256039,1256040,1256041,1256042,1256043,1256044,1256045,1256047,1256048,1256049,1256050,1256051,1256052,1256053,1256054,1256055,1256248,1257213,1257214,1257215,1257216,1257217,1257218,1257219,1257220,1257221,1257222,1257223,1257224,1257225,1257226,1257227,1257228,1257229,1257230,1257231,1257232,1257233,1257234,1257235,1257236,1257237,1257238,1257239,1257240,1257241,1257242,1257243,1257244,1257245,1257246,1257247,1257248,1257249,1257250,1257251,1257252,1257253,1257254,1257255,1257256,1257257,1257258,1257259,1257260,1257261,1257262,1257263,1257265,1257266,1257268,1257269,1257270,1257272,1257273,1257274,1257277,1257279,1257280,1257281,1257282,1257283,1257284,1257285,1257286,1257287,1257288,1257289,1257290,1257291,1259560,1259566,1259568,1259574,1259583,1259605,1259607,1259610,1259622,1259716,1259724,1259733,1259744,1259788,1259793,1259799,1259832,1259834,1259842,1259850,1259855,1259863,1259868,1259873,1259881,1259891,1259899,1260434,1260435,1260436,1260437,1260438,1260439,1262051,1262052,1262053,1262054,1262055,1263410,1263411,1266227,1266228,1266229,1266400,1266401,1266403,1266404,1266405,1266406,1266407,1266408,1266409,1266410,1266411,1266412,1266413,1266414,1266415,1266416,1266417,1266418,1266419,1266420,1266422,1266423,1266424,1266425,1266426,1266427,1266428,1266429,1266431,1266432,1266433,1266434,1266435,1266436,1266437,1266438,1266439,1266440,1266441,1266442,1266444,1266445,1266446,1266447,1266448,1266449,1266451,1266452,1266453,1266454,1266455,1266456,1266457,1266458,1266459,1266460,1266461,1266462,1266463,1266464,1266465,1266466,1266467,1266468,1266469,1266470,1266472,1266473,1266474,1266475,1266476,1266477,1266478,1266479,1266480,1266481,1266482,1266483,1266484,1266485,1266486,1266487,1266488,1266489,1266490,1266491,1266493,1266494,1266495,1266496,1266497,1266498,1266499,1266500,1266501,1266502,1266503,1266504,1266505,1266506,1266507,1266508,1266509,1267041,1267042,1267043,1267044,1267045,1268053,1268054,1268055,1268056,1268057,1268058,1268059,1268060,1268061,1268062,1268064,1268065,1268066,1268067,1268068,1268069,1268070,1268071,1268072,1268073,1268074,1269402,1269403,1269404,1269405,1270480,1270481,1270482,1270483,1270484,1270763,1270764,1272441,1272442,1272443,1272445,1272446,1272447,1272448,1272450,1272451,1272452,1272453,1272454,1272455,1272456,1272457,1272458,1272459,1272460,1272461,1272463,1272464,1272753,1275988,1275989,1275990,1275991,1275992,1275993,1275994,1275995,1275996,1275998,1275999,1276000,1276001,1276002,1276003,1276004,1276006,1276007,1276008,1276009,1276010,1276011,1276012,1276013,1276014,1276015,1276016,1276017,1276018,1276019,1276020,1276021,1276022,1276023,1276024,1276025,1276026,1276027,1276029,1276030,1276031,1276032,1276033,1276034,1276035,1276036,1276037,1276038,1280583,1280584,1280585,1280586,1281184,1281232,1281428,1281542,1281572,1281646,1281681,1281726,1281775,1281809,1281959,1282001,1282090,1282233,1282304,1282305,1282306,1282307,1282308,1282309,1282310,1282311,1282312,1282314,1282315,1282316,1282317,1282318,1282319,1282320,1282321,1282322,1282323,1282324,1282326,1282327,1282328,1282329,1282330,1282331,1282332,1282333,1282334,1282335,1282336,1282337,1282338,1282339,1282340,1282341,1282342,1282344,1282345,1282346,1282348,1282349,1282350,1282351,1282352,1282354,1282355,1282356,1282357,1282358,1282359,1282360,1282361,1282362,1282363,1282420,1282458,1282512,1282544,1282578,1282799,1282843,1282918,1282998,1283088,1283156,1283289,1283416,1285219,1286425,1286426,1286427,1286428,1286430,1286431,1287111,1287112,1287113,1287114,1287115,1287116,1287117,1287118,1287119,1287539,1287540,1287541,1287542,1287544,1287545,1287546,1287547,1287548,1287550,1287551,1287552,1287553,1287554,1287555,1287556,1287558,1287559,1287560,1287561,1287562,1287563,1287564,1287565,1287566,1287567,1287568,1287569,1287570,1288013,1288014,1288015,1288017,1288018,1288019,1288020,1288021,1288022,1288023,1288025,1288026,1288027,1288028,1288029,1288030,1288031,1288032,1288033,1288034,1288035,1288036,1288037,1288039,1288040,1288041,1288042,1288043,1288044,1289741,1292132,1292133,1292134,1292135,1292425,1292426,1292427,1292428,1292429,1292430,1292431,1292432,1292433,1292434,1292435,1292436,1292437,1292438,1292439,1292440,1292441,1292442,1292443,1292444,1292446,1292447,1292448,1292449,1292451,1292452,1292453,1292454,1292455,1292458,1292459,1292460,1292461,1292462,1292463,1292464,1292465,1292466,1292467,1292468,1292469,1292470,1292471,1292472,1292473,1292474,1292475,1292476,1292477,1292478,1292479,1292480,1292646,1292647,1293504,1293511,1293524,1293528,1293531,1293538,1294032,1294033,1294034,1294035,1294036,1294037,1294038,1296268,1296269,1296270,1296271,1296272,1296273,1296274,1296276,1296277,1296278,1296279,1296280,1296281,1296282,1296283,1297591,1297592,1297593,1297594,1297595,1298128,1303879,1303880,1303881,1303882,1303883,1303884,1303885,1303886,1303887,1303888,1303889,1303890,1303891,1303892,1303894,1303895,1303896,1303897,1303898,1303899,1305483,1305484,1305485,1305940,1305941,1305942,1305943,1305944,1305945,1305946,1305947,1305948,1305949,1305950,1305952,1305953,1305954,1305955,1305956,1305957,1305958,1305959,1305960,1305961,1305962,1305963,1305964,1305965,1307075,1307088,1307116,1307120,1308821,1308823,1308824,1309629,1309630,1309631,1309632,1309633,1309634,1309642,1309644,1309645,1309646,1309647,1309648,1309657,1309658,1309659,1309660,1309661,1309662,1309663,1309664,1313686,1313687,1313688,1313689,1316915,1316916,1316917,1316918,1316919,1316920,1316921,1316922,1316923,1316924,1316925,1317479,1317481,1317482,1317483,1317484,1317485,1317486,1317487,1317488,1317489,1317491,1317492,1318713,1318714,1318715,1318716,1318717,1318718,1318719,1318720,1318722,1318723,1318724,1318725,1318726,1318727,1318728,1318729,1318730,1318732,1318733,1318734,1318735,1318736,1318737,1318738,1318739,1318740,1318741,1319970,1319971,1319972,1319973,1319974,1319975,1319976,1319977,1319978,1319979,1319980,1319981,1319982,1319983,1319984,1319985,1319986,1319987,1319990,1319991,1319992,1319993,1319994,1319995,1319996,1319997,1319998,1319999,1320000,1320001,1320002,1322127,1322128,1322129,1322130,1322131,1322132,1322133,1322135,1322136,1322137,1322138,1322139,1322140,1322141,1322142,1322143,1322144,1323547,1323548,1323549,1323550,1323551,1323552,1323554,1323555,1323556,1323557,1323558,1323559,1324713,1324719,1324734,1324735,1324772,1327686,1327687,1327688,1327690,1327691,1329699,1329700,1329701,1329702,1329703,1331247,1331248,1333150,1333151,1333152,1333153,1333154,1333156,1333157,1333158,1333159,1333160,1333161,1333162,1333163,1333164,1333167,1333168,1333169,1333170,1333171,1333172,1334447,1334449,1334450,1334451,1334452,1334453,1334454,1334455,1334456,1334457,1334458,1334459,1334461,1334462,1334463,1334464,1334465,1334466,1334467,1334468,1334469,1334470,1334471,1334472,1334473,1334474,1334475,1334476,1334477,1334478,1334479,1334480,1334481,1334482,1334483,1334484,1334485,1334486,1334488,1334489,1334490,1334491,1334492,1334493,1334494,1334495,1334497,1334498,1334499,1334500,1334502,1334503,1334504,1334505,1334506,1334507,1334508,1334509,1334510,1334512,1334513,1334514,1334515,1334516,1334517,1334518,1334519,1334520,1334522,1334523,1334524,1334525,1334526,1334528,1334529,1334530,1334531,1334533,1334534,1334535,1334536,1334537,1334538,1334539,1334540,1334541,1334543,1334544,1334545,1334546,1334548,1334549,1335521,1335526,1335537,1335552,1335722,1335723,1335724,1335726,1335727,1335728,1335729,1335730,1335731,1335732,1335733,1335734,1335735,1335736,1335737,1335738,1335739,1335740,1335741,1335742,1335743,1335744,1335745,1335746,1335747,1335748,1335749,1335750,1335751,1335752,1335753,1335754,1337858,1337865,1337871,1338453,1338454,1338455,1338456,1338457,1338458,1338459,1338460,1338461,1338463,1338464,1338465,1338466,1338467,1338468,1338469,1338471,1338472,1338473,1338474,1338475,1338477,1338478,1338479,1338480,1338482,1338483,1338485,1338486,1338487,1338488,1338489,1338490,1338491,1338492,1338493,1338495,1338496,1338497,1338498,1338500,1338501,1338502,1338503,1339248,1339249,1339250,1339251,1339252,1339253,1339254,1339255,1339256,1339257,1339258,1339259,1521179,1521180,1521181,1521182,1521183,1521184,1521185,1521186,1521187,1521188,1521189,1521190,1521191,1521192,1521193,1521194,1521195,1521196,1521197,1521198,1521199,1521200,1521201,1521202,1523340,1523343,1523344,1523345,1523346,1523347,1523348,1523349,1523350,1523351,1524978,1524986,1524987,1524991,1524998,1525002,1525004,1525006,1525009,1525015,1525355,1525356,1525357,1525358,1525359,1525360,1525361,1525362,1525363,1525364,1525365,1525366,1525367,1525368,1525369,1525371,1525372,1525373,1525374,1526469,1526470,1526770,1526771,1526772,1526773,1526775,1526776,1526777,1526779,1526780,1526781,1526782,1526783,1526784,1526785,1526786,1526788,1526789,1526790,1526792,1526793,1526794,1526795,1526796,1526797,1526799,1526800,1526801,1526802,1526804,1526805,1526807,1526808,1526809,1526810,1526811,1526812,1526813,1526814,1526815,1526816,1526817,1526818,1526819,1526820,1526821,1526822,1526823,1526824,1526825,1526826,1526828,1526829,1526830,1526831,1526832,1526833,1526834,1526835,1526836,1526837,1526838,1526839,1526840,1526841,1526842,1526844,1526845,1526846,1526847,1526848,1526849,1527917,1527921,1527925,1527929,1527933,1527938,1527946,1527947,1527950,1527954,1527962,1527967,1527973,1527991,1527996,1528007,1528017,1528200,1528201,1528202,1528203,1528204,1528205,1528206,1528207,1528208,1528209,1528211,1528212,1528213,1528214,1528216,1528217,1528219,1528221,1528222,1528223,1528224,1528225,1528227,1528228,1528229,1528230,1528231,1528232,1528234,1528235,1528236,1528237,1528238,1528239,1528240,1528241,1528242,1528243,1528244,1530829,1530841,1530845,1530846,1530854,1530862,1530864,1531670,1531671,1531672,1531673,1531674,1531675,1531676,1531677,1531678,1531679,1531680,1531681,1531682,1531683,1531684,1531685,1531686,1531687,1531688,1531689,1531690,1531691,1531692,1531694,1531695,1531696,1531697,1531698,1531699,1531700,1531701,1531702,1531704,1531705,1531706,1532682,1532683,1532684,1532685,1532687,1532688,1532689,1532690,1532691,1532692,1532693,1532694,1532696,1532697,1532698,1532699,1532700,1532701,1532702,1532703,1532705,1532706,1532707,1532708,1532709,1532710,1532711,1532713,1532714,1532715,1532716,1532717,1532718,1532720,1532721,1532722,1532725,1532726,1532727,1532728,1536673,1536674,1536677,1536678,1536679,1536680,1536681,1536682,1536683,1536684,1536686,1536687,1540237,1540238,1540239,1540241,1540242,1540243,1540244,1540245,1540246,1540247,1540248,1540249,1540250,1540251,1540252,1540253,1540254,1540255,1540256,1540257,1540258,1540260,1540261,1540262,1540263,1540264,1540265,1540266,1540267,1540268,1540270,1540271,1540272,1540273,1540852,1540853,1540854,1540855,1540856,1540858,1540859,1540860,1540861,1540862,1540863,1540864,1540865,1540866,1540867,1540868,1540870,1540871,1540872,1540873,1542486,1542487,1542488,1542489,1542490,1542491,1542492,1542493,1542494,1542495,1542496,1542497,1542499,1542500,1542501,1542502,1542503,1542504,1542505,1542506,1542507,1542509,1543833,1543834,1543835,1543836,1543837,1543838,1543839,1543841,1543842,1543843,1543844,1543845,1543847,1543848,1543849,1543850,1543851,1543852,1543853,1543855,1543856,1543857,1543859,1543860,1543861,1543862,1546133,1546134,1546135,1546136,1546137,1546138,1546139,1546140,1547751,1547752,1547753,1547754,1547755,1547757,1547758,1547759,1547760,1547761,1547762,1547764,1547765,1547766,1547767,1547768,1547769,1549036,1549052,1549057,1549075,1549085,1549093,1549098,1549107,1549133,1549144,1549149,1549155,1549157,1549162,1549166,1549171,1549175,1549186,1549194,1549195,1549202,1549204,1549210,1552527,1552528,1552529,1552530,1552531,1552532,1552864,1552865,1552866,1552867,1552868,1552869,1552871,1552872,1552873,1552874,1552875,1552876,1552877,1552878,1552879,1552880,1552882,1552883,1552884,1552885,1552886,1552887,1552888,1552889,1552890,1552892,1552893,1552894,1552895,1552896,1552897,1552898,1552900,1552901,1552902,1552903,1552904,1552905,1552907,1555794,1555795,1555796,1555797,1555798,1555799,1555800,1555801,1555802,1555803,1555804,1555805,1555806,1555807,1555808,1555809,1555810,1555812,1555813,1555814,1555815,1555816,1555818,1555819,1555820,1555821,1555822,1555824,1555825,1555826,1555827,1555828,1555829,1555830,1555831,1555832,1555833,1555834,1555835,1555836,1555837,1555839,1555840,1555841,1555842,1555843,1555844,1555845,1555846,1555847,1555848,1555849,1555850,1555851,1557413,1557414,1557415,1557416,1557417,1557418,1557419,1557420,1557421,1557422,1557423,1557424,1557425,1557426,1557427,1557428,1557429,1557430,1557431,1557432,1557433,1557969,1557970,1557971,1557972,1557974,1557975,1557976,1557977,1557978,1557979,1557980,1557981,1557982,1557983,1557984,1557985,1557986,1557987,1557988,1557989,1557990,1557991,1557992,1557993,1557994,1557995,1557996,1557997,1557998,1557999,1564694,1564695,1564696,1564697,1564698,1564699,1564700,1564701,1564702,1564703,1564704,1564705,1564706,1564707,1564708,1564709,1564710,1564711,1564712,1564713,1564714,1564715,1564716,1564717,1564718,1564719,1564720,1564721,1564722,1564723,1564724,1564725,1564726,1566646,1566647,1566648,1566649,1566650,1566651,1566652,1566653,1566654,1566655,1566656,1567340,1567342,1567343,1567344,1567345,1567347,1567348,1567349,1567350,1567351,1567352,1567354,1567355,1567356,1567357,1567359,1567360,1567361,1567363,1567364,1567365,1567366,1567367,1567369,1567370,1568789,1568795,1568805,1568816,1568823,1568829,1568835,1568843,1568850,1568860,1568866,1568874,1568876,1568883,1568886,1568887,1568889,1568893,1568897,1568906,1568907,1568914,1568919,1568926,1568939,1568942,1568946,1569301,1569665,1570902,1570903,1570904,1570905,1570906,1570907,1570908,1570909,1570910,1570911,1571828,1571829,1571830,1571832,1571833,1571835,1571836,1571837,1571851,1571852,1571853,1571854,1571855,1571858,1571859,1571860,1571861,1571862,1571863,1571864,1571879,1571880,1571881,1571882,1571883,1571885,1571886,1571887,1571888,1571889,1571890,1571891,1571893,1571894,1571895,1571896,1571897,1571898,1571899,1576579,1576580,1576581,1576582,1576583,1576584,1576585,1576586,1576587,1576588,1576589,1576590,1576591,1576592,1576593,1576594,1576595,1576596,1576597,1576598,1576599,1576600,1576601,1576602,1576603,1576605,1576606,1576607,1576608,1576609,1576610,1576611,1576612,1576613,1576614,1576616,1576617,1576618,1576619,1576620,1576621,1576622,1576623,1576624,1576625,1576627,1576628,1576629,1576630,1576631,1576632,1576633,1576634,1576635,1576636,1576638,1576639,1576640,1576641,1576642,1576643,1576644,1576645,1576646,1576647,1576648,1576649,1576650,1576651,1576652,1576653,1576654,1576655,1576836,1576838,1576839,1576840,1576841,1576842,1576843,1576845,1576846,1576847,1576848,1576849,1577416,1577530,1577551,1577603,1577642,1577732,1577780,1577939,1578305,1578356,1578484,1578572,1578646,1578849,1578853,1578854,1578855,1578856,1578857,1578859,1578860,1578861,1578862,1578863,1578865,1578866,1578867,1578868,1578869,1578871,1578872,1578873,1578874,1578875,1578876,1578877,1578878,1578879,1578880,1578881,1578883,1578884,1578885,1578886,1578887,1578888,1578889,1578890,1578891,1578892,1578893,1578894,1578895,1578896,1578897,1578898,1578899,1578900,1578901,1578902,1578903,1578904,1578905,1578907,1578908,1578909,1578910,1578911,1578912,1578913,1578915,1578916,1578917,1578918,1578919,1578920,1578921,1578922,1578924,1578925,1578926,1578927,1578928,1578929,1578930,1578931,1578932,1578933,1578934,1578935,1578936,1578937,1578938,1578939,1578940,1578941,1578942,1578943,1578944,1578945,1578946,1578947,1578948,1578949,1578957,1579238,1579288,1579696,1582381,1583554,1583556,1583557,1583558,1583559,1583560,1583561,1583562,1584434,1584435,1584436,1584438,1584439,1584440,1584442,1584443,1584444,1584445,1584447,1584958,1584959,1584960,1584961,1584963,1584964,1584965,1584966,1584967,1584968,1584970,1584971,1584972,1584973,1584974,1584975,1584976,1584977,1584979,1584980,1584981,1584982,1584983,1584984,1584985,1584986,1584987,1584988,1584989,1584991,1584992,1584993,1584994,1585418,1585419,1585420,1585421,1585422,1585423,1585424,1585425,1585426,1585427,1585428,1585429,1585431,1585432,1585434,1585435,1585436,1585437,1585438,1585439,1585440,1585441,1585442,1585443,1585444,1585445,1585446,1587385,1590399,1590401,1590402,1590403,1590404,1590405,1590406,1590735,1590736,1590737,1590738,1590739,1590741,1590742,1590743,1590745,1590746,1590747,1590748,1590749,1590750,1590751,1590752,1590753,1590754,1590755,1590756,1590757,1590759,1590760,1590761,1590762,1590763,1590764,1590765,1590766,1590767,1590768,1590769,1590770,1590773,1590774,1590776,1590777,1590778,1590779,1590780,1590781,1590782,1590783,1590784,1590996,1592216,1592222,1592225,1592241,1592247,1592252,1592259,1592260,1592262,1592278,1592283,1592288,1592291,1592299,1592325,1592333,1592336,1592340,1592346,1592351,1592357,1592779,1592780,1592781,1592782,1592783,1592784,1592785,1592786,1592787,1592788,1594650,1594651,1594652,1594653,1594654,1594655,1594657,1594658,1594659,1596211,1596212,1596213,1596214,1596215,1596216,1596217,1596218,1596219,1596220,1596221,1596222,1596224,1596225,1596226,1596227,1596228,1599275,1599276,1599277,1599278,1599279,1599280,1599281,1599282,1599283,1599284,1599285,1599286,1599287,1599288,1599289,1599290,1599428,1599429,1599430,1599431,1599432,1599433,1599435,1599436,1599438,1599439,1599440,1599441,1599442,1599443,1599444,1599445,1599446,1599447,1599448,1599449,1599450,1599451,1599452,1599453,1599455,1599456,1599457,1599459,1599461,1599462,1599463,1599464,1599465,1599466,1599468,1599469,1599470,1599471,1599472,1599473,1599475,1599476,1599477,1599478,1599479,1599480,1599481,1599482,1599484,1599485,1599486,1599487,1599488,1599489,1599490,1599491,1599492,1599493,1599495,1599496,1599497,1599498,1600180,1600181,1600182,1600183,1600185,1600186,1600187,1601387,1601388,1601389,1601390,1601391,1601392,1601393,1601395,1601396,1601397,1601398,1601399,1601400,1601401,1601402,1601403,1601404,1601405,1601406,1601407,1601408,1601409,1601410,1601411,1601412,1601413,1601414,1601416,1601417,1601418,1601419,1601421,1601422,1601423,1601424,1601426,1601427,1601428,1601429,1603170,1603171,1604531,1604533,1604534,1604535,1604536,1604537,1604538,1604539,1604540,1604542,1604543,1604847,1604848,1604849,1604850,1604851,1604852,1606904,1606905,1606906,1606907,1606908,1606909,1606910,1606911,1606913,1606914,1606915,1606916,1606917,1606918,1606919,1606920,1606921,1606922,1606923,1606924,1606925,1606926,1606927,1606928,1606929,1606930,1606931,1606932,1606933,1607225,1607226,1607227,1607229,1607230,1607231,1607232,1611118,1611119,1611121,1611122,1611123,1611124,1611125,1611126,1611127,1611128,1611129,1611130,1611131,1611132,1611133,1611134,1611135,1611136,1611137,1611138,1611140,1611141,1611142,1611143,1611144,1611145,1611148,1611149,1611150,1611151,1611153,1611154,1611155,1611156,1611158,1611159,1611160,1611162,1611163,1611164,1611167,1611168,1612881,1612882,1612883,1612884,1612885,1612887,1612888,1612889,1612890,1612891,1612892,1612893,1612894,1612895,1612896,1612897,1612898,1612899,1612900,1612901,1612902,1612904,1612905,1612906,1612907,1612908,1612909,1612910,1612911,1612912,1612913,1612914,1612915,1612917,1612918,1612919,1612920,1612921,1612922,1612923,1612924,1612925,1612926,1612927,1612929,1612930,1612931,1612932,1612933,1612934,1612935,1612936,1612937,1612938,1612939,1614084,1614085,1614086,1614087,1614088,1614089,1614090,1614091,1614092,1614093,1614094,1614095,1614096,1614097,1614099,1614100,1614101,1614102,1614103,1614104,1614105,1614106,1614107,1614108,1614109,1614110,1614111,1614112,1614113,1614114,1614115,1614116,1614117,1614118,1614119,1614120,1614121,1614122,1614123,1614124,1614125,1614126,1614127,1614879,1614880,1614886,1614896,1614919,1614922,1614924,1614934,1614949,1614957,1614965,1614973,1614979,1614983,1614991,1615000,1615006,1615011,1615014,1615020,1615025,1615026,1615030,1615032,1615037,1615042,1615096,1615118,1615134,1615140,1615150,1615498,1615499,1615501,1615502,1615503,1615504,1615505,1615506,1615507,1615508,1615509,1615510,1615511,1615512,1615513,1615515,1615516,1615517,1615518,1615520,1615521,1615522,1615523,1615524,1615525,1615526,1615527,1615528,1615529,1615530,1615531,1615532,1615533,1615534,1615535,1615536,1615537,1615538,1615540,1615541,1615542,1615543,1615544,1615545,1615546,1615547,1615548,1615549,1615551,1615552,1616704,1616705,1616706,1616707,1616708,1616709,1616710,1616711,1616712,1616713,1616714,1616715,1616716,1617112,1617113,1617114,1617115,1617116,1617117,1617118,1617119,1617120,1617121,1617122,1617123,1618251,1618252,1618253,1618254,1618255,1618256,1618257,1618258,1618259,1618260,1618261,1618262,1618263,1618264,1618265,1618266,1618267,1618268,1618269,1618270,1618271,1618274,1618275,1618276,1618277,1618278,1618279,1618280,1618281,1618282,1618283,1618284,1618285,1618286,1618288,1618289,1618290,1618291,1618292,1618293,1618294,1618295,1618296,1618297,1618299,1618300,1618301,1618302,1618303,1618304,1618305,1618306,1618307,1618309,1618310,1618311,1618312,1618313,1618315,1618316,1618317,1618319,1618320,1618321,1618322,1618323,1618324,1618325,1618326,1618327,1618328,1618329,1618330,1618332,1618333,1618334,1618335,1618336,1618337,1618338,1618340,1618341,1618342,1618343,1618344,1618345,1621161,1621162,1621163,1621164,1624977,1624978,1624979,1624980,1624981,1624982,1624983,1624984,1624986,1624987,1624988,1624989,1624990,1626666,1626667,1626668,1626669,1626670,1626671,1626672,1626674,1626675,1626676,1626677,1626678,1626679,1626680,1626681,1626682,1626683,1626684,1626685,1626686,1626688,1626689,1626690,1626691,1626692,1626694,1626695,1626697,1626698,1626699,1626700,1626701,1626703,1626704,1626705,1626706,1626707,1626709,1626710,1626711,1626712,1626714,1626715,1626716,1626717,1626718,1626719,1626721,1626722,1627619,1627620,1627622,1627623,1627624,1627625,1627626,1627627,1627629,1627630,1627631,1627868,1627870,1628951,1628952,1628953,1628954,1628955,1628956,1628957,1628959,1628960,1628961,1628962,1628963,1628965,1628966,1628967,1628968,1628969,1628971,1628972,1628973,1628974,1628975,1628976,1628978,1628979,1628980,1628981,1628982,1628983,1628984,1628985,1628986,1628988,1628989,1628990,1628991,1628992,1628994,1628998,1628999,1629000,1629001,1629002,1629003,1629004,1629005,1629006,1629007,1629008,1629009,1629010,1629011,1629012,1629013,1629014,1629016,1629017,1629018,1629019,1629020,1629021,1629022,1629023,1629024,1629025,1629026,1629027,1629028,1629029,1629030,1629031,1629032,1629033,1629034,1629035,1629036,1629037,1629038,1629039,1629040,1629041,1629043,1629044,1629045,1629047,1629048,1629049,1629050,1629051,1629052,1629053,1629054,1629055,1629056,1630584,1631823,1631860,1631864,1631872,1631888,1631934,1631936,1631942,1631949,1631960,1631969,1631971,1631976,1631977,1631988,1631991,1631997,1632000,1632003,1632004,1632006,1632008,1632031,1632054,1632060,1632061,1632062,1632073,1632074,1632075,1632082,1632087,1632088,1632104,1632105,1632108,1632112,1632132,1632147,1632152,1632157,1652765,1652766,1652767,1653272,1653273,1653274,1653275,1653276,1656496,1656497,1656498,1656499,1656500,1656501,1656502,1656504,1656505,1656506,1656508,1656509,1656510,1656511,1656512,1657891,1657892,1657893,1657894,1657896,1657897,1657898,1657899,1657900,1657901,1657902,1657904,1657905,1657907,1657908,1657909,1657910,1657911,1657912,1657913,1657914,1657915,1657916,1657917,1657918,1657919,1657920,1657922,1657923,1657924,1657925,1657926,1657927,1657928,1657929,1657930,1657931,1657932,1657933,1657934,1657935,1657936,1657937,1657938,1657939,1657940,1657941,1657942,1657943,1657944,1657945,1659344,1659346,1659347,1659348,1659349,1659350,1659351,1659352,1659353,1669692,1669695,1669696,1669697,1669698,1669699,1669700,1669701,1669702,1669703,1669704,1669705,1669706,1669707,1669708,1669709,1669710,1669711,1669712,1669713,1669714,1669715,1669716,1669718,1669719,1669721,1669722,1669723,1669724,1669725,1669727,1669728,1697569,1697570,1697571,1697572,1697573,1697574,1697576,1697577,1697727,1697728,1697729,1697731,1697732,1697733,1697734,1697735,1697736,1697737,1697738,1697739,1697740,1697741,1697742,1697805,1697807,1697808,1697809,1697810,1697812,1697813,1697814,1697816,1697817,1697818,1697819,1697820,1697821,1697967,1697969,1697970,1697971,1697972,1697973,1697974,1697975,1697976,1697978,1697979,1697980,1697981,1697982,1697983,1697984,1697985,1697986,1697987,1699192,1699193,1699194,1699195,1699196,1699197,1699198,1699200,1699201,1699381,1699382,1699383,1699384,1699385,1699386,1699387,1699389,1699391,1699392,1704522,1704524,1704525,1704526,1704527,1704529,1704530,1704531,1705013,1705014,1705015,1706701,1706703,1706704,1706705,1706706,1706707,1706708,1706709,1706710,1706711,1706712,1706713,1706714,1706715,1706716,1706717,1706718,1706719,1706720,1706721,1706723,1706724,1706725,1706726,1706727,1706728,1706729,1706730,1706732,1706733,1708028,1708029,1708030,1708031,1708032,1708033,1708034,1708035,1708036,1708037,1708038,1708039,1708040,1708041,1708042,1708043,1708044,1708045,1708046,1708047,1708048,1708049,1708050,1708051,1708053,1708054,1708055,1708056,1708057,1708058,1708059,1708061,1708062,1708063,1709579,1709580,1709581,1709582,1709583,1709584,1709585,1709586,1709588,1709589,1711066,1711067,1711068,1711069,1711070,1711071,1711072,1711073,1733216,1733217,1733218,1733219,1733220,1734847,1734848,1734849,1734850,1734851,1734852,1734853,1735052,1735053,1735055,1735056,1735057,1735058,1735059,1735060,1735061,1735062,1735063,1735064,1735065,1735066,1735067,1735068,1735069,1735070,1735071,1735072,1735073,1735074,1735075,1735076,1735077,1735079,1735080,1735081,1735082,1735083,1735084,1735085,1735086,1735087,1735088,1735089,1735090,1735091,1735092,1735094,1735095,1735096,1735097,1735098,1735099,1735100,1735101,1735102,1735104,1735107,1735108,1735109,1735110,1735111,1735112,1735113,1735114,1735115,1735116,1735117,1735118,1735119,1735120,1735121,1735122,1735123,1735124,1735125,1735126,1735128,1735129,1735130,1735131,1735132,1735133,1735134,1735135,1735136,1735137,1735138,1735139,1735140,1735141,1735142,1735143,1735144,1735146,1735147,1735148,1735149,1735150,1738270,1738271,1738272,1738273,1738274,1738275,1738276,1738278,1738279,1738280,1738281,1738282,1738283,1738284,1738285,1738287,1738288,1738289,1738290,1738291,1738292,1738293,1738295,1738296,1738297,1738298,1738299,1738300,1738301,1738302,1738303,1738304,1738305,1738478,1738479,1738480,1738481,1738482,1738483,1738484,1738485,1738487,1738488,1738489,1738490,1738491,1738492,1738493,1738494,1738989,1738990,1738992,1738993,1738994,1738995,1738996,1741468,1741469,1741470,1741471,1741472,1741473,1741474,1741475,1741476,1741477,1741478,1741479,1744524,1744525,1744526,1744527,1744528,1744529,1744530,1744531,1744532,1744533,1744534,1744535,1744536,1744537,1744538,1744539,1744540,1744541,1744542,1746475,1746476,1746477,1746478,1746480,1746481,1746482,1746483,1746484,1746485,1746486,1749976,1749977,1749978,1751452,1751453,1751454,1751455,1751456,1751457,1751458,1751460,1751461,1751462,1751463,1751464,1751466,1751467,1751468,1751469,1751470,1751471,1751474,1751475,1751476,1751477,1751478,1751479,1751480,1751481,1751482,1751483,1751485,1752055,1752056,1752057,1752058,1752059,1752060,1752061,1752628,1752645,1752651,1752657,1752663,1752680,1752691,1752699,1752707,1752731,1752738,1752755,1752794,1752864,1752875,1753334,1753335,1753336,1753337,1753339,1753340,1753341,1753342,1753343,1753344,1754161,1754163,1754164,1754165,1754166,1754168,1754169,1754170,1754171,1754173,1754174,1754175,1754177,1754179,1754180,1754181,1754182,1754183,1754184,1754185,1754186,1754187,1754188,1754189,1754190,1754191,1754192,1754193,1754194,1754195,1754196,1754610,1757810,1757842,1757849,1757857,1757863,1757873,1757887,1757888,1757892,1757894,1757904,1757906,1757909,1757918,1757924,1757936,1757938,1757944,1757973,1757979,1757984,1757992,1757996,1758005,1758045,1758050,1758058,1758065,1759140,1759141,1759143,1759144,1759145,1762260,1762261,1762262,1762263,1762264,1762265,1762266,1762267,1762268,1762269,1762270,1762271,1762272,1762274,1762275,1762276,1762277,1762278,1762279,1762280,1762281,1762284,1762285,1762287,1762288,1762289,1762290,1762291,1762292,1762293,1762294,1762295,1762296,1767672,1767673,1767674,1767675,1767676,1767677,1767678,1767680,1767681,1767682,1767683,1767684,1767685,1767686,1767687,1767688,1767689,1767690,1767691,1767692,1767694,1767695,1767696,1767697,1767698,1767699,1767700,1767701,1767702,1767919,1767925,1767931,1767968,1767973,1767982,1767991,1767997,1768001,1768004,1768036,1768050,1768054,1768059,1768083,1768095,1768098,1768109,1768110,1768117,1768125,1768128,1768131,1768135,1768137,1768141,1768148,1768171,1768192,1768203,1768209,1770829,1770830,1770831,1770832,1770833,1770834,1770835,1770836,1770837,1770838,1770839,1770840,1770841,1770842,1770843,1770844,1770845,1770846,1770847,1770848,1770849,1770850,1770851,1770852,1770853,1770855,1770856,1770857,1770858,1770859,1770860,1770861,1770862,1770864,1770865,1770866,1770867,1770868,1770869,1770870,1770871,1770872,1770873,1770875,1770876,1770877,1770878,1770879,1770880,1783300,1783301,1783302,1783303,1783304,1783305,1783306,1786307,1786308,1786309,1786310,1786312,1786313,1786314,1786315,1786316,1786317,1786318,1786319,1786320,1786321,1786322,1786323,1786324,1786325,1786326,1786327,1786328,1786329,1786331,1786332,1786333,1786334,1786335,1786336,1790081,1790082,1790083,1790084,1790085,1790086,1790087,1790088,1790089,1790090,1790091,1790092,1790093,1790094,1790095,1790096,1790097,1790098,1790099,1790100,1790346,1790347,1790348,1790349,1790350,1790352,1790372,1790373,1790374,1790375,1790376,1790377,1790378,1790379,1790705,1790706,1790707,1790708,1790709,1790710,1790711,1790712,1800158,1800174,1800176,1800189,1800193,1800196,1800214,1800215,1800224,1800228,1800232,1800257,1800272,1800279,1800290,1800328,1800344,1800351,1800362,1800387,1800413,1800419,1800432,1800436,1800438,1800439,1800470,1800485,1804095,1804096,1804097,1804098,1804099,1804100,1804101,1804102,1804104,1804105,1804106,1804107,1804108,1804109,1804110,1804111,1804112,1804113,1804115,1804116,1804117,1804118,1804119,1804120,1804121,1804122,1804123,1804124,1804125,1804126,1804127,1804128,1804129,1804130,1804131,1804132,1804134,1804135,1808749,1808751,1808752,1808753,1808755,1808756,1808757,1808758,1808759,1808760,1808761,1808762,1808763,1808764,1808765,1808766,1808767,1808768,1808769,1808770,1808771,1808772,1808920,1808925,1808954,1808956,1808960,1808994,1809001,1809008,1809012,1809025,1809041,1809051,1809061,1809065,1809078,1809082,1809088,1809158,1809163,1809171,1809177,1809184,1809195,1809199,1809207,1809213,1809219,1809225,1809231,1811321,1811323,1811325,1811326,1811327,1811328,1811329,1811330,1814540,1814541,1814542,1814543,1814544,1814546,1814547,1814747,1814748,1814749,1814750,1814751,1814752,1814753,1814755,1814756,1814757,1814758,1814759,1814760,1814761,1814764,1814765,1814766,1814767,1814769,1814770,1814771,1814772,1814774,1814775,1814776,1814777,1814778,1814780,1814781,1814782,1814783,1814784,1814785,1814786,1814787,1814788,1814789,1814790,1814791,1814792,1814793,1814794,1814795,1814796,1814797,1814798,1814799,1814801,1814802,1814803,1814804,1814805,1814806,1814807,1814808,1814809,1814810,1814811,1814812,1814813,1814814,1814815,1814817,1814818,1814819,1814820,1814822,1814823,1814824,1814826,1814827,1814828,1814829,1814830,1814831,1814833,1817500,1817501,1817502,1817503,1817504,1817505,1817506,1817507,1817509,1817510,1817612,1817613,1817614,1817615,1817617,1817618,1817619,1817620,1817622,1817623,1817624,1817625,1817626,1817628,1817629,1818078}'::bigint[])))
  • Heap Blocks: exact=624
8. 0.550 25.463 ↓ 0.0 0 1

BitmapAnd (cost=7,180.18..7,180.18 rows=25 width=0) (actual time=25.463..25.463 rows=0 loops=1)

9. 18.247 18.247 ↓ 108.7 213,524 1

Bitmap Index Scan on index_data_73 (cost=0.00..91.15 rows=1,964 width=0) (actual time=18.247..18.247 rows=213,524 loops=1)

  • Index Cond: (vague = 3)
10. 6.666 6.666 ↑ 1.0 4,932 1

Bitmap Index Scan on data_id_readings (cost=0.00..7,088.76 rows=4,932 width=0) (actual time=6.666..6.666 rows=4,932 loops=1)

  • Index Cond: (id_readings = ANY ('{1151333,1151334,1151336,1151337,1151338,1151339,1151340,1151341,1151343,1151344,1151345,1151346,1151347,1151349,1151350,1151351,1151352,1151353,1151354,1151355,1152922,1152923,1152924,1152925,1152926,1152927,1152928,1152929,1153651,1153652,1153653,1153654,1153655,1153656,1153657,1153658,1153659,1153660,1153661,1153662,1153663,1153664,1153665,1153666,1153667,1154345,1154346,1154347,1154348,1154349,1154350,1154351,1154353,1154354,1154355,1154356,1154357,1154358,1154359,1154360,1154361,1154362,1154363,1154364,1155701,1155707,1155743,1155757,1155800,1155845,1155865,1155869,1155886,1155892,1155898,1155901,1155912,1155915,1155920,1155924,1155937,1155944,1155966,1155972,1155979,1155984,1155992,1155995,1156003,1156012,1156013,1156025,1156029,1156036,1156039,1156054,1156057,1156091,1156098,1158423,1158424,1158425,1158426,1158427,1161143,1161144,1161145,1161146,1161147,1161148,1161149,1161150,1161151,1161152,1161153,1161154,1161155,1161156,1161157,1161159,1161160,1161161,1161162,1162631,1162632,1162633,1162634,1162635,1163167,1163168,1163169,1163170,1163172,1163173,1163174,1163175,1163176,1163824,1163825,1163828,1163829,1163830,1163831,1163832,1165083,1165088,1165105,1165109,1165121,1165127,1165129,1165133,1165137,1165140,1165147,1165153,1165157,1165162,1165172,1165178,1165186,1165189,1165194,1165210,1165211,1165214,1165227,1165234,1165250,1165252,1165265,1165269,1165301,1165303,1165320,1165371,1165387,1165396,1165398,1165403,1165406,1165418,1165419,1165422,1165428,1167332,1167334,1167335,1168914,1168915,1171479,1171480,1171481,1171483,1171484,1171485,1174551,1174552,1174554,1174555,1174556,1174557,1174558,1174559,1174560,1174562,1174563,1174564,1174565,1174793,1174794,1174795,1174796,1174797,1174819,1174820,1174821,1174822,1174823,1174824,1174825,1174826,1174827,1174828,1174829,1174830,1174831,1174832,1174833,1175119,1175120,1175121,1175122,1175123,1175124,1175125,1175126,1176795,1176803,1176818,1176825,1176835,1176841,1176851,1176887,1176889,1176894,1176904,1176909,1176914,1176928,1176934,1176938,1176943,1176950,1176956,1176970,1176975,1176978,1176984,1176988,1176994,1176999,1177003,1177008,1177012,1177023,1177026,1177441,1177442,1178183,1178184,1178185,1178186,1178187,1178188,1178189,1178190,1178191,1178192,1178193,1178194,1178195,1178196,1178197,1178198,1178199,1178200,1178201,1178202,1178203,1178204,1178205,1178206,1178207,1178208,1178209,1178211,1178212,1178213,1178217,1178218,1178219,1178220,1178221,1178222,1181102,1181118,1181120,1181133,1181137,1181140,1181158,1181159,1181168,1181172,1181176,1181201,1181216,1181223,1181234,1181272,1181288,1181295,1181306,1181331,1181357,1181363,1181376,1181380,1181382,1181383,1181414,1181429,1185039,1185040,1185041,1185042,1185043,1185044,1185045,1185046,1185048,1185049,1185050,1185051,1185052,1185053,1185054,1185055,1185056,1185057,1185059,1185060,1185061,1185062,1185063,1185064,1185065,1185066,1185067,1185068,1185069,1185070,1185071,1185072,1185073,1185074,1185075,1185076,1185078,1185079,1189693,1189695,1189696,1189697,1189699,1189700,1189701,1189702,1189703,1189704,1189705,1189706,1189707,1189708,1189709,1189710,1189711,1189712,1189713,1189714,1189715,1189716,1189864,1189869,1189898,1189900,1189904,1189938,1189945,1189952,1189956,1189969,1189985,1189995,1190005,1190009,1190022,1190026,1190032,1190102,1190107,1190115,1190121,1190128,1190139,1190143,1190151,1190157,1190163,1190169,1190175,1192265,1192267,1192269,1192270,1192271,1192272,1192273,1192274,1195484,1195485,1195486,1195487,1195488,1195490,1195491,1195691,1195692,1195693,1195694,1195695,1195696,1195697,1195699,1195700,1195701,1195702,1195703,1195704,1195705,1195708,1195709,1195710,1195711,1195713,1195714,1195715,1195716,1195718,1195719,1195720,1195721,1195722,1195724,1195725,1195726,1195727,1195728,1195729,1195730,1195731,1195732,1195733,1195734,1195735,1195736,1195737,1195738,1195739,1195740,1195741,1195742,1195743,1195745,1195746,1195747,1195748,1195749,1195750,1195751,1195752,1195753,1195754,1195755,1195756,1195757,1195758,1195759,1195761,1195762,1195763,1195764,1195766,1195767,1195768,1195770,1195771,1195772,1195773,1195774,1195775,1195777,1198444,1198445,1198446,1198447,1198448,1198449,1198450,1198451,1198453,1198454,1198556,1198557,1198558,1198559,1198561,1198562,1198563,1198564,1198566,1198567,1198568,1198569,1198570,1198572,1198573,1199022,1201257,1201258,1201259,1201261,1201262,1201264,1201265,1205881,1205882,1205883,1205884,1205885,1205886,1205887,1205888,1205889,1205890,1210153,1210154,1210155,1210156,1210158,1210159,1210160,1210161,1210162,1210163,1210164,1210165,1210166,1210168,1210169,1210170,1210171,1210172,1210173,1210174,1210175,1215103,1215104,1215221,1215222,1215223,1215225,1215295,1215296,1215297,1215298,1215299,1215300,1215301,1215302,1215303,1215304,1215433,1215434,1215435,1215436,1216464,1216465,1216637,1216638,1216640,1216641,1216642,1216643,1216644,1216645,1216646,1216647,1216649,1216650,1216651,1216652,1216653,1216654,1216655,1216656,1216657,1216658,1216659,1216660,1216661,1221276,1221277,1221278,1221279,1221280,1221281,1221282,1221283,1221284,1223184,1223185,1223186,1223187,1223188,1223189,1223190,1223191,1223193,1223194,1223195,1223196,1223197,1223198,1223199,1223200,1223201,1223202,1223203,1223204,1223205,1223206,1223207,1223209,1223210,1223211,1223212,1223213,1223214,1223215,1224451,1224452,1224453,1224454,1224455,1224457,1224459,1224460,1224462,1224463,1224464,1224465,1224466,1224467,1224468,1224469,1224470,1224472,1224473,1224474,1224475,1224476,1224477,1224478,1224479,1224481,1224482,1225602,1225603,1225604,1225605,1225607,1225608,1225609,1225610,1225611,1225612,1225613,1228305,1228306,1228308,1228696,1228697,1231250,1231251,1231252,1231253,1231254,1231255,1231256,1231257,1231258,1231259,1232249,1232250,1232251,1232252,1232253,1232255,1232256,1232257,1232258,1232259,1232260,1232261,1232262,1232263,1232264,1232265,1232266,1232267,1232268,1232269,1232270,1232271,1232273,1232274,1232275,1232276,1232277,1232278,1232279,1232281,1232282,1232283,1232284,1232285,1232286,1232287,1232288,1232289,1232290,1232291,1232292,1232293,1232294,1232296,1232297,1232298,1232299,1232300,1232301,1232302,1232303,1232304,1232305,1232306,1233380,1233381,1233382,1233383,1233385,1233386,1242291,1242292,1242293,1242294,1242295,1242296,1242297,1242298,1242299,1242301,1242302,1242303,1242304,1242305,1242306,1242309,1242310,1242311,1242312,1242313,1242314,1242315,1242316,1242317,1242318,1242319,1242320,1242321,1242323,1242324,1242325,1242326,1242327,1242328,1242329,1244911,1244912,1244913,1244915,1244916,1244917,1244918,1244919,1244920,1244921,1244922,1244923,1244924,1244925,1244926,1244927,1244928,1244929,1244930,1244931,1244932,1244934,1244935,1244936,1244937,1244938,1244939,1244940,1244941,1244942,1244944,1244945,1244946,1244947,1244948,1244949,1244950,1244951,1244952,1245850,1245851,1245852,1245853,1245855,1245856,1245857,1245858,1245859,1245861,1245862,1245863,1245864,1245865,1245869,1245870,1245871,1245872,1245873,1245874,1245875,1245876,1245877,1245878,1245879,1245880,1245881,1245882,1245884,1245885,1245887,1245888,1245889,1245890,1245891,1246543,1246549,1246555,1246561,1246566,1246578,1246592,1246598,1246607,1246609,1246616,1246629,1246636,1246646,1246652,1246670,1246688,1246722,1246724,1246727,1246733,1246739,1246741,1246746,1246750,1246753,1246759,1246762,1246772,1246780,1247032,1247033,1247034,1247035,1247036,1247037,1247038,1247039,1247040,1247041,1247042,1247045,1247046,1247047,1247048,1247049,1247050,1247051,1247052,1247053,1248010,1248011,1248012,1248014,1248016,1248017,1248018,1248318,1248319,1248320,1248322,1248323,1248324,1248326,1249187,1249188,1249190,1249191,1249192,1249193,1249194,1249195,1249197,1249198,1249199,1249200,1249201,1249202,1249203,1249204,1249205,1249206,1249207,1249209,1249210,1249211,1249212,1249213,1249214,1249215,1249216,1249217,1249218,1249219,1249220,1249221,1249223,1249224,1249225,1249227,1249228,1249229,1249230,1249231,1253852,1253854,1253855,1253856,1253857,1253858,1255161,1255162,1255164,1255165,1255166,1255167,1255168,1255169,1255170,1255171,1255172,1255174,1255175,1255176,1255177,1255178,1255179,1255180,1255181,1255182,1255183,1256039,1256040,1256041,1256042,1256043,1256044,1256045,1256047,1256048,1256049,1256050,1256051,1256052,1256053,1256054,1256055,1256248,1257213,1257214,1257215,1257216,1257217,1257218,1257219,1257220,1257221,1257222,1257223,1257224,1257225,1257226,1257227,1257228,1257229,1257230,1257231,1257232,1257233,1257234,1257235,1257236,1257237,1257238,1257239,1257240,1257241,1257242,1257243,1257244,1257245,1257246,1257247,1257248,1257249,1257250,1257251,1257252,1257253,1257254,1257255,1257256,1257257,1257258,1257259,1257260,1257261,1257262,1257263,1257265,1257266,1257268,1257269,1257270,1257272,1257273,1257274,1257277,1257279,1257280,1257281,1257282,1257283,1257284,1257285,1257286,1257287,1257288,1257289,1257290,1257291,1259560,1259566,1259568,1259574,1259583,1259605,1259607,1259610,1259622,1259716,1259724,1259733,1259744,1259788,1259793,1259799,1259832,1259834,1259842,1259850,1259855,1259863,1259868,1259873,1259881,1259891,1259899,1260434,1260435,1260436,1260437,1260438,1260439,1262051,1262052,1262053,1262054,1262055,1263410,1263411,1266227,1266228,1266229,1266400,1266401,1266403,1266404,1266405,1266406,1266407,1266408,1266409,1266410,1266411,1266412,1266413,1266414,1266415,1266416,1266417,1266418,1266419,1266420,1266422,1266423,1266424,1266425,1266426,1266427,1266428,1266429,1266431,1266432,1266433,1266434,1266435,1266436,1266437,1266438,1266439,1266440,1266441,1266442,1266444,1266445,1266446,1266447,1266448,1266449,1266451,1266452,1266453,1266454,1266455,1266456,1266457,1266458,1266459,1266460,1266461,1266462,1266463,1266464,1266465,1266466,1266467,1266468,1266469,1266470,1266472,1266473,1266474,1266475,1266476,1266477,1266478,1266479,1266480,1266481,1266482,1266483,1266484,1266485,1266486,1266487,1266488,1266489,1266490,1266491,1266493,1266494,1266495,1266496,1266497,1266498,1266499,1266500,1266501,1266502,1266503,1266504,1266505,1266506,1266507,1266508,1266509,1267041,1267042,1267043,1267044,1267045,1268053,1268054,1268055,1268056,1268057,1268058,1268059,1268060,1268061,1268062,1268064,1268065,1268066,1268067,1268068,1268069,1268070,1268071,1268072,1268073,1268074,1269402,1269403,1269404,1269405,1270480,1270481,1270482,1270483,1270484,1270763,1270764,1272441,1272442,1272443,1272445,1272446,1272447,1272448,1272450,1272451,1272452,1272453,1272454,1272455,1272456,1272457,1272458,1272459,1272460,1272461,1272463,1272464,1272753,1275988,1275989,1275990,1275991,1275992,1275993,1275994,1275995,1275996,1275998,1275999,1276000,1276001,1276002,1276003,1276004,1276006,1276007,1276008,1276009,1276010,1276011,1276012,1276013,1276014,1276015,1276016,1276017,1276018,1276019,1276020,1276021,1276022,1276023,1276024,1276025,1276026,1276027,1276029,1276030,1276031,1276032,1276033,1276034,1276035,1276036,1276037,1276038,1280583,1280584,1280585,1280586,1281184,1281232,1281428,1281542,1281572,1281646,1281681,1281726,1281775,1281809,1281959,1282001,1282090,1282233,1282304,1282305,1282306,1282307,1282308,1282309,1282310,1282311,1282312,1282314,1282315,1282316,1282317,1282318,1282319,1282320,1282321,1282322,1282323,1282324,1282326,1282327,1282328,1282329,1282330,1282331,1282332,1282333,1282334,1282335,1282336,1282337,1282338,1282339,1282340,1282341,1282342,1282344,1282345,1282346,1282348,1282349,1282350,1282351,1282352,1282354,1282355,1282356,1282357,1282358,1282359,1282360,1282361,1282362,1282363,1282420,1282458,1282512,1282544,1282578,1282799,1282843,1282918,1282998,1283088,1283156,1283289,1283416,1285219,1286425,1286426,1286427,1286428,1286430,1286431,1287111,1287112,1287113,1287114,1287115,1287116,1287117,1287118,1287119,1287539,1287540,1287541,1287542,1287544,1287545,1287546,1287547,1287548,1287550,1287551,1287552,1287553,1287554,1287555,1287556,1287558,1287559,1287560,1287561,1287562,1287563,1287564,1287565,1287566,1287567,1287568,1287569,1287570,1288013,1288014,1288015,1288017,1288018,1288019,1288020,1288021,1288022,1288023,1288025,1288026,1288027,1288028,1288029,1288030,1288031,1288032,1288033,1288034,1288035,1288036,1288037,1288039,1288040,1288041,1288042,1288043,1288044,1289741,1292132,1292133,1292134,1292135,1292425,1292426,1292427,1292428,1292429,1292430,1292431,1292432,1292433,1292434,1292435,1292436,1292437,1292438,1292439,1292440,1292441,1292442,1292443,1292444,1292446,1292447,1292448,1292449,1292451,1292452,1292453,1292454,1292455,1292458,1292459,1292460,1292461,1292462,1292463,1292464,1292465,1292466,1292467,1292468,1292469,1292470,1292471,1292472,1292473,1292474,1292475,1292476,1292477,1292478,1292479,1292480,1292646,1292647,1293504,1293511,1293524,1293528,1293531,1293538,1294032,1294033,1294034,1294035,1294036,1294037,1294038,1296268,1296269,1296270,1296271,1296272,1296273,1296274,1296276,1296277,1296278,1296279,1296280,1296281,1296282,1296283,1297591,1297592,1297593,1297594,1297595,1298128,1303879,1303880,1303881,1303882,1303883,1303884,1303885,1303886,1303887,1303888,1303889,1303890,1303891,1303892,1303894,1303895,1303896,1303897,1303898,1303899,1305483,1305484,1305485,1305940,1305941,1305942,1305943,1305944,1305945,1305946,1305947,1305948,1305949,1305950,1305952,1305953,1305954,1305955,1305956,1305957,1305958,1305959,1305960,1305961,1305962,1305963,1305964,1305965,1307075,1307088,1307116,1307120,1308821,1308823,1308824,1309629,1309630,1309631,1309632,1309633,1309634,1309642,1309644,1309645,1309646,1309647,1309648,1309657,1309658,1309659,1309660,1309661,1309662,1309663,1309664,1313686,1313687,1313688,1313689,1316915,1316916,1316917,1316918,1316919,1316920,1316921,1316922,1316923,1316924,1316925,1317479,1317481,1317482,1317483,1317484,1317485,1317486,1317487,1317488,1317489,1317491,1317492,1318713,1318714,1318715,1318716,1318717,1318718,1318719,1318720,1318722,1318723,1318724,1318725,1318726,1318727,1318728,1318729,1318730,1318732,1318733,1318734,1318735,1318736,1318737,1318738,1318739,1318740,1318741,1319970,1319971,1319972,1319973,1319974,1319975,1319976,1319977,1319978,1319979,1319980,1319981,1319982,1319983,1319984,1319985,1319986,1319987,1319990,1319991,1319992,1319993,1319994,1319995,1319996,1319997,1319998,1319999,1320000,1320001,1320002,1322127,1322128,1322129,1322130,1322131,1322132,1322133,1322135,1322136,1322137,1322138,1322139,1322140,1322141,1322142,1322143,1322144,1323547,1323548,1323549,1323550,1323551,1323552,1323554,1323555,1323556,1323557,1323558,1323559,1324713,1324719,1324734,1324735,1324772,1327686,1327687,1327688,1327690,1327691,1329699,1329700,1329701,1329702,1329703,1331247,1331248,1333150,1333151,1333152,1333153,1333154,1333156,1333157,1333158,1333159,1333160,1333161,1333162,1333163,1333164,1333167,1333168,1333169,1333170,1333171,1333172,1334447,1334449,1334450,1334451,1334452,1334453,1334454,1334455,1334456,1334457,1334458,1334459,1334461,1334462,1334463,1334464,1334465,1334466,1334467,1334468,1334469,1334470,1334471,1334472,1334473,1334474,1334475,1334476,1334477,1334478,1334479,1334480,1334481,1334482,1334483,1334484,1334485,1334486,1334488,1334489,1334490,1334491,1334492,1334493,1334494,1334495,1334497,1334498,1334499,1334500,1334502,1334503,1334504,1334505,1334506,1334507,1334508,1334509,1334510,1334512,1334513,1334514,1334515,1334516,1334517,1334518,1334519,1334520,1334522,1334523,1334524,1334525,1334526,1334528,1334529,1334530,1334531,1334533,1334534,1334535,1334536,1334537,1334538,1334539,1334540,1334541,1334543,1334544,1334545,1334546,1334548,1334549,1335521,1335526,1335537,1335552,1335722,1335723,1335724,1335726,1335727,1335728,1335729,1335730,1335731,1335732,1335733,1335734,1335735,1335736,1335737,1335738,1335739,1335740,1335741,1335742,1335743,1335744,1335745,1335746,1335747,1335748,1335749,1335750,1335751,1335752,1335753,1335754,1337858,1337865,1337871,1338453,1338454,1338455,1338456,1338457,1338458,1338459,1338460,1338461,1338463,1338464,1338465,1338466,1338467,1338468,1338469,1338471,1338472,1338473,1338474,1338475,1338477,1338478,1338479,1338480,1338482,1338483,1338485,1338486,1338487,1338488,1338489,1338490,1338491,1338492,1338493,1338495,1338496,1338497,1338498,1338500,1338501,1338502,1338503,1339248,1339249,1339250,1339251,1339252,1339253,1339254,1339255,1339256,1339257,1339258,1339259,1521179,1521180,1521181,1521182,1521183,1521184,1521185,1521186,1521187,1521188,1521189,1521190,1521191,1521192,1521193,1521194,1521195,1521196,1521197,1521198,1521199,1521200,1521201,1521202,1523340,1523343,1523344,1523345,1523346,1523347,1523348,1523349,1523350,1523351,1524978,1524986,1524987,1524991,1524998,1525002,1525004,1525006,1525009,1525015,1525355,1525356,1525357,1525358,1525359,1525360,1525361,1525362,1525363,1525364,1525365,1525366,1525367,1525368,1525369,1525371,1525372,1525373,1525374,1526469,1526470,1526770,1526771,1526772,1526773,1526775,1526776,1526777,1526779,1526780,1526781,1526782,1526783,1526784,1526785,1526786,1526788,1526789,1526790,1526792,1526793,1526794,1526795,1526796,1526797,1526799,1526800,1526801,1526802,1526804,1526805,1526807,1526808,1526809,1526810,1526811,1526812,1526813,1526814,1526815,1526816,1526817,1526818,1526819,1526820,1526821,1526822,1526823,1526824,1526825,1526826,1526828,1526829,1526830,1526831,1526832,1526833,1526834,1526835,1526836,1526837,1526838,1526839,1526840,1526841,1526842,1526844,1526845,1526846,1526847,1526848,1526849,1527917,1527921,1527925,1527929,1527933,1527938,1527946,1527947,1527950,1527954,1527962,1527967,1527973,1527991,1527996,1528007,1528017,1528200,1528201,1528202,1528203,1528204,1528205,1528206,1528207,1528208,1528209,1528211,1528212,1528213,1528214,1528216,1528217,1528219,1528221,1528222,1528223,1528224,1528225,1528227,1528228,1528229,1528230,1528231,1528232,1528234,1528235,1528236,1528237,1528238,1528239,1528240,1528241,1528242,1528243,1528244,1530829,1530841,1530845,1530846,1530854,1530862,1530864,1531670,1531671,1531672,1531673,1531674,1531675,1531676,1531677,1531678,1531679,1531680,1531681,1531682,1531683,1531684,1531685,1531686,1531687,1531688,1531689,1531690,1531691,1531692,1531694,1531695,1531696,1531697,1531698,1531699,1531700,1531701,1531702,1531704,1531705,1531706,1532682,1532683,1532684,1532685,1532687,1532688,1532689,1532690,1532691,1532692,1532693,1532694,1532696,1532697,1532698,1532699,1532700,1532701,1532702,1532703,1532705,1532706,1532707,1532708,1532709,1532710,1532711,1532713,1532714,1532715,1532716,1532717,1532718,1532720,1532721,1532722,1532725,1532726,1532727,1532728,1536673,1536674,1536677,1536678,1536679,1536680,1536681,1536682,1536683,1536684,1536686,1536687,1540237,1540238,1540239,1540241,1540242,1540243,1540244,1540245,1540246,1540247,1540248,1540249,1540250,1540251,1540252,1540253,1540254,1540255,1540256,1540257,1540258,1540260,1540261,1540262,1540263,1540264,1540265,1540266,1540267,1540268,1540270,1540271,1540272,1540273,1540852,1540853,1540854,1540855,1540856,1540858,1540859,1540860,1540861,1540862,1540863,1540864,1540865,1540866,1540867,1540868,1540870,1540871,1540872,1540873,1542486,1542487,1542488,1542489,1542490,1542491,1542492,1542493,1542494,1542495,1542496,1542497,1542499,1542500,1542501,1542502,1542503,1542504,1542505,1542506,1542507,1542509,1543833,1543834,1543835,1543836,1543837,1543838,1543839,1543841,1543842,1543843,1543844,1543845,1543847,1543848,1543849,1543850,1543851,1543852,1543853,1543855,1543856,1543857,1543859,1543860,1543861,1543862,1546133,1546134,1546135,1546136,1546137,1546138,1546139,1546140,1547751,1547752,1547753,1547754,1547755,1547757,1547758,1547759,1547760,1547761,1547762,1547764,1547765,1547766,1547767,1547768,1547769,1549036,1549052,1549057,1549075,1549085,1549093,1549098,1549107,1549133,1549144,1549149,1549155,1549157,1549162,1549166,1549171,1549175,1549186,1549194,1549195,1549202,1549204,1549210,1552527,1552528,1552529,1552530,1552531,1552532,1552864,1552865,1552866,1552867,1552868,1552869,1552871,1552872,1552873,1552874,1552875,1552876,1552877,1552878,1552879,1552880,1552882,1552883,1552884,1552885,1552886,1552887,1552888,1552889,1552890,1552892,1552893,1552894,1552895,1552896,1552897,1552898,1552900,1552901,1552902,1552903,1552904,1552905,1552907,1555794,1555795,1555796,1555797,1555798,1555799,1555800,1555801,1555802,1555803,1555804,1555805,1555806,1555807,1555808,1555809,1555810,1555812,1555813,1555814,1555815,1555816,1555818,1555819,1555820,1555821,1555822,1555824,1555825,1555826,1555827,1555828,1555829,1555830,1555831,1555832,1555833,1555834,1555835,1555836,1555837,1555839,1555840,1555841,1555842,1555843,1555844,1555845,1555846,1555847,1555848,1555849,1555850,1555851,1557413,1557414,1557415,1557416,1557417,1557418,1557419,1557420,1557421,1557422,1557423,1557424,1557425,1557426,1557427,1557428,1557429,1557430,1557431,1557432,1557433,1557969,1557970,1557971,1557972,1557974,1557975,1557976,1557977,1557978,1557979,1557980,1557981,1557982,1557983,1557984,1557985,1557986,1557987,1557988,1557989,1557990,1557991,1557992,1557993,1557994,1557995,1557996,1557997,1557998,1557999,1564694,1564695,1564696,1564697,1564698,1564699,1564700,1564701,1564702,1564703,1564704,1564705,1564706,1564707,1564708,1564709,1564710,1564711,1564712,1564713,1564714,1564715,1564716,1564717,1564718,1564719,1564720,1564721,1564722,1564723,1564724,1564725,1564726,1566646,1566647,1566648,1566649,1566650,1566651,1566652,1566653,1566654,1566655,1566656,1567340,1567342,1567343,1567344,1567345,1567347,1567348,1567349,1567350,1567351,1567352,1567354,1567355,1567356,1567357,1567359,1567360,1567361,1567363,1567364,1567365,1567366,1567367,1567369,1567370,1568789,1568795,1568805,1568816,1568823,1568829,1568835,1568843,1568850,1568860,1568866,1568874,1568876,1568883,1568886,1568887,1568889,1568893,1568897,1568906,1568907,1568914,1568919,1568926,1568939,1568942,1568946,1569301,1569665,1570902,1570903,1570904,1570905,1570906,1570907,1570908,1570909,1570910,1570911,1571828,1571829,1571830,1571832,1571833,1571835,1571836,1571837,1571851,1571852,1571853,1571854,1571855,1571858,1571859,1571860,1571861,1571862,1571863,1571864,1571879,1571880,1571881,1571882,1571883,1571885,1571886,1571887,1571888,1571889,1571890,1571891,1571893,1571894,1571895,1571896,1571897,1571898,1571899,1576579,1576580,1576581,1576582,1576583,1576584,1576585,1576586,1576587,1576588,1576589,1576590,1576591,1576592,1576593,1576594,1576595,1576596,1576597,1576598,1576599,1576600,1576601,1576602,1576603,1576605,1576606,1576607,1576608,1576609,1576610,1576611,1576612,1576613,1576614,1576616,1576617,1576618,1576619,1576620,1576621,1576622,1576623,1576624,1576625,1576627,1576628,1576629,1576630,1576631,1576632,1576633,1576634,1576635,1576636,1576638,1576639,1576640,1576641,1576642,1576643,1576644,1576645,1576646,1576647,1576648,1576649,1576650,1576651,1576652,1576653,1576654,1576655,1576836,1576838,1576839,1576840,1576841,1576842,1576843,1576845,1576846,1576847,1576848,1576849,1577416,1577530,1577551,1577603,1577642,1577732,1577780,1577939,1578305,1578356,1578484,1578572,1578646,1578849,1578853,1578854,1578855,1578856,1578857,1578859,1578860,1578861,1578862,1578863,1578865,1578866,1578867,1578868,1578869,1578871,1578872,1578873,1578874,1578875,1578876,1578877,1578878,1578879,1578880,1578881,1578883,1578884,1578885,1578886,1578887,1578888,1578889,1578890,1578891,1578892,1578893,1578894,1578895,1578896,1578897,1578898,1578899,1578900,1578901,1578902,1578903,1578904,1578905,1578907,1578908,1578909,1578910,1578911,1578912,1578913,1578915,1578916,1578917,1578918,1578919,1578920,1578921,1578922,1578924,1578925,1578926,1578927,1578928,1578929,1578930,1578931,1578932,1578933,1578934,1578935,1578936,1578937,1578938,1578939,1578940,1578941,1578942,1578943,1578944,1578945,1578946,1578947,1578948,1578949,1578957,1579238,1579288,1579696,1582381,1583554,1583556,1583557,1583558,1583559,1583560,1583561,1583562,1584434,1584435,1584436,1584438,1584439,1584440,1584442,1584443,1584444,1584445,1584447,1584958,1584959,1584960,1584961,1584963,1584964,1584965,1584966,1584967,1584968,1584970,1584971,1584972,1584973,1584974,1584975,1584976,1584977,1584979,1584980,1584981,1584982,1584983,1584984,1584985,1584986,1584987,1584988,1584989,1584991,1584992,1584993,1584994,1585418,1585419,1585420,1585421,1585422,1585423,1585424,1585425,1585426,1585427,1585428,1585429,1585431,1585432,1585434,1585435,1585436,1585437,1585438,1585439,1585440,1585441,1585442,1585443,1585444,1585445,1585446,1587385,1590399,1590401,1590402,1590403,1590404,1590405,1590406,1590735,1590736,1590737,1590738,1590739,1590741,1590742,1590743,1590745,1590746,1590747,1590748,1590749,1590750,1590751,1590752,1590753,1590754,1590755,1590756,1590757,1590759,1590760,1590761,1590762,1590763,1590764,1590765,1590766,1590767,1590768,1590769,1590770,1590773,1590774,1590776,1590777,1590778,1590779,1590780,1590781,1590782,1590783,1590784,1590996,1592216,1592222,1592225,1592241,1592247,1592252,1592259,1592260,1592262,1592278,1592283,1592288,1592291,1592299,1592325,1592333,1592336,1592340,1592346,1592351,1592357,1592779,1592780,1592781,1592782,1592783,1592784,1592785,1592786,1592787,1592788,1594650,1594651,1594652,1594653,1594654,1594655,1594657,1594658,1594659,1596211,1596212,1596213,1596214,1596215,1596216,1596217,1596218,1596219,1596220,1596221,1596222,1596224,1596225,1596226,1596227,1596228,1599275,1599276,1599277,1599278,1599279,1599280,1599281,1599282,1599283,1599284,1599285,1599286,1599287,1599288,1599289,1599290,1599428,1599429,1599430,1599431,1599432,1599433,1599435,1599436,1599438,1599439,1599440,1599441,1599442,1599443,1599444,1599445,1599446,1599447,1599448,1599449,1599450,1599451,1599452,1599453,1599455,1599456,1599457,1599459,1599461,1599462,1599463,1599464,1599465,1599466,1599468,1599469,1599470,1599471,1599472,1599473,1599475,1599476,1599477,1599478,1599479,1599480,1599481,1599482,1599484,1599485,1599486,1599487,1599488,1599489,1599490,1599491,1599492,1599493,1599495,1599496,1599497,1599498,1600180,1600181,1600182,1600183,1600185,1600186,1600187,1601387,1601388,1601389,1601390,1601391,1601392,1601393,1601395,1601396,1601397,1601398,1601399,1601400,1601401,1601402,1601403,1601404,1601405,1601406,1601407,1601408,1601409,1601410,1601411,1601412,1601413,1601414,1601416,1601417,1601418,1601419,1601421,1601422,1601423,1601424,1601426,1601427,1601428,1601429,1603170,1603171,1604531,1604533,1604534,1604535,1604536,1604537,1604538,1604539,1604540,1604542,1604543,1604847,1604848,1604849,1604850,1604851,1604852,1606904,1606905,1606906,1606907,1606908,1606909,1606910,1606911,1606913,1606914,1606915,1606916,1606917,1606918,1606919,1606920,1606921,1606922,1606923,1606924,1606925,1606926,1606927,1606928,1606929,1606930,1606931,1606932,1606933,1607225,1607226,1607227,1607229,1607230,1607231,1607232,1611118,1611119,1611121,1611122,1611123,1611124,1611125,1611126,1611127,1611128,1611129,1611130,1611131,1611132,1611133,1611134,1611135,1611136,1611137,1611138,1611140,1611141,1611142,1611143,1611144,1611145,1611148,1611149,1611150,1611151,1611153,1611154,1611155,1611156,1611158,1611159,1611160,1611162,1611163,1611164,1611167,1611168,1612881,1612882,1612883,1612884,1612885,1612887,1612888,1612889,1612890,1612891,1612892,1612893,1612894,1612895,1612896,1612897,1612898,1612899,1612900,1612901,1612902,1612904,1612905,1612906,1612907,1612908,1612909,1612910,1612911,1612912,1612913,1612914,1612915,1612917,1612918,1612919,1612920,1612921,1612922,1612923,1612924,1612925,1612926,1612927,1612929,1612930,1612931,1612932,1612933,1612934,1612935,1612936,1612937,1612938,1612939,1614084,1614085,1614086,1614087,1614088,1614089,1614090,1614091,1614092,1614093,1614094,1614095,1614096,1614097,1614099,1614100,1614101,1614102,1614103,1614104,1614105,1614106,1614107,1614108,1614109,1614110,1614111,1614112,1614113,1614114,1614115,1614116,1614117,1614118,1614119,1614120,1614121,1614122,1614123,1614124,1614125,1614126,1614127,1614879,1614880,1614886,1614896,1614919,1614922,1614924,1614934,1614949,1614957,1614965,1614973,1614979,1614983,1614991,1615000,1615006,1615011,1615014,1615020,1615025,1615026,1615030,1615032,1615037,1615042,1615096,1615118,1615134,1615140,1615150,1615498,1615499,1615501,1615502,1615503,1615504,1615505,1615506,1615507,1615508,1615509,1615510,1615511,1615512,1615513,1615515,1615516,1615517,1615518,1615520,1615521,1615522,1615523,1615524,1615525,1615526,1615527,1615528,1615529,1615530,1615531,1615532,1615533,1615534,1615535,1615536,1615537,1615538,1615540,1615541,1615542,1615543,1615544,1615545,1615546,1615547,1615548,1615549,1615551,1615552,1616704,1616705,1616706,1616707,1616708,1616709,1616710,1616711,1616712,1616713,1616714,1616715,1616716,1617112,1617113,1617114,1617115,1617116,1617117,1617118,1617119,1617120,1617121,1617122,1617123,1618251,1618252,1618253,1618254,1618255,1618256,1618257,1618258,1618259,1618260,1618261,1618262,1618263,1618264,1618265,1618266,1618267,1618268,1618269,1618270,1618271,1618274,1618275,1618276,1618277,1618278,1618279,1618280,1618281,1618282,1618283,1618284,1618285,1618286,1618288,1618289,1618290,1618291,1618292,1618293,1618294,1618295,1618296,1618297,1618299,1618300,1618301,1618302,1618303,1618304,1618305,1618306,1618307,1618309,1618310,1618311,1618312,1618313,1618315,1618316,1618317,1618319,1618320,1618321,1618322,1618323,1618324,1618325,1618326,1618327,1618328,1618329,1618330,1618332,1618333,1618334,1618335,1618336,1618337,1618338,1618340,1618341,1618342,1618343,1618344,1618345,1621161,1621162,1621163,1621164,1624977,1624978,1624979,1624980,1624981,1624982,1624983,1624984,1624986,1624987,1624988,1624989,1624990,1626666,1626667,1626668,1626669,1626670,1626671,1626672,1626674,1626675,1626676,1626677,1626678,1626679,1626680,1626681,1626682,1626683,1626684,1626685,1626686,1626688,1626689,1626690,1626691,1626692,1626694,1626695,1626697,1626698,1626699,1626700,1626701,1626703,1626704,1626705,1626706,1626707,1626709,1626710,1626711,1626712,1626714,1626715,1626716,1626717,1626718,1626719,1626721,1626722,1627619,1627620,1627622,1627623,1627624,1627625,1627626,1627627,1627629,1627630,1627631,1627868,1627870,1628951,1628952,1628953,1628954,1628955,1628956,1628957,1628959,1628960,1628961,1628962,1628963,1628965,1628966,1628967,1628968,1628969,1628971,1628972,1628973,1628974,1628975,1628976,1628978,1628979,1628980,1628981,1628982,1628983,1628984,1628985,1628986,1628988,1628989,1628990,1628991,1628992,1628994,1628998,1628999,1629000,1629001,1629002,1629003,1629004,1629005,1629006,1629007,1629008,1629009,1629010,1629011,1629012,1629013,1629014,1629016,1629017,1629018,1629019,1629020,1629021,1629022,1629023,1629024,1629025,1629026,1629027,1629028,1629029,1629030,1629031,1629032,1629033,1629034,1629035,1629036,1629037,1629038,1629039,1629040,1629041,1629043,1629044,1629045,1629047,1629048,1629049,1629050,1629051,1629052,1629053,1629054,1629055,1629056,1630584,1631823,1631860,1631864,1631872,1631888,1631934,1631936,1631942,1631949,1631960,1631969,1631971,1631976,1631977,1631988,1631991,1631997,1632000,1632003,1632004,1632006,1632008,1632031,1632054,1632060,1632061,1632062,1632073,1632074,1632075,1632082,1632087,1632088,1632104,1632105,1632108,1632112,1632132,1632147,1632152,1632157,1652765,1652766,1652767,1653272,1653273,1653274,1653275,1653276,1656496,1656497,1656498,1656499,1656500,1656501,1656502,1656504,1656505,1656506,1656508,1656509,1656510,1656511,1656512,1657891,1657892,1657893,1657894,1657896,1657897,1657898,1657899,1657900,1657901,1657902,1657904,1657905,1657907,1657908,1657909,1657910,1657911,1657912,1657913,1657914,1657915,1657916,1657917,1657918,1657919,1657920,1657922,1657923,1657924,1657925,1657926,1657927,1657928,1657929,1657930,1657931,1657932,1657933,1657934,1657935,1657936,1657937,1657938,1657939,1657940,1657941,1657942,1657943,1657944,1657945,1659344,1659346,1659347,1659348,1659349,1659350,1659351,1659352,1659353,1669692,1669695,1669696,1669697,1669698,1669699,1669700,1669701,1669702,1669703,1669704,1669705,1669706,1669707,1669708,1669709,1669710,1669711,1669712,1669713,1669714,1669715,1669716,1669718,1669719,1669721,1669722,1669723,1669724,1669725,1669727,1669728,1697569,1697570,1697571,1697572,1697573,1697574,1697576,1697577,1697727,1697728,1697729,1697731,1697732,1697733,1697734,1697735,1697736,1697737,1697738,1697739,1697740,1697741,1697742,1697805,1697807,1697808,1697809,1697810,1697812,1697813,1697814,1697816,1697817,1697818,1697819,1697820,1697821,1697967,1697969,1697970,1697971,1697972,1697973,1697974,1697975,1697976,1697978,1697979,1697980,1697981,1697982,1697983,1697984,1697985,1697986,1697987,1699192,1699193,1699194,1699195,1699196,1699197,1699198,1699200,1699201,1699381,1699382,1699383,1699384,1699385,1699386,1699387,1699389,1699391,1699392,1704522,1704524,1704525,1704526,1704527,1704529,1704530,1704531,1705013,1705014,1705015,1706701,1706703,1706704,1706705,1706706,1706707,1706708,1706709,1706710,1706711,1706712,1706713,1706714,1706715,1706716,1706717,1706718,1706719,1706720,1706721,1706723,1706724,1706725,1706726,1706727,1706728,1706729,1706730,1706732,1706733,1708028,1708029,1708030,1708031,1708032,1708033,1708034,1708035,1708036,1708037,1708038,1708039,1708040,1708041,1708042,1708043,1708044,1708045,1708046,1708047,1708048,1708049,1708050,1708051,1708053,1708054,1708055,1708056,1708057,1708058,1708059,1708061,1708062,1708063,1709579,1709580,1709581,1709582,1709583,1709584,1709585,1709586,1709588,1709589,1711066,1711067,1711068,1711069,1711070,1711071,1711072,1711073,1733216,1733217,1733218,1733219,1733220,1734847,1734848,1734849,1734850,1734851,1734852,1734853,1735052,1735053,1735055,1735056,1735057,1735058,1735059,1735060,1735061,1735062,1735063,1735064,1735065,1735066,1735067,1735068,1735069,1735070,1735071,1735072,1735073,1735074,1735075,1735076,1735077,1735079,1735080,1735081,1735082,1735083,1735084,1735085,1735086,1735087,1735088,1735089,1735090,1735091,1735092,1735094,1735095,1735096,1735097,1735098,1735099,1735100,1735101,1735102,1735104,1735107,1735108,1735109,1735110,1735111,1735112,1735113,1735114,1735115,1735116,1735117,1735118,1735119,1735120,1735121,1735122,1735123,1735124,1735125,1735126,1735128,1735129,1735130,1735131,1735132,1735133,1735134,1735135,1735136,1735137,1735138,1735139,1735140,1735141,1735142,1735143,1735144,1735146,1735147,1735148,1735149,1735150,1738270,1738271,1738272,1738273,1738274,1738275,1738276,1738278,1738279,1738280,1738281,1738282,1738283,1738284,1738285,1738287,1738288,1738289,1738290,1738291,1738292,1738293,1738295,1738296,1738297,1738298,1738299,1738300,1738301,1738302,1738303,1738304,1738305,1738478,1738479,1738480,1738481,1738482,1738483,1738484,1738485,1738487,1738488,1738489,1738490,1738491,1738492,1738493,1738494,1738989,1738990,1738992,1738993,1738994,1738995,1738996,1741468,1741469,1741470,1741471,1741472,1741473,1741474,1741475,1741476,1741477,1741478,1741479,1744524,1744525,1744526,1744527,1744528,1744529,1744530,1744531,1744532,1744533,1744534,1744535,1744536,1744537,1744538,1744539,1744540,1744541,1744542,1746475,1746476,1746477,1746478,1746480,1746481,1746482,1746483,1746484,1746485,1746486,1749976,1749977,1749978,1751452,1751453,1751454,1751455,1751456,1751457,1751458,1751460,1751461,1751462,1751463,1751464,1751466,1751467,1751468,1751469,1751470,1751471,1751474,1751475,1751476,1751477,1751478,1751479,1751480,1751481,1751482,1751483,1751485,1752055,1752056,1752057,1752058,1752059,1752060,1752061,1752628,1752645,1752651,1752657,1752663,1752680,1752691,1752699,1752707,1752731,1752738,1752755,1752794,1752864,1752875,1753334,1753335,1753336,1753337,1753339,1753340,1753341,1753342,1753343,1753344,1754161,1754163,1754164,1754165,1754166,1754168,1754169,1754170,1754171,1754173,1754174,1754175,1754177,1754179,1754180,1754181,1754182,1754183,1754184,1754185,1754186,1754187,1754188,1754189,1754190,1754191,1754192,1754193,1754194,1754195,1754196,1754610,1757810,1757842,1757849,1757857,1757863,1757873,1757887,1757888,1757892,1757894,1757904,1757906,1757909,1757918,1757924,1757936,1757938,1757944,1757973,1757979,1757984,1757992,1757996,1758005,1758045,1758050,1758058,1758065,1759140,1759141,1759143,1759144,1759145,1762260,1762261,1762262,1762263,1762264,1762265,1762266,1762267,1762268,1762269,1762270,1762271,1762272,1762274,1762275,1762276,1762277,1762278,1762279,1762280,1762281,1762284,1762285,1762287,1762288,1762289,1762290,1762291,1762292,1762293,1762294,1762295,1762296,1767672,1767673,1767674,1767675,1767676,1767677,1767678,1767680,1767681,1767682,1767683,1767684,1767685,1767686,1767687,1767688,1767689,1767690,1767691,1767692,1767694,1767695,1767696,1767697,1767698,1767699,1767700,1767701,1767702,1767919,1767925,1767931,1767968,1767973,1767982,1767991,1767997,1768001,1768004,1768036,1768050,1768054,1768059,1768083,1768095,1768098,1768109,1768110,1768117,1768125,1768128,1768131,1768135,1768137,1768141,1768148,1768171,1768192,1768203,1768209,1770829,1770830,1770831,1770832,1770833,1770834,1770835,1770836,1770837,1770838,1770839,1770840,1770841,1770842,1770843,1770844,1770845,1770846,1770847,1770848,1770849,1770850,1770851,1770852,1770853,1770855,1770856,1770857,1770858,1770859,1770860,1770861,1770862,1770864,1770865,1770866,1770867,1770868,1770869,1770870,1770871,1770872,1770873,1770875,1770876,1770877,1770878,1770879,1770880,1783300,1783301,1783302,1783303,1783304,1783305,1783306,1786307,1786308,1786309,1786310,1786312,1786313,1786314,1786315,1786316,1786317,1786318,1786319,1786320,1786321,1786322,1786323,1786324,1786325,1786326,1786327,1786328,1786329,1786331,1786332,1786333,1786334,1786335,1786336,1790081,1790082,1790083,1790084,1790085,1790086,1790087,1790088,1790089,1790090,1790091,1790092,1790093,1790094,1790095,1790096,1790097,1790098,1790099,1790100,1790346,1790347,1790348,1790349,1790350,1790352,1790372,1790373,1790374,1790375,1790376,1790377,1790378,1790379,1790705,1790706,1790707,1790708,1790709,1790710,1790711,1790712,1800158,1800174,1800176,1800189,1800193,1800196,1800214,1800215,1800224,1800228,1800232,1800257,1800272,1800279,1800290,1800328,1800344,1800351,1800362,1800387,1800413,1800419,1800432,1800436,1800438,1800439,1800470,1800485,1804095,1804096,1804097,1804098,1804099,1804100,1804101,1804102,1804104,1804105,1804106,1804107,1804108,1804109,1804110,1804111,1804112,1804113,1804115,1804116,1804117,1804118,1804119,1804120,1804121,1804122,1804123,1804124,1804125,1804126,1804127,1804128,1804129,1804130,1804131,1804132,1804134,1804135,1808749,1808751,1808752,1808753,1808755,1808756,1808757,1808758,1808759,1808760,1808761,1808762,1808763,1808764,1808765,1808766,1808767,1808768,1808769,1808770,1808771,1808772,1808920,1808925,1808954,1808956,1808960,1808994,1809001,1809008,1809012,1809025,1809041,1809051,1809061,1809065,1809078,1809082,1809088,1809158,1809163,1809171,1809177,1809184,1809195,1809199,1809207,1809213,1809219,1809225,1809231,1811321,1811323,1811325,1811326,1811327,1811328,1811329,1811330,1814540,1814541,1814542,1814543,1814544,1814546,1814547,1814747,1814748,1814749,1814750,1814751,1814752,1814753,1814755,1814756,1814757,1814758,1814759,1814760,1814761,1814764,1814765,1814766,1814767,1814769,1814770,1814771,1814772,1814774,1814775,1814776,1814777,1814778,1814780,1814781,1814782,1814783,1814784,1814785,1814786,1814787,1814788,1814789,1814790,1814791,1814792,1814793,1814794,1814795,1814796,1814797,1814798,1814799,1814801,1814802,1814803,1814804,1814805,1814806,1814807,1814808,1814809,1814810,1814811,1814812,1814813,1814814,1814815,1814817,1814818,1814819,1814820,1814822,1814823,1814824,1814826,1814827,1814828,1814829,1814830,1814831,1814833,1817500,1817501,1817502,1817503,1817504,1817505,1817506,1817507,1817509,1817510,1817612,1817613,1817614,1817615,1817617,1817618,1817619,1817620,1817622,1817623,1817624,1817625,1817626,1817628,1817629,1818078}'::bigint[]))
11. 5.556 5.556 ↑ 1.0 1 2,778

Index Scan using readings_pkey on readings r (cost=0.42..8.44 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=2,778)

  • Index Cond: (id_readings = d.id_readings)
12. 2.778 2.778 ↑ 22.0 1 2,778

Index Scan using index_id_pdv_73 on pdv_73 p_2 (cost=0.28..0.67 rows=22 width=86) (actual time=0.001..0.001 rows=1 loops=2,778)

  • Index Cond: (id_pdv = r.id_pdv)
13. 0.905 390.717 ↓ 10.4 1,869 1

HashAggregate (cost=182,987.05..182,988.85 rows=180 width=32) (actual time=390.449..390.717 rows=1,869 loops=1)

  • Group Key: pd.pdv_to
14. 0.191 389.812 ↓ 10.4 1,881 1

Append (cost=91,491.36..182,986.60 rows=180 width=32) (actual time=244.431..389.812 rows=1,881 loops=1)

15. 0.160 244.617 ↓ 9.8 886 1

Group (cost=91,491.36..91,491.95 rows=90 width=32) (actual time=244.429..244.617 rows=886 loops=1)

  • Group Key: pd.pdv_to
16. 1.657 244.457 ↓ 7.5 887 1

Sort (cost=91,491.36..91,491.65 rows=119 width=32) (actual time=244.413..244.457 rows=887 loops=1)

  • Sort Key: pd.pdv_to
  • Sort Method: quicksort Memory: 94kB
17. 3.529 242.800 ↓ 7.5 887 1

Hash Join (cost=897.78..91,487.25 rows=119 width=32) (actual time=92.105..242.800 rows=887 loops=1)

  • Hash Cond: (pd.pdv_from = (p.code_pdv)::text)
18. 155.335 160.366 ↓ 218.6 26,013 1

Bitmap Heap Scan on pdv_distance pd (cost=891.28..91,476.29 rows=119 width=64) (actual time=13.141..160.366 rows=26,013 loops=1)

  • Recheck Cond: (inf_5 = 1)
  • Filter: ((NOT (hashed SubPlan 2)) AND (masque = 73))
  • Rows Removed by Filter: 998
  • Heap Blocks: exact=23,318
19. 5.017 5.017 ↑ 1.8 27,011 1

Bitmap Index Scan on index_pdv_distance_inf_5 (cost=0.00..886.75 rows=47,775 width=0) (actual time=5.017..5.017 rows=27,011 loops=1)

  • Index Cond: (inf_5 = 1)
20.          

SubPlan (for Bitmap Heap Scan)

21. 0.014 0.014 ↑ 1.5 132 1

CTE Scan on filtered_pdv (cost=0.00..4.00 rows=200 width=78) (actual time=0.001..0.014 rows=132 loops=1)

22. 0.024 78.905 ↑ 1.5 132 1

Hash (cost=4.00..4.00 rows=200 width=78) (actual time=78.905..78.905 rows=132 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
23. 78.881 78.881 ↑ 1.5 132 1

CTE Scan on filtered_pdv p (cost=0.00..4.00 rows=200 width=78) (actual time=78.503..78.881 rows=132 loops=1)

24. 0.175 145.004 ↓ 11.1 995 1

Group (cost=91,491.36..91,491.95 rows=90 width=32) (actual time=144.797..145.004 rows=995 loops=1)

  • Group Key: pd_1.pdv_from
25. 2.138 144.829 ↓ 8.4 998 1

Sort (cost=91,491.36..91,491.65 rows=119 width=32) (actual time=144.780..144.829 rows=998 loops=1)

  • Sort Key: pd_1.pdv_from
  • Sort Method: quicksort Memory: 102kB
26. 3.864 142.691 ↓ 8.4 998 1

Hash Join (cost=897.78..91,487.25 rows=119 width=32) (actual time=13.078..142.691 rows=998 loops=1)

  • Hash Cond: (pd_1.pdv_to = (p_1.code_pdv)::text)
27. 134.022 138.790 ↓ 219.5 26,124 1

Bitmap Heap Scan on pdv_distance pd_1 (cost=891.28..91,476.29 rows=119 width=64) (actual time=12.923..138.790 rows=26,124 loops=1)

  • Recheck Cond: (inf_5 = 1)
  • Filter: ((NOT (hashed SubPlan 3)) AND (masque = 73))
  • Rows Removed by Filter: 887
  • Heap Blocks: exact=23,318
28. 4.754 4.754 ↑ 1.8 27,011 1

Bitmap Index Scan on index_pdv_distance_inf_5 (cost=0.00..886.75 rows=47,775 width=0) (actual time=4.754..4.754 rows=27,011 loops=1)

  • Index Cond: (inf_5 = 1)
29.          

SubPlan (for Bitmap Heap Scan)

30. 0.014 0.014 ↑ 1.5 132 1

CTE Scan on filtered_pdv filtered_pdv_1 (cost=0.00..4.00 rows=200 width=78) (actual time=0.001..0.014 rows=132 loops=1)

31. 0.017 0.037 ↑ 1.5 132 1

Hash (cost=4.00..4.00 rows=200 width=78) (actual time=0.037..0.037 rows=132 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
32. 0.020 0.020 ↑ 1.5 132 1

CTE Scan on filtered_pdv p_1 (cost=0.00..4.00 rows=200 width=78) (actual time=0.001..0.020 rows=132 loops=1)

Execution time : 430.011 ms