explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZeQ8

Settings
# exclusive inclusive rows x rows loops node
1. 1.728 896.969 ↓ 1,671.0 1,671 1

Nested Loop (cost=1,647.77..6,278.88 rows=1 width=120) (actual time=19.225..896.969 rows=1,671 loops=1)

2.          

CTE rc

3. 10.835 10.835 ↓ 1,466.0 1,466 1

Index Scan using collections_2_tsrange_idx on collections (cost=0.55..2.57 rows=1 width=88) (actual time=0.148..10.835 rows=1,466 loops=1)

  • Index Cond: (tsrange(data_start, data_end, '[]'::text) && '["2019-09-30 22:17:18","2019-09-30 22:17:48"]'::tsrange)
  • Filter: (metadata @> '{}'::jsonb)
4. 0.143 893.570 ↓ 1,671.0 1,671 1

Nested Loop (cost=1,645.20..6,275.27 rows=1 width=267) (actual time=19.210..893.570 rows=1,671 loops=1)

5. 5.367 890.085 ↓ 1,671.0 1,671 1

Hash Join (cost=1,644.92..6,274.11 rows=1 width=200) (actual time=19.198..890.085 rows=1,671 loops=1)

  • Hash Cond: (files_delete_road_20190930.partition_id = partitions.id)
6. 8.391 877.950 ↓ 49.1 70,993 1

Nested Loop (cost=0.56..4,625.96 rows=1,445 width=59) (actual time=0.416..877.950 rows=70,993 loops=1)

7. 11.949 11.949 ↓ 1,466.0 1,466 1

CTE Scan on rc (cost=0.00..0.02 rows=1 width=56) (actual time=0.149..11.949 rows=1,466 loops=1)

8. 669.962 857.610 ↓ 6.9 48 1,466

Append (cost=0.56..4,625.87 rows=7 width=19) (actual time=0.271..0.585 rows=48 loops=1,466)

9. 105.552 105.552 ↓ 16.0 48 1,466

Index Scan using files_delete_road_20190930_collection_id_collection_time_idx on files_delete_road_20190930 (cost=0.56..2,312.19 rows=3 width=19) (actual time=0.035..0.072 rows=48 loops=1,466)

  • Index Cond: ((collection_id = rc.id) AND (collection_id = ANY ('{168809179,169570444,169583348,170198735,168797621,168805325,168814445,168816292,168817725,168913406,168917972,169014716,169026868,169028592,169030589,169031419,169032835,168832141,168833231,168838331,168859771,169022114,169026458,169102354,169740490,168838703,168863639,168863646,168864948,168865909,168866575,168867458,168870069,168871902,168835749,168848880,168825340,168850391,168817453,168891625,169063242,168862333,168863671,168868994,168791943,168793561,168793635,168795409,168796464,169782042,168903054,168903461,168903672,168904419,168906742,168816206,168817317,168961943,168949193,168953995,168987739,169050484,168822991,168828029,168834536,168836460,168838487,168839440,168839947,168902681,168906703,168898916,168902244,168911369,168911968,168827370,168827725,168828352,168829341,168830529,168831040,168831312,168864120,168864584,168869084,168870454,168788293,168791989,168792092,168793166,168793594,168794735,168795907,168796313,168877640,168777694,168883822,168783306,169031662,169097654,169249606,169544048,169558670,169581500,169665791,168809413,168810917,168801956,168843102,168847214,168851196,168848397,168805799,168811880,169122985,169553556,169761750,168904451,168952749,169118574,169141603,169253351,169308584,169340437,169401192,169547820,169550622,169566283,169581220,169582700,168835691,168836267,168906278,168967451,168816931,168827032,168830585,168833792,168834635,168837590,168789306,168830105,168851908,168852002,168864326,168805539,168807097,168826002,168857372,168752715,168753596,168754024,168754147,168763001,168765011,168932497,168976797,168980363,168987121,168987597,169149841,169192797,169531578,169659115,169663808,169665616,169726968,169100044,169125458,169126494,169268824,169269870,169277700,169282443,169543084,169551593,168759095,168761623,168762248,168763033,168763730,168764071,168764273,168831751,168833804,168836543,168838000,168902487,168902879,168901156,168840331,168837540,168838742,168840289,168877987,168812885,168813926,168816325,169069671,169071068,168838855,168840207,168840976,168841381,168841893,168843078,168843570,168844932,168848240,168848595,168789215,168789606,168790968,168798207,168818921,168791773,168789594,168789347,168791443,168812964,168789047,168788468,168791469,168844143,168903432,168911281,168911693,168918947,168925936,168935908,169084114,169095839,169135739,169140828,169240612,169068134,169072161,169083507,169107426,169121707,169123018,168832393,168826183,168811420,168832519,168852107,168852348,169017498,169051203,169093655,169121317,169070811,169000711,168987895,169064327,168992774,168990565,169134043,168993960,168877095,168883566,168884933,169759866,168845577,168846599,168847833,168847867,168861379,168861664,168864658,168865140,168865416,168868213,168870518,168870902,168871012,168879358,168882495,168884142,168895675,168898311,168899223,168954723,169015062,169017455,169019850,169024711,169024953,169121807,169137123,168734854,168737919,168754069,168762703,168771119,168771693,168777817,168786200,168787459,168815278,168818346,168818590,168823563,168826428,168828110,168829307,168830307,168834336,168834869,168839788,168997972,169003469,169003484,169006604,169008712,169010782,169017963,169022066,169023102,169023160,169072352,169148780,168999406,169000021,168859569,168856590,168838177,169000888,168992339,168999711,170073340,168773609,168776336,168776676,168779689,168780194,168780799,168781024,169123737,169126006,169262247,169664186,169769255,170190500,168841759,168844843,168846059,168846712,168847625,168989015,168991307,168993052,168993583,169732013,170098453,170105205,170123701,170145301,170152980,170175730,170220154,168814306,168816651,168817444,169107670,170122139,168735650,168730266,168754062,168756467,168982966,168986008,168991861,169005789,169009501,169013122,169013924,169017476,169089314,169120997,169137427,169284075,169580064,169666058,169782908,168841847,168842479,168865826,169001282,168959834,168976931,168981482,168989181,168991435,168991572,168778686,168808109,168808793,168838391,168840972,170094588,170132407,170185350,170188602,168828969,168830813,168834431,168834526,168836150,168836948,168837276,168837343,168838301,168839889,168868482,168870227,169729494,168943239,168896550,168943601,168950704,169000009,168974786,169000054,169059649,168948162,168994928,169053617,169085379,169130998,169275970,169730133,169712661,169737575,169801851,168812170,168812342,168813353,168819595,168820730,168961616,168995130,169070185,169079571,169072225,169055478,169066078,169091292,169037590,169284144,170122238,168810287,168810955,168815060,168823711,168827347,168827837,168828594,168900234,168931066,168968077,169017486,169018461,169031700,169032292,169038561,169074429,169074701,169085212,169087267,169208602,169022048,169022212,169066881,169067989,168829034,168836020,168866598,169001298,169005176,169020636,169002773,169004819,169006242,169006530,168999652,168964725,168965422,169072380,168859855,168998999,169006216,169006730,169008046,169008999,169011610,169015689,168865280,169020200,169003750,169013018,168869673,168865006,168867280,169020747,169006419,168999515,169004786,169008145,169008915,169009372,169012036,169013594,169013683,169013804,168766016,168766221,168766274,168767113,168767160,168767579,169069875,168983499,168917883,168808925,169115227,168966520,168953833,169067973,169547574,168953414,169087043,168896557,168906991,168915861,168963528,168904689,168921292,169013224,169111765,169730353,168742366,168743269,168744514,168746471,168747418,168747872,168748577,168748821,168750276,169022952,169048435,169052713,169054371,169055635,169104719,169072191,169133197,169077221,168969454,168969826,168973309,168977316,168984940,169188275,169217267,169075505,169017620,169039847,169079636,169026295,169040218,169041000,169054927,168845362,168845690,168971614,168973942,169022427,169024425,169025485,169026881,168820817,168820966,168825724,168826196,168827071,168957836,168949618,168949959,169015612,168882813,169019733,169040403,168869272,169026527,170660259,168997472,169002425,170645417,168871308,168876457,168876837,168880027,168880368,169108496,169116003,168829686,168831910,168833891,168833953,168834286,168834377,168834394,168835351,168836099,168836223,169003225,169014185,169050864,169062236,169090413,169091192,168978315,169002767,169007608,168979557,169000669,169023130,169024311,168998963,169006363,169013358,169019021,169087300,169088109,169089839,168933886,169019601,169001507,169009341,169016101,169081627,169075506,169078534,169082437,168930757,168880403,168880675,169066682,168968991,168969096,168917151,168917933,168920341,169000835,168970041,168970043,168970941,169067291,169067792,168810848,168812046,168814160,168814447,168866642,168993954,169000904,169003237,169011199,169016739,169022469,169022817,169023032,169024020,168787402,168787950,168973888,169029729,168946990,168976505,168977686,168979090,168835633,168835900,168837293,168838058,168905321,168948829,168967676,168975566,168783722,168784310,168761827,168765273,168798045,168952165,168958004,168830781,169084852,169090862,169103780,169105354,169107211,169107880,169110848,168828959,168835493,168884229,168889233,168873445,168852396,168889562,169018018,168918871,169072672,169075998,169076610,169079702,169082411,169082702,169086435,169093657,169099775,168799450,168800859,168804933,168805074,168805105,169063688,169072861,169076596,169083343,169087393,169087554,169087635,169089413,169089600,169089849,169091474,168909403,168912829,168971759,168976365,169064117,169070214,169071851,169087319,169028845,168766856,169061378,169066180,169071803,169071881,169072794,169079265,169081798,169083384,169083486,169083549,169083651,169084549,169084971,168752861,168752897,168753590,168754518,168754991,168755037,168755287,168755979,168756657,168756746,168759868,168760722,168761159,168761489,168764590,168767890,168888657,168889974,168890601,168891507,168893526,169048695,169050707,169053901,169053945,169062041,169063022,169063431,169063581,169064597,169066151,169066169,168896498,168884967,169065462,169067137,168884595,169060840,169041648,169051995,169052535,169057379,169057617,169060161,168876788,168877393,168883645,168891642,168895380,168896441,168899205,168794397,168796866,168842840,168900875,168907113,168831530,168890136,168897161,168898351,168900980,168798203,168808290,168798817,168798860,168799497,168800634,168801222,168802194,168945718,168948545,169049417,169264687,168987185,169108079,169157711,169736406,170081090,169068551,168919091,168919143,168948248,168968414,169077544,169082883,169084809,169124822,169126999,169138086,169279932,169357711,169363324,169544283,169572338,169663485,169664521,169665155,169705706,169738545,169756173,169761461,169762184,169781367,170086509,170168155,168999405,169001142,169003992,169003993,169010207,169030807,169036788,169085724,169119119,168797920,168798396,168806996,168807032,168808102,168809370,168809950,168810384,168826521,168832687,168832769,168836495,168836773,168837229,168924369,168927253,169099340,169044767,169047257,169054897,169061573,169063340,169064290,169069225,169069611,169072124,169076203,169077126,169077664,169079249,169079295,169080061,169080605,169081687,168999626,169218192,169008151,169018855,169663524,170141526,170662045,168824091,168840291,168840401,168841922,168844782,168845085,169737719,170190728,169001111,168975645,169086334,169087742,169096843,169122349,169049156,169074771,169079438,169089243,169096304,169097366,168964708,168969030,168969971,168994839,169026102,169077310,169087572,169542055,169157797,168986651,169003998,169075943,169076589,169099620,169146333,169254705,169542327,169581828,169727638,169787402,170092594,170123612,168982387,169016189,169072616,169076734,169077373,169079649,169084188,169084728,169553643,168890095,168919992,168925095,168925389,169071690,169076426,169085487,169088088,169102221,169105954,169046997,168918035,168918548,168918950,168919698,169064944,168980317,169007010,169016590,169024098,169016846,169016979,169019201,169075909,168967845,168970054,169018040,168982864,169025210,169025266,168825078,168825853,168828447,168828545,168828891,168829088,168942202,168942860,168951895,168958238,169011230,169019161,169021295,169024624,169149398,169819975,169031810,169033431,169282884,169119669,169122588,169148430,168980412,168962994,169008037,169013420,169015723,169016395,169018884,169121300,168974713,168975738,168976009,169004599,169281096,169283293,169375530,169076985,169122253,168976151,168978538,169005161,169006276,169006704,169007122,169008470,169052933,169055238,169058127,169065201,169065803,169067842,169068059,169068198,169069271,169071662,169127668,169549832,169564083,170172229,169030419,169047352,169047413,169048474,169051172,169053593,169060422,169060975,169062699,169124092,169127058,169145004,169712829,169728157,169765767,169772154,170180517,169079060,169102520,168987301,169011166,169021729,169000331,169011220,169210420,169025087,169027221,169035724,169039008,169040118,169086935,169089845,169101056,169106416,168933259,168997827,169040560,169047340,169055042,169061957,169079077,169104828,169111005,169169975,168858942,168864139,168866088,168866893,169267433,168942596,168990120,169277879,169069440,168764343,168768296,168772208,168772499,168772672,169004336,169006329,169006505,168772959,168762587,168759121,168822144,168826052,168826211,168980870,168981193,169268336,169283407,170899309,169278487,169029037,169128594,169066017,169090831,168982646,168826840,168969777,168976544,168986498,168986740,169007597,169010815,169013006,169014247,169014337,169014606,169016417,169017686,169017838,169018657,169018759,169021646,169022436,169023613,169006997,169009650,169010184,169010888,169011147,169012302,169013489,169014644,169015080,169015902,169016072,169114955,168992982,169138381,169016581,169029209,169032774,168965382,169002029,169013262,169021493,169016415,169024155,169024576,169081969,169349323,168815293,168817359,168818092,168821002,168833543,169211081,169116358,169019777,169068573,168956119,168962131,168963158,169005083,169009435,169010978,169012228,169014362,169061579,169061923,169070047,168979004,168979044,168979232,169003500,169004143,169008291,169008555,169008607,169008994,169009811,169009855,168959895,168973975,168976705,169062822,169117460,169131814,169166747,168884806,169022460,169027055,169027368,168969661,169001438,169002828,169004202,169004566,168971222,169004134,169004916,168971954,168972689,168979455,168925375,168857459,168879118,168911559,168911720,168913590,168916681,168958206,168835739,169134923,169017647,169018024,168969372,169047193,169048100,169024027,169061008,169063636,169066308,169069584,169002859,168997974,169001223,169022874,168723239,168723604,169039552,169042969,169043655,169055132,169058152,169085129,169085767,169086374,169086973,169103224,169070644,168892545,168896546,169011414,169043584,169043860,169072358,168897898,168900093,168920072,168920773,168920791,168927478,168931616,168907084,168935697,168937033,168939642,169014448,168825626,168827581,168830800,168831985,168940635,168971361,168974292,168974952,168975313,168790304,168791117,168794567,168794976,168795794,168796833,168797516,168797785,168798430,168799988,169024665,168938155,168830655,168831491,168840261,168967890,168996172,169123344,169131412,169012936,169015417,169009745,169022512,169021232,169080682,169080897,168983924,169023259,169078328,169109946,169111413,168968911,168969532,168832600,168996997,168996114,168889437,168936535,168931999,168957209,168954592,168940244,168942952,168990787,168993596,168994550,168995564,168996789,168997863,168999545,169000452,168934621,168991253,168932963,168919830,168991503,168986670,168993351,168994881,169019503,168805486,168812524,168818214,168818503,169036835,169040483,169043098,169043216,169048102,169049093,168825178,168825769,168826083,168826291,168826397,169048243,169052189,169052968,169054548,169055371,169056242,169056344,169057644,168969198,168971869,168980788,168984034,168984787,168986304,168986459,168990266,168977376,168977685,168978411,168792163,168792643,168799197,168824960,168890341,168925519,168981401,168956743,168967028,168785442,168815623,168870011,168873233,168875697,168875960,168878162,168883412,168883525,168883806,168883839,168884723,168886163,168782846,168875022,168869130,169032039,169040516,169011543,169028182,169033657,169037423,169037437,169037606,169038926,169018089,169029247,169032159,169033130,168933279,168933470,168934527,168935682,169006115,168839034,168856182,168879537,169031691,169034834,169035521,169037848,169038657,169040681,168814319,168818914,168824452,169020738,169024796,168900603,168898075,168916922,168821197,168821683,168992176,169024087,169685481,168976951,169011530,169011587,169026533,169056459,168883077,168883481,168885991}'::bigint[])) AND (collection_time >= '2019-09-30 22:17:18'::timestamp without time zone) AND (collection_time <= '2019-10-01 01:45:45'::timestamp without time zone))
  • Filter: (catalog_id = 1)
10. 82.096 82.096 ↓ 0.0 0 1,466

Index Scan using files_delete_road_20191001_collection_id_collection_time_idx on files_delete_road_20191001 (cost=0.56..2,313.64 rows=4 width=19) (actual time=0.055..0.056 rows=0 loops=1,466)

  • Index Cond: ((collection_id = rc.id) AND (collection_id = ANY ('{168809179,169570444,169583348,170198735,168797621,168805325,168814445,168816292,168817725,168913406,168917972,169014716,169026868,169028592,169030589,169031419,169032835,168832141,168833231,168838331,168859771,169022114,169026458,169102354,169740490,168838703,168863639,168863646,168864948,168865909,168866575,168867458,168870069,168871902,168835749,168848880,168825340,168850391,168817453,168891625,169063242,168862333,168863671,168868994,168791943,168793561,168793635,168795409,168796464,169782042,168903054,168903461,168903672,168904419,168906742,168816206,168817317,168961943,168949193,168953995,168987739,169050484,168822991,168828029,168834536,168836460,168838487,168839440,168839947,168902681,168906703,168898916,168902244,168911369,168911968,168827370,168827725,168828352,168829341,168830529,168831040,168831312,168864120,168864584,168869084,168870454,168788293,168791989,168792092,168793166,168793594,168794735,168795907,168796313,168877640,168777694,168883822,168783306,169031662,169097654,169249606,169544048,169558670,169581500,169665791,168809413,168810917,168801956,168843102,168847214,168851196,168848397,168805799,168811880,169122985,169553556,169761750,168904451,168952749,169118574,169141603,169253351,169308584,169340437,169401192,169547820,169550622,169566283,169581220,169582700,168835691,168836267,168906278,168967451,168816931,168827032,168830585,168833792,168834635,168837590,168789306,168830105,168851908,168852002,168864326,168805539,168807097,168826002,168857372,168752715,168753596,168754024,168754147,168763001,168765011,168932497,168976797,168980363,168987121,168987597,169149841,169192797,169531578,169659115,169663808,169665616,169726968,169100044,169125458,169126494,169268824,169269870,169277700,169282443,169543084,169551593,168759095,168761623,168762248,168763033,168763730,168764071,168764273,168831751,168833804,168836543,168838000,168902487,168902879,168901156,168840331,168837540,168838742,168840289,168877987,168812885,168813926,168816325,169069671,169071068,168838855,168840207,168840976,168841381,168841893,168843078,168843570,168844932,168848240,168848595,168789215,168789606,168790968,168798207,168818921,168791773,168789594,168789347,168791443,168812964,168789047,168788468,168791469,168844143,168903432,168911281,168911693,168918947,168925936,168935908,169084114,169095839,169135739,169140828,169240612,169068134,169072161,169083507,169107426,169121707,169123018,168832393,168826183,168811420,168832519,168852107,168852348,169017498,169051203,169093655,169121317,169070811,169000711,168987895,169064327,168992774,168990565,169134043,168993960,168877095,168883566,168884933,169759866,168845577,168846599,168847833,168847867,168861379,168861664,168864658,168865140,168865416,168868213,168870518,168870902,168871012,168879358,168882495,168884142,168895675,168898311,168899223,168954723,169015062,169017455,169019850,169024711,169024953,169121807,169137123,168734854,168737919,168754069,168762703,168771119,168771693,168777817,168786200,168787459,168815278,168818346,168818590,168823563,168826428,168828110,168829307,168830307,168834336,168834869,168839788,168997972,169003469,169003484,169006604,169008712,169010782,169017963,169022066,169023102,169023160,169072352,169148780,168999406,169000021,168859569,168856590,168838177,169000888,168992339,168999711,170073340,168773609,168776336,168776676,168779689,168780194,168780799,168781024,169123737,169126006,169262247,169664186,169769255,170190500,168841759,168844843,168846059,168846712,168847625,168989015,168991307,168993052,168993583,169732013,170098453,170105205,170123701,170145301,170152980,170175730,170220154,168814306,168816651,168817444,169107670,170122139,168735650,168730266,168754062,168756467,168982966,168986008,168991861,169005789,169009501,169013122,169013924,169017476,169089314,169120997,169137427,169284075,169580064,169666058,169782908,168841847,168842479,168865826,169001282,168959834,168976931,168981482,168989181,168991435,168991572,168778686,168808109,168808793,168838391,168840972,170094588,170132407,170185350,170188602,168828969,168830813,168834431,168834526,168836150,168836948,168837276,168837343,168838301,168839889,168868482,168870227,169729494,168943239,168896550,168943601,168950704,169000009,168974786,169000054,169059649,168948162,168994928,169053617,169085379,169130998,169275970,169730133,169712661,169737575,169801851,168812170,168812342,168813353,168819595,168820730,168961616,168995130,169070185,169079571,169072225,169055478,169066078,169091292,169037590,169284144,170122238,168810287,168810955,168815060,168823711,168827347,168827837,168828594,168900234,168931066,168968077,169017486,169018461,169031700,169032292,169038561,169074429,169074701,169085212,169087267,169208602,169022048,169022212,169066881,169067989,168829034,168836020,168866598,169001298,169005176,169020636,169002773,169004819,169006242,169006530,168999652,168964725,168965422,169072380,168859855,168998999,169006216,169006730,169008046,169008999,169011610,169015689,168865280,169020200,169003750,169013018,168869673,168865006,168867280,169020747,169006419,168999515,169004786,169008145,169008915,169009372,169012036,169013594,169013683,169013804,168766016,168766221,168766274,168767113,168767160,168767579,169069875,168983499,168917883,168808925,169115227,168966520,168953833,169067973,169547574,168953414,169087043,168896557,168906991,168915861,168963528,168904689,168921292,169013224,169111765,169730353,168742366,168743269,168744514,168746471,168747418,168747872,168748577,168748821,168750276,169022952,169048435,169052713,169054371,169055635,169104719,169072191,169133197,169077221,168969454,168969826,168973309,168977316,168984940,169188275,169217267,169075505,169017620,169039847,169079636,169026295,169040218,169041000,169054927,168845362,168845690,168971614,168973942,169022427,169024425,169025485,169026881,168820817,168820966,168825724,168826196,168827071,168957836,168949618,168949959,169015612,168882813,169019733,169040403,168869272,169026527,170660259,168997472,169002425,170645417,168871308,168876457,168876837,168880027,168880368,169108496,169116003,168829686,168831910,168833891,168833953,168834286,168834377,168834394,168835351,168836099,168836223,169003225,169014185,169050864,169062236,169090413,169091192,168978315,169002767,169007608,168979557,169000669,169023130,169024311,168998963,169006363,169013358,169019021,169087300,169088109,169089839,168933886,169019601,169001507,169009341,169016101,169081627,169075506,169078534,169082437,168930757,168880403,168880675,169066682,168968991,168969096,168917151,168917933,168920341,169000835,168970041,168970043,168970941,169067291,169067792,168810848,168812046,168814160,168814447,168866642,168993954,169000904,169003237,169011199,169016739,169022469,169022817,169023032,169024020,168787402,168787950,168973888,169029729,168946990,168976505,168977686,168979090,168835633,168835900,168837293,168838058,168905321,168948829,168967676,168975566,168783722,168784310,168761827,168765273,168798045,168952165,168958004,168830781,169084852,169090862,169103780,169105354,169107211,169107880,169110848,168828959,168835493,168884229,168889233,168873445,168852396,168889562,169018018,168918871,169072672,169075998,169076610,169079702,169082411,169082702,169086435,169093657,169099775,168799450,168800859,168804933,168805074,168805105,169063688,169072861,169076596,169083343,169087393,169087554,169087635,169089413,169089600,169089849,169091474,168909403,168912829,168971759,168976365,169064117,169070214,169071851,169087319,169028845,168766856,169061378,169066180,169071803,169071881,169072794,169079265,169081798,169083384,169083486,169083549,169083651,169084549,169084971,168752861,168752897,168753590,168754518,168754991,168755037,168755287,168755979,168756657,168756746,168759868,168760722,168761159,168761489,168764590,168767890,168888657,168889974,168890601,168891507,168893526,169048695,169050707,169053901,169053945,169062041,169063022,169063431,169063581,169064597,169066151,169066169,168896498,168884967,169065462,169067137,168884595,169060840,169041648,169051995,169052535,169057379,169057617,169060161,168876788,168877393,168883645,168891642,168895380,168896441,168899205,168794397,168796866,168842840,168900875,168907113,168831530,168890136,168897161,168898351,168900980,168798203,168808290,168798817,168798860,168799497,168800634,168801222,168802194,168945718,168948545,169049417,169264687,168987185,169108079,169157711,169736406,170081090,169068551,168919091,168919143,168948248,168968414,169077544,169082883,169084809,169124822,169126999,169138086,169279932,169357711,169363324,169544283,169572338,169663485,169664521,169665155,169705706,169738545,169756173,169761461,169762184,169781367,170086509,170168155,168999405,169001142,169003992,169003993,169010207,169030807,169036788,169085724,169119119,168797920,168798396,168806996,168807032,168808102,168809370,168809950,168810384,168826521,168832687,168832769,168836495,168836773,168837229,168924369,168927253,169099340,169044767,169047257,169054897,169061573,169063340,169064290,169069225,169069611,169072124,169076203,169077126,169077664,169079249,169079295,169080061,169080605,169081687,168999626,169218192,169008151,169018855,169663524,170141526,170662045,168824091,168840291,168840401,168841922,168844782,168845085,169737719,170190728,169001111,168975645,169086334,169087742,169096843,169122349,169049156,169074771,169079438,169089243,169096304,169097366,168964708,168969030,168969971,168994839,169026102,169077310,169087572,169542055,169157797,168986651,169003998,169075943,169076589,169099620,169146333,169254705,169542327,169581828,169727638,169787402,170092594,170123612,168982387,169016189,169072616,169076734,169077373,169079649,169084188,169084728,169553643,168890095,168919992,168925095,168925389,169071690,169076426,169085487,169088088,169102221,169105954,169046997,168918035,168918548,168918950,168919698,169064944,168980317,169007010,169016590,169024098,169016846,169016979,169019201,169075909,168967845,168970054,169018040,168982864,169025210,169025266,168825078,168825853,168828447,168828545,168828891,168829088,168942202,168942860,168951895,168958238,169011230,169019161,169021295,169024624,169149398,169819975,169031810,169033431,169282884,169119669,169122588,169148430,168980412,168962994,169008037,169013420,169015723,169016395,169018884,169121300,168974713,168975738,168976009,169004599,169281096,169283293,169375530,169076985,169122253,168976151,168978538,169005161,169006276,169006704,169007122,169008470,169052933,169055238,169058127,169065201,169065803,169067842,169068059,169068198,169069271,169071662,169127668,169549832,169564083,170172229,169030419,169047352,169047413,169048474,169051172,169053593,169060422,169060975,169062699,169124092,169127058,169145004,169712829,169728157,169765767,169772154,170180517,169079060,169102520,168987301,169011166,169021729,169000331,169011220,169210420,169025087,169027221,169035724,169039008,169040118,169086935,169089845,169101056,169106416,168933259,168997827,169040560,169047340,169055042,169061957,169079077,169104828,169111005,169169975,168858942,168864139,168866088,168866893,169267433,168942596,168990120,169277879,169069440,168764343,168768296,168772208,168772499,168772672,169004336,169006329,169006505,168772959,168762587,168759121,168822144,168826052,168826211,168980870,168981193,169268336,169283407,170899309,169278487,169029037,169128594,169066017,169090831,168982646,168826840,168969777,168976544,168986498,168986740,169007597,169010815,169013006,169014247,169014337,169014606,169016417,169017686,169017838,169018657,169018759,169021646,169022436,169023613,169006997,169009650,169010184,169010888,169011147,169012302,169013489,169014644,169015080,169015902,169016072,169114955,168992982,169138381,169016581,169029209,169032774,168965382,169002029,169013262,169021493,169016415,169024155,169024576,169081969,169349323,168815293,168817359,168818092,168821002,168833543,169211081,169116358,169019777,169068573,168956119,168962131,168963158,169005083,169009435,169010978,169012228,169014362,169061579,169061923,169070047,168979004,168979044,168979232,169003500,169004143,169008291,169008555,169008607,169008994,169009811,169009855,168959895,168973975,168976705,169062822,169117460,169131814,169166747,168884806,169022460,169027055,169027368,168969661,169001438,169002828,169004202,169004566,168971222,169004134,169004916,168971954,168972689,168979455,168925375,168857459,168879118,168911559,168911720,168913590,168916681,168958206,168835739,169134923,169017647,169018024,168969372,169047193,169048100,169024027,169061008,169063636,169066308,169069584,169002859,168997974,169001223,169022874,168723239,168723604,169039552,169042969,169043655,169055132,169058152,169085129,169085767,169086374,169086973,169103224,169070644,168892545,168896546,169011414,169043584,169043860,169072358,168897898,168900093,168920072,168920773,168920791,168927478,168931616,168907084,168935697,168937033,168939642,169014448,168825626,168827581,168830800,168831985,168940635,168971361,168974292,168974952,168975313,168790304,168791117,168794567,168794976,168795794,168796833,168797516,168797785,168798430,168799988,169024665,168938155,168830655,168831491,168840261,168967890,168996172,169123344,169131412,169012936,169015417,169009745,169022512,169021232,169080682,169080897,168983924,169023259,169078328,169109946,169111413,168968911,168969532,168832600,168996997,168996114,168889437,168936535,168931999,168957209,168954592,168940244,168942952,168990787,168993596,168994550,168995564,168996789,168997863,168999545,169000452,168934621,168991253,168932963,168919830,168991503,168986670,168993351,168994881,169019503,168805486,168812524,168818214,168818503,169036835,169040483,169043098,169043216,169048102,169049093,168825178,168825769,168826083,168826291,168826397,169048243,169052189,169052968,169054548,169055371,169056242,169056344,169057644,168969198,168971869,168980788,168984034,168984787,168986304,168986459,168990266,168977376,168977685,168978411,168792163,168792643,168799197,168824960,168890341,168925519,168981401,168956743,168967028,168785442,168815623,168870011,168873233,168875697,168875960,168878162,168883412,168883525,168883806,168883839,168884723,168886163,168782846,168875022,168869130,169032039,169040516,169011543,169028182,169033657,169037423,169037437,169037606,169038926,169018089,169029247,169032159,169033130,168933279,168933470,168934527,168935682,169006115,168839034,168856182,168879537,169031691,169034834,169035521,169037848,169038657,169040681,168814319,168818914,168824452,169020738,169024796,168900603,168898075,168916922,168821197,168821683,168992176,169024087,169685481,168976951,169011530,169011587,169026533,169056459,168883077,168883481,168885991}'::bigint[])) AND (collection_time >= '2019-09-30 22:17:18'::timestamp without time zone) AND (collection_time <= '2019-10-01 01:45:45'::timestamp without time zone))
  • Filter: (catalog_id = 1)
11. 0.029 6.768 ↑ 8.7 128 1

Hash (cost=1,630.48..1,630.48 rows=1,110 width=149) (actual time=6.768..6.768 rows=128 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 42kB
12. 0.523 6.739 ↑ 8.7 128 1

Bitmap Heap Scan on partitions (cost=526.60..1,630.48 rows=1,110 width=149) (actual time=6.386..6.739 rows=128 loops=1)

  • Recheck Cond: (metadata @> '{"vin": "5G21A6P05L4100051"}'::jsonb)
  • Heap Blocks: exact=249
13. 6.216 6.216 ↑ 4.3 258 1

Bitmap Index Scan on partitions_metadata_idx (cost=0.00..526.33 rows=1,110 width=0) (actual time=6.216..6.216 rows=258 loops=1)

  • Index Cond: (metadata @> '{"vin": "5G21A6P05L4100051"}'::jsonb)
14. 3.342 3.342 ↑ 1.0 1 1,671

Index Scan using datasets_pkey on datasets (cost=0.28..1.16 rows=1 width=75) (actual time=0.002..0.002 rows=1 loops=1,671)

  • Index Cond: (id = files_delete_road_20190930.dataset_id)
15. 1.671 1.671 ↑ 1.0 1 1,671

Seq Scan on catalogs (cost=0.00..1.02 rows=1 width=34) (actual time=0.000..0.001 rows=1 loops=1,671)

  • Filter: (id = 1)
  • Rows Removed by Filter: 1
Planning time : 57.187 ms
Execution time : 897.249 ms