explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QeQ7 : Optimization for: plan #3ciH

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 278.522 1,223,823.582 ↑ 2.5 430,914 1

WindowAgg (cost=5,346,439.47..5,380,860.61 rows=1,059,112 width=255) (actual time=1,223,446.789..1,223,823.582 rows=430,914 loops=1)

2. 938.860 1,223,545.060 ↑ 2.5 430,914 1

Sort (cost=5,346,439.47..5,349,087.25 rows=1,059,112 width=223) (actual time=1,223,438.125..1,223,545.060 rows=430,914 loops=1)

  • Sort Key: mmsi, ((date_trunc('hour'::text, GREATEST(last_known_position_timestamp, predicted_position_timestamp)) + '01:00:00'::interval)), (GREATEST(last_known_position_timestamp, predicted_position_timestamp)) DESC
  • Sort Method: external merge Disk: 89,592kB
3. 1,222,606.200 1,222,606.200 ↑ 2.5 430,914 1

Index Scan using vessel_table_mmsi_idx on vessel_table (cost=0.57..5,160,294.38 rows=1,059,112 width=223) (actual time=0.273..1,222,606.200 rows=430,914 loops=1)

  • Index Cond: (mmsi = ANY ('{9113883,53800514,205461000,205519000,207834350,209407000,209856000,210602000,210872000,211164850,211266470,211282560,212172000,212204000,212253000,212482000,212507000,212787000,212788000,212882000,212949000,214182426,215162000,215533000,215718000,218415000,219002827,219021597,219023056,219071000,219275000,219461000,219602000,225982587,228027900,228079700,229032000,229264000,229265000,229308000,229347000,229597000,229723000,229796000,231125000,232004389,232004630,232005952,232009365,232010196,232011317,232011808,232012746,232079000,232311989,232400002,233150000,233234000,233921000,235009270,235073827,235074246,235077605,235079902,235084529,235085368,235103318,235108227,235108514,235114368,236002000,236052000,236111851,236317000,236538000,237081400,239575000,239980800,240472000,240611000,240645000,241374000,244620862,244770218,244890845,245398000,245749000,245924000,246255000,246613000,247102360,248953000,249061000,249174000,249327000,249333000,249347000,249399000,249536000,249583000,249780000,249824000,249884000,249909000,255805907,256128000,256581000,256656000,257031820,257050000,257077000,257117000,257286000,257366000,257434000,257467000,257544000,257572900,257576000,257662000,257709000,257733000,257855000,257884000,257970000,258060000,258132000,258182000,258268000,258286000,258555000,258649000,258666000,258702000,258704000,258724000,258737000,258768000,258826000,258987000,259022000,259029000,259083000,259089000,259210000,259362000,259628000,259765000,259795000,259801000,261007990,269085000,271043617,273351623,273364000,273385110,273413140,303539000,303925000,304010919,305062000,305282000,305667000,305718000,305853000,306872000,308015000,308031000,308038000,308078000,308136000,308386000,308397000,308579000,308592000,308654000,308688000,308803000,308883000,308904000,308937000,308938000,309046000,309065000,309201000,309285000,309286000,309296000,309369000,309415000,309463000,309481000,309509900,309521000,309586000,309656000,309739000,309838000,309839000,309901000,309975000,309979000,310348000,310542000,310543000,310710000,310764000,311000229,311000261,311000285,311000342,311000363,311000364,311000365,311000386,311000420,311000439,311000505,311000512,311000608,311000623,311000636,311000677,311000680,311000760,311000776,311000784,311002200,311004400,311004900,311005200,311006300,311013600,311013700,311015100,311018600,311019200,311020600,311031400,311031800,311031900,311037900,311038400,311038500,311038600,311038700,311045300,311072200,311073600,311191000,311573000,311605000,311628000,311663000,311664000,311668000,311676000,311697000,311775000,311864000,311906000,311995000,311996000,312082000,312419000,312639000,312864000,314066000,314076000,314084000,316001380,316002900,316014270,316014390,316024142,316028342,316250000,316300000,316302000,316304000,319006800,319011000,319013300,319013600,319014800,319015800,319016900,319017100,319024300,319025600,319028500,319032600,319035500,319043400,319055000,319055400,319057500,319058000,319078200,319084600,319091800,319100600,319103100,319122500,319149000,319150000,319310000,319349000,319392000,319409000,319570000,319598000,319600000,319662000,319740000,319775000,319819000,319842000,319863000,319885000,319904000,325589000,325896000,338034000,341389000,345070383,347017580,351008000,351012000,351026000,351031000,351043000,351047000,351073000,351095000,351115000,351153000,351163000,351169000,351170000,351173000,351180000,351188000,351202000,351214000,351223000,351224000,351237000,351238000,351246000,351249000,351256000,351257000,351260000,351275000,351280000,351291000,351295000,351320000,351322000,351340000,351350000,351353000,351357000,351360000,351377000,351383000,351385000,351392000,351405000,351407000,351431000,351434000,351450000,351453000,351455000,351474000,351496000,351516000,351518000,351522000,351533000,351535000,351544000,351554000,351588000,351606000,351609000,351613000,351628000,351646000,351664000,351678000,351684000,351689000,351690000,351693000,351698000,351701000,351707000,351724000,351726000,351733000,351741000,351755000,351757000,351773000,351780000,351787000,351794000,351796000,351800000,351805000,351833000,351840000,351863000,351864000,351865000,351868000,351870000,351885000,351893000,351896000,351904000,351916000,351925000,351929000,351952000,351954000,351988000,351998000,352012000,352023000,352035000,352039000,352043000,352044000,352055000,352057000,352058000,352062000,352071000,352082000,352084000,352090000,352091000,352105000,352110000,352131000,352133000,352142000,352144000,352149000,352158000,352175000,352182000,352198000,352204000,352206000,352218000,352231000,352236000,352241000,352275000,352283000,352284000,352300000,352301000,352352000,352357000,352366000,352369000,352374000,352375000,352396000,352428000,352430000,352461000,352467000,352468000,352475000,352477000,352485000,352497000,352500000,352505000,352506000,352507000,352508000,352527000,352530000,352536000,352548000,352553000,352555000,352565000,352582000,352587000,352593000,352596000,352630000,352650000,352654000,352659000,352663000,352665000,352680000,352716000,352718000,352719000,352730000,352732000,352744000,352747000,352755000,352798000,352804000,352808000,352814000,352816000,352821000,352822000,352823000,352830000,352837000,352844000,352858000,352862000,352882000,352894000,352898000,352905000,352907000,352915000,352929000,352932000,352935000,352946000,352955000,352957000,352962000,352970000,352971000,352972000,352981000,352995000,352998000,353003000,353009000,353013000,353018000,353024000,353025000,353044000,353052000,353065000,353069000,353073000,353092000,353096000,353105000,353108000,353109000,353135000,353150000,353153000,353156000,353172000,353178000,353183000,353185000,353188000,353193000,353195000,353199000,353206000,353216000,353222000,353233000,353237000,353260000,353261000,353262000,353269000,353272000,353274000,353288000,353290000,353294000,353295000,353297000,353321000,353325000,353329000,353332000,353349000,353366000,353378000,353399000,353411000,353414000,353421000,353445000,353491000,353506000,353512000,353514000,353524000,353525000,353532000,353544000,353554000,353560000,353562000,353563000,353571000,353579000,353580000,353592000,353594000,353601000,353603000,353613000,353616000,353618000,353619000,353639000,353642000,353647000,353662000,353690000,353702000,353707000,353718000,353726000,353729000,353738000,353743000,353764000,353769000,353774000,353788000,353791000,353802000,353804000,353816000,353841000,353884000,353889000,353903000,353921000,353923000,353924000,353932000,353941000,353951000,353959000,353961000,353969000,353983000,353987000,353988000,353992000,353997000,354001000,354038000,354040000,354048000,354051000,354054000,354056000,354076000,354086000,354091000,354093000,354097000,354106000,354118000,354123000,354128000,354135000,354141000,354151000,354157000,354159000,354160000,354162000,354204000,354205000,354211000,354213000,354218000,354220000,354221000,354222083,354224000,354228000,354232000,354244000,354247000,354250000,354260000,354269000,354280000,354283000,354285000,354297000,354322000,354332000,354342000,354348000,354360000,354362000,354367000,354383000,354393000,354394000,354396000,354410000,354421000,354437000,354453000,354467000,354473000,354484000,354493000,354494000,354508000,354514000,354519000,354526000,354532000,354547000,354550000,354552000,354555000,354561000,354565000,354580000,354587000,354589000,354594000,354614000,354634000,354654000,354663000,354675000,354680000,354686000,354688000,354708000,354735000,354738000,354750000,354767000,354771000,354774000,354787000,354803000,354807000,354813000,354817000,354824000,354825000,354826000,354828000,354836000,354837000,354839000,354848000,354850000,354856000,354869000,354872000,354874000,354880000,354881000,354891000,354896000,354898000,354899000,354918000,354925000,354928000,354931000,354942000,354945000,354953000,354957000,354959000,354964000,354971000,354979000,354988000,355026000,355036000,355042000,355046000,355049000,355050000,355066000,355084000,355087000,355091000,355095000,355131000,355139000,355153000,355168000,355178000,355179000,355192000,355205000,355223000,355231000,355232000,355234000,355256000,355259000,355275000,355280000,355288000,355294000,355297000,355301000,355315000,355322000,355323000,355344000,355351000,355354000,355368000,355376000,355378000,355384000,355390000,355391000,355395000,355400000,355410000,355416000,355437000,355439000,355440000,355444000,355446000,355456000,355461000,355462000,355470000,355471000,355480000,355488000,355494000,355497000,355514000,355525000,355528000,355530000,355548000,355549000,355557000,355558000,355580000,355581000,355612000,355615000,355619000,355623000,355654000,355656000,355662000,355664000,355671000,355677000,355684000,355690000,355700000,355702000,355709000,355733000,355745000,355754000,355768000,355774000,355781000,355784000,355787000,355802000,355806000,355815000,355820000,355824000,355828000,355860000,355868000,355875000,355883000,355891000,355900000,355912000,355913000,355920000,355924000,355927000,355948000,355959000,355966000,355970000,355974000,355981000,355989000,356005000,356016000,356024000,356027000,356028000,356073000,356107000,356111000,356115000,356121000,356131000,356132000,356142000,356143000,356150000,356158000,356159000,356181000,356188000,356206000,356212000,356222000,356229000,356257000,356277000,356284000,356285000,356308000,356309000,356315000,356316000,356333000,356335000,356339000,356340000,356345000,356347000,356352000,356360000,356376000,356380000,356386000,356433000,356446000,356447000,356458000,356460000,356462000,356466000,356468000,356472000,356476000,356481000,356493000,356496000,356508000,356530000,356537000,356541000,356544000,356553000,356554000,356559000,356564000,356565000,356566000,356567000,356571000,356575000,356577000,356586000,356589000,356600000,356611000,356619000,356623000,356624000,356626000,356628000,356631000,356634000,356641000,356651000,356660000,356676000,356677000,356679000,356686000,356688000,356690000,356696000,356702000,356706000,356725000,356727000,356744000,356757000,356768000,356773000,356777000,356783000,356796000,356798000,356829000,356832000,356837000,356839000,356844000,356872000,356874000,356875000,356876000,356882000,356883000,356892000,356903000,356911000,356931000,356932000,356948000,356956000,356961000,356963000,356972000,357013000,357028000,357039000,357045000,357058000,357069000,357072000,357075000,357076000,357081000,357083000,357084000,357094000,357101000,357104000,357116000,357119000,357140000,357147000,357156000,357173000,357175000,357186000,357194000,357197000,357200000,357201000,357209000,357210000,357213000,357217000,357232000,357239000,357242000,357244000,357252000,357259000,357261000,357275000,357279000,357291000,357293000,357295000,357330000,357348000,357353000,357361000,357362000,357364000,357370000,357389000,357400000,357404000,357412000,357417000,357427000,357437000,357441000,357443000,357457000,357460000,357461000,357480000,357498000,357533000,357538000,357547000,357571000,357611000,357616000,357649000,357650000,357654000,357673000,357676000,357682000,357687000,357693000,357694000,357697000,357708000,357720000,357721000,357726000,357734000,357740000,357741000,357743000,357747000,357770000,357772000,357777000,357780000,357786000,357795000,357812000,357833000,357835000,357839000,357848000,357873000,357892000,357899000,357900000,357902000,357907000,357919000,357920000,357955000,357957000,357965000,357984000,357987000,357997000,362183000,366495000,366588000,366888840,367126620,367349430,367363390,367408020,367567290,367614240,367728720,367736030,367784160,368473000,369552000,370017000,370021000,370055000,370064000,370067000,370069000,370095000,370117000,370122000,370126000,370135000,370148000,370149000,370150000,370151000,370157000,370163000,370168000,370169000,370170000,370181000,370193000,370220000,370221000,370230000,370232000,370235000,370261000,370282000,370289000,370295000,370298000,370299000,370303000,370304000,370313000,370320000,370325000,370328000,370361000,370362000,370364000,370367000,370370000,370372000,370379000,370385000,370392000,370393000,370400000,370407000,370411000,370413000,370419000,370422000,370423000,370433000,370441000,370455000,370458000,370460000,370475000,370476000,370484000,370486000,370488000,370496000,370502000,370507000,370514000,370526000,370556000,370562000,370572000,370579000,370583000,370599000,370616000,370617000,370618009,370625000,370633000,370642000,370644000,370647000,370651000,370662000,370666000,370675000,370678000,370681000,370686000,370687000,370699000,370712000,370714000,370716000,370724000,370727000,370731000,370732000,370735000,370738000,370739000,370754000,370756000,370763000,370764000,370766000,370768000,370772000,370777000,370779000,370795000,370797000,370811000,370813000,370840000,370843000,370849000,370852000,370853000,370854000,370867000,370869000,370876000,370879000,370883000,370885000,370914000,370929000,370957000,370959000,370960000,370971000,370999000,371005000,371018000,371025000,371050000,371060000,371068000,371076000,371087000,371093000,371096000,371111000,371117000,371118000,371129000,371136000,371140000,371160000,371163000,371166000,371172000,371177000,371180000,371199000,371200000,371209000,371210000,371215000,371229000,371237000,371265000,371270000,371272000,371274000,371281000,371294000,371303000,371318000,371320000,371323000,371330000,371331000,371332000,371343000,371349000,371351000,371355000,371372000,371375000,371381000,371398000,371407000,371410000,371417000,371424000,371425000,371427000,371430000,371433000,371436000,371437000,371441000,371449000,371451000,371462000,371463000,371473000,371483000,371486000,371493000,371495000,371507000,371518000,371519000,371522000,371542000,371553000,371559000,371560000,371561000,371587000,371590000,371595000,371601000,371603000,371604000,371618000,371628000,371633000,371641000,371645000,371647000,371649000,371678000,371687000,371691000,371693000,371697000,371699000,371706000,371707000,371710000,371713000,371716000,371732000,371742000,371744000,371755000,371777000,371784000,371791000,371794000,371795000,371797000,371799000,371803000,371810000,371815000,371819000,371820000,371821000,371826000,371836000,371842000,371844000,371846000,371862000,371873000,371877000,371885000,371886000,371888000,371896000,371899000,371903000,371924000,371928000,371936000,371937000,371941000,371960000,371961000,371962000,371965000,371978000,371979000,371980000,371981000,371987000,371997000,372002000,372007000,372024000,372028000,372031000,372038000,372040000,372041000,372044000,372049000,372052000,372053000,372056000,372059000,372063000,372067000,372078000,372083000,372084000,372095000,372104000,372116000,372117000,372121000,372125000,372129000,372130000,372140000,372148000,372153000,372158000,372177000,372178000,372191000,372192000,372216000,372218000,372219000,372220000,372240000,372254000,372260000,372276000,372279000,372280000,372281000,372290000,372309000,372319000,372324000,372343000,372351000,372358000,372361000,372371000,372372000,372383000,372394000,372402000,372405000,372417000,372431000,372444000,372449000,372454000,372464000,372465000,372470000,372480000,372484000,372495000,372512000,372526000,372530000,372531000,372532000,372533000,372534000,372548000,372549000,372567000,372568000,372569000,372570000,372580000,372582000,372607000,372609000,372610000,372618000,372622000,372628000,372631000,372638000,372643000,372648000,372655000,372656000,372665000,372675000,372701000,372707000,372711000,372712000,372719000,372721000,372724000,372740000,372747000,372754000,372771000,372772000,372779000,372792000,372800000,372805000,372815000,372827000,372848000,372849000,372856000,372884000,372890000,372894000,372895000,372897000,372912000,372915000,372922000,372925000,372930000,372938000,372939000,372941000,372942000,372955000,372956000,372960000,372975000,372981000,372983000,372984000,372988000,372991000,372998000,373017000,373024000,373025000,373033000,373035000,373043000,373045000,373046000,373048000,373049000,373057000,373058000,373059000,373064000,373066000,373071000,373072000,373073000,373083000,373085000,373096000,373100000,373101000,373102000,373114000,373118000,373119000,373125000,373138000,373146000,373154000,373165000,373168000,373179000,373189000,373191000,373201000,373208000,373209000,373210000,373214000,373217000,373221000,373222000,373228000,373230000,373232000,373240000,373247000,373256000,373275000,373277000,373280000,373283000,373293000,373302000,373303000,373310000,373312000,373319000,373327000,373332000,373334000,373337000,373341000,373343000,373344000,373351000,373354000,373362000,373371000,373372000,373383000,373389000,373392000,373394000,373403000,373408000,373412000,373418000,373421000,373425000,373445000,373448000,373449000,373454000,373470000,373471000,373479000,373483000,373485000,373489000,373494000,373495000,373497000,373498000,373504000,373505000,373508000,373509000,373511000,373522000,373530000,373537000,373540000,373557000,373575000,373583000,373593000,373600000,373604000,373607000,373611000,373615000,373617000,373619000,373640000,373649000,373657000,373660000,373663000,373666000,373667000,373680000,373693000,373701000,373706000,373725000,373731000,373738000,373740000,373744000,373755000,373756000,373768000,373788000,373789000,373795000,373796000,373798000,373802000,373810000,373814000,373815000,373821000,373828000,373860000,373865000,373871000,373872000,373874000,373889000,373900000,373903000,373911000,373917000,373918000,373926000,373928000,373932000,373933000,373944000,373945000,373954000,373970000,373981000,373996000,373997000,373999000,374034000,374042000,374062000,374077000,374084000,374097000,374123000,374129000,374153000,374161000,374170000,374171000,374180000,374192000,374200000,374216000,374217000,374221000,374225000,374226000,374233000,374235000,374241000,374242000,374244000,374246000,374248000,374265000,374267000,374279000,374280000,374288000,374295000,374318000,374319000,374374000,374380000,374400000,374402000,374404000,374423000,374426000,374431000,374438000,374466000,374494000,374498000,374504000,374512000,374546000,374551000,374552000,374564000,374566000,374570000,374580000,374581000,374589000,374590000,374597000,374607000,374614000,374625000,374628000,374632000,374650000,374652000,374655000,374668000,374678000,374715000,374717000,374724000,374727000,374737000,374745000,374748000,374767000,374773000,374775000,374792000,374814000,374815000,374821000,374839000,374840000,374880000,374883000,374906000,374907000,374909000,374910000,374912000,374921000,374931000,374935000,374956000,374994000,375081000,408906997,412272380,412303720,412425022,412520221,412550376,413328030,413553560,413593452,413808092,413815133,413859488,413862638,413903504,416005220,416058900,416068700,416221800,416248600,416484000,416836000,419000146,419001062,419064300,419611000,422913000,431000001,431000080,431000118,431000124,431000127,431000131,431000132,431000145,431000156,431000162,431000166,431000168,431000173,431000188,431000201,431000206,431000213,431000221,431000225,431000233,431000239,431000249,431000252,431000266,431000269,431000278,431000281,431000307,431000312,431000316,431000322,431000323,431000326,431000329,431000331,431000339,431000351,431000357,431000389,431000392,431000406,431000424,431000426,431000427,431000448,431000458,431000461,431000462,431000469,431000474,431000477,431000478,431000482,431000497,431000509,431000514,431000519,431000523,431000527,431000534,431000555,431000560,431000563,431000566,431000590,431000594,431000599,431000622,431000627,431000631,431000635,431000651,431000689,431000691,431000695,431000697,431000705,431000706,431000709,431000732,431000734,431000742,431000756,431000763,431000771,431000774,431000783,431000798,431000804,431000822,431000828,431000833,431000836,431000841,431000848,431000851,431000864,431000875,431000898,431000903,431000913,431000922,431000923,431000928,431000951,431000952,431000963,431000976,431000991,431000994,431001000,431001044,431001051,431001057,431001062,431001071,431001072,431001073,431001074,431001092,431001104,431001108,431001109,431001111,431001116,431001122,431001142,431001145,431001214,431001250,431001258,431001275,431001305,431001328,431001343,431001353,431001388,431001427,431001455,431001544,431001549,431001573,431001582,431001659,431001704,431001782,431001824,431001826,431001931,431002043,431002092,431002115,431002141,431002208,431002259,431002283,431002286,431002294,431002349,431002386,431002425,431002433,431002435,431002438,431002447,431002481,431002513,431002547,431002584,431002661,431002681,431002682,431002691,431002702,431002703,431002764,431002809,431002815,431002837,431002858,431003009,431003032,431003061,431003074,431003089,431003158,431003159,431003171,431003205,431003211,431003232,431003246,431003277,431003359,431003373,431003381,431003496,431003523,431003556,431003595,431003671,431003678,431003685,431003687,431003767,431003788,431003839,431003853,431003903,431003905,431003911,431003928,431004012,431004067,431004083,431004095,431004115,431004122,431004129,431004134,431004145,431004146,431004152,431004223,431004261,431004277,431004314,431004315,431004325,431004385,431004417,431004469,431004474,431004478,431004506,431004526,431004622,431004648,431004661,431004668,431004684,431004713,431004753,431004769,431004772,431004801,431004833,431004883,431004911,431004916,431004956,431004957,431004994,431004995,431005001,431005055,431005056,431005113,431005151,431005156,431005199,431005219,431005234,431005235,431005248,431005263,431005296,431005328,431005329,431005341,431005371,431005389,431005402,431005408,431005421,431005438,431005439,431005521,431005531,431005547,431005575,431005639,431005641,431005675,431005795,431005815,431005867,431005885,431005886,431005903,431005916,431005942,431005964,431005988,431005995,431006000,431006049,431006057,431006084,431006191,431006217,431006242,431006292,431006325,431006467,431006514,431006555,431006557,431006629,431006666,431006689,431006736,431006741,431006804,431006854,431006857,431006873,431006885,431006889,431006906,431006948,431006958,431007017,431007022,431007041,431007042,431007082,431007132,431007166,431007174,431007215,431007265,431007276,431007294,431007371,431007415,431007416,431007419,431007421,431007429,431007495,431007528,431007567,431007657,431007674,431007681,431007762,431007787,431007868,431008024,431008096,431008189,431008217,431008365,431008412,431008417,431008435,431008452,431008464,431008475,431008542,431008554,431008605,431008678,431008681,431008799,431008887,431008888,431008927,431009016,431009036,431009047,431009078,431009113,431009137,431009142,431009171,431009216,431009245,431009274,431009275,431009293,431009336,431009359,431009378,431009393,431009418,431009421,431009445,431009462,431009494,431009524,431009526,431009592,431009595,431009622,431009641,431009647,431009657,431009696,431009704,431009761,431009782,431009805,431009828,431009847,431009947,431009962,431010002,431010021,431010051,431010061,431010068,431010075,431010077,431010211,431010311,431010346,431010357,431010481,431010513,431010524,431010577,431010586,431010596,431010652,431010669,431010701,431010753,431010786,431010811,431010813,431010814,431010869,431010891,431010903,431010906,431010964,431011000,431011022,431011058,431011086,431011093,431011098,431011131,431011157,431011163,431011172,431011177,431011239,431011246,431011365,431011428,431011444,431011445,431011451,431011481,431011759,431013000,431014000,431015000,431016000,431018000,431019000,431023000,431034000,431052000,431061000,431067000,431076000,431079000,431084000,431085000,431094000,431100000,431100005,431100049,431100187,431100192,431100206,431100208,431100215,431100311,431100312,431100372,431100476,431100505,431100522,431100544,431100698,431100769,431100843,431100871,431100926,431100939,431100966,431100967,431100978,431100987,431101012,431101016,431101018,431101028,431101099,431101111,431101128,431101133,431101139,431101143,431101146,431101149,431101162,431101172,431101175,431104000,431108000,431127000,431132000,431134000,431139000,431148000,431151000,431156000,431157000,431161000,431165000,431177000,431185000,431190000,431197000,431200082,431200090,431200122,431200176,431200201,431200271,431200306,431200564,431200647,431200673,431200676,431200683,431200688,431200693,431200701,431200703,431200970,431203000,431205000,431207000,431209000,431213000,431214000,431220000,431221000,431223000,431224000,431228000,431238000,431239000,431241000,431243000,431260000,431261000,431262000,431263000,431264000,431276000,431281000,431283000,431287000,431288000,431289000,431290000,431296000,431300000,431300065,431300086,431300099,431300106,431300165,431300243,431300268,431300284,431300387,431300411,431300462,431300536,431300599,431300686,431300775,431300806,431300881,431301057,431301067,431301081,431301245,431301337,431301369,431301443,431301503,431301507,431301574,431301595,431301606,431301625,431301627,431301648,431301651,431301679,431301698,431301705,431301706,431301724,431301735,431301736,431301745,431301754,431301756,431301759,431301766,431301777,431301796,431301798,431302000,431305000,431306000,431312000,431314000,431315000,431318000,431325000,431328000,431332000,431339000,431349000,431354000,431356000,431359000,431374000,431375000,431385000,431386000,431392000,431398000,431400000,431400021,431400046,431400048,431400101,431400118,431400121,431400137,431400168,431400271,431400282,431400291,431400302,431400349,431400378,431400392,431400404,431400446,431400448,431400509,431400523,431400538,431400568,431400585,431400588,431400603,431400609,431400625,431400637,431400651,431400732,431400901,431400992,431401000,431401055,431401097,431401143,431401335,431401545,431401646,431401813,431401828,431401859,431401869,431401925,431401965,431401967,431401969,431401975,431401978,431401985,431402007,431402013,431402015,431402019,431402024,431402025,431402029,431402032,431402035,431402037,431402038,431402044,431402064,431402069,431402072,431403000,431417000,431422000,431423000,431432000,431446000,431449000,431451000,431454000,431461000,431464000,431483000,431490000,431491000,431493000,431496000,431498000,431500004,431500105,431500186,431500189,431500254,431500352,431500383,431500392,431500399,431500420,431500427,431500501,431500526,431500535,431500541,431500543,431500553,431500624,431500658,431500862,431501000,431501146,431501603,431501619,431501663,431501666,431501669,431501692,431501701,431501714,431501737,431501746,431501753,431501765,431501766,431501791,431501792,431501801,431501809,431501815,431501816,431501818,431501834,431501855,431501857,431501858,431501862,431501866,431501867,431501871,431501874,431501879,431501881,431526000,431546000,431548000,431550000,431554000,431556000,431557000,431561000,431575000,431579000,431586000,431600065,431600086,431600132,431600152,431600175,431600179,431600182,431600197,431600309,431600375,431600422,431600423,431600459,431600646,431600647,431600749,431600827,431600870,431600966,431601070,431601243,431601973,431601978,431602029,431602048,431602067,431602076,431602082,431602089,431602099,431602142,431602143,431602207,431602211,431602298,431602305,431602323,431602331,431602345,431602361,431602420,431602610,431602950,431603380,431642000,431651000,431680087,431680121,431680138,431680144,431680207,431680212,431680270,431683000,431694000,431698000,431700017,431700024,431700200,431700550,431701040,431702230,431702850,431703830,431721000,431726000,431756000,431764000,431772000,431778000,431784000,431800389,431800603,431800605,431800616,431800649,431800699,431813000,431857000,431865000,431868000,431870000,431872000,431873000,431875000,431877000,431881000,431888000,431894000,431899000,431904000,431908000,431939000,431977000,431984000,431999628,432228000,432276000,432278000,432321000,432328000,432355000,432370000,432395000,432420000,432433000,432440000,432448000,432454000,432474000,432477000,432495000,432506000,432545000,432568000,432590000,432596000,432606000,432613000,432622000,432623000,432624000,432629000,432633000,432634000,432651000,432657000,432664000,432665000,432666000,432669000,432673000,432683000,432694000,432701000,432707000,432710000,432711000,432712000,432714000,432716000,432722000,432723000,432724000,432729000,432732000,432734000,432737000,432744000,432745000,432750000,432752000,432754000,432758000,432759000,432767000,432772000,432774000,432783000,432785000,432786000,432790000,432794000,432800000,432801000,432803000,432805000,432807000,432808000,432809000,432810000,432816000,432817000,432820000,432823000,432824000,432828000,432830000,432831000,432832000,432835000,432838000,432839000,432841000,432848000,432849000,432853000,432855000,432857000,432862000,432864000,432865000,432865303,432870000,432875000,432876000,432881000,432882000,432885000,432886000,432894000,432897000,432898000,432899000,432902000,432904000,432905000,432910000,432912000,432913000,432919000,432921000,432926000,432930000,432931000,432934000,432935000,432937000,432938000,432940000,432945000,432946000,432950000,432952000,432954000,432957000,432965000,432969000,432970000,432974000,432976000,432977000,432978000,432979000,432981000,432982000,432992000,432994000,432995000,432996000,440034000,440101000,440123000,440504000,440686000,440889000,440895000,441287000,441628000,441690000,441903000,441969000,457900386,466217000,470182000,470739000,477001300,477003300,477007900,477013600,477023400,477036300,477045300,477045900,477047900,477049700,477050700,477053000,477056600,477056800,477058200,477066200,477067900,477076500,477076700,477091500,477098300,477099600,477102200,477105200,477108800,477112900,477114400,477118400,477133100,477136300,477137600,477139700,477141900,477142300,477147300,477151500,477163900,477166800,477177300,477178600,477185200,477185300,477185700,477188500,477198000,477213100,477224800,477241500,477243400,477243700,477264800,477274100,477274200,477276400,477282800,477283000,477287000,477289300,477293200,477305200,477314400,477319400,477322000,477323000,477333500,477347100,477348600,477348800,477379000,477389500,477397400,477398000,477405000,477439200,477444500,477486300,477514700,477554000,477585700,477587000,477588600,477598100,477607600,477621200,477621400,477621800,477622400,477631400,477637200,477639100,477657600,477686700,477690200,477691300,477692200,477692500,477694500,477712600,477728900,477744900,477748800,477748900,477786500,477786800,477786900,477791100,477797700,477802400,477815800,477818000,477829500,477849100,477852400,477881800,477883200,477883500,477897400,477897700,477913400,477913500,477914600,477914700,477914900,477915800,477932200,477933000,477959200,477959900,477961300,477963100,477967400,477973000,477978700,477995853,503070730,503516000,503608900,503727000,506120000,510436000,512005449,512433000,518100121,518762000,525007392,525013044,525015583,525015924,525019473,525022371,525119006,533000135,533209000,538002085,538002598,538002754,538002886,538002960,538002961,538002992,538003099,538003100,538003101,538003240,538003254,538003426,538003428,538003436,538003440,538003446,538003487,538003515,538003520,538003648,538003688,538003729,538003760,538003767,538003810,538003835,538003869,538003876,538003886,538003929,538003976,538003993,538004002,538004047,538004051,538004060,538004073,538004086,538004105,538004117,538004159,538004167,538004187,538004202,538004203,538004216,538004239,538004240,538004244,538004245,538004261,538004372,538004380,538004381,538004382,538004383,538004384,538004385,538004386,538004387,538004391,538004392,538004405,538004408,538004442,538004474,538004476,538004478,538004480,538004493,538004494,538004521,538004530,538004539,538004586,538004601,538004602,538004619,538004642,538004646,538004652,538004665,538004669,538004682,538004697,538004706,538004722,538004747,538004748,538004749,538004750,538004759,538004777,538004793,538004811,538004987,538004995,538005037,538005038,538005055,538005077,538005103,538005148,538005152,538005163,538005223,538005243,538005330,538005343,538005349,538005357,538005393,538005411,538005436,538005604,538005610,538005611,538005612,538005613,538005645,538005753,538005795,538006000,538006031,538006107,538006163,538006175,538006215,538006278,538006281,538006318,538006326,538006351,538006357,538006363,538006389,538006419,538006432,538006433,538006434,538006456,538006462,538006466,538006467,538006468,538006469,538006470,538006471,538006472,538006473,538006508,538006585,538006625,538006664,538006680,538006696,538006700,538006708,538006751,538006753,538006774,538006778,538006779,538006780,538006781,538006782,538006783,538006784,538006785,538006786,538006787,538006800,538006824,538006830,538006888,538006896,538006974,538006975,538006976,538006977,538006978,538006979,538007017,538007024,538007028,538007029,538007034,538007090,538007092,538007093,538007122,538007124,538007226,538007234,538007274,538007298,538007299,538007300,538007345,538007347,538007353,538007360,538007378,538007388,538007447,538007456,538007459,538007472,538007476,538007504,538007517,538007530,538007558,538007569,538007573,538007592,538007606,538007611,538007631,538007657,538007746,538007768,538007798,538007810,538007823,538007827,538007982,538071163,548659200,548728000,548735000,548765000,548767000,548775000,548777000,548779000,548786000,548799000,548805000,548809000,548827000,548835000,548837000,548843000,548845000,548847000,548849000,548853000,548854000,548868000,548874000,548876000,548881000,548885000,548893000,548899000,548901000,548907000,548908000,548909000,548910000,548911000,548912000,548913000,548915000,548918000,548921000,548922000,548925000,548928000,548931000,548932000,548934000,548935000,548940000,548941000,548942000,548944000,548946000,548948000,548950000,548954000,548955000,548956000,548961000,548962000,548965000,548966000,548971000,548972000,563002100,563003200,563006800,563010400,563011200,563013300,563017900,563019500,563019800,563019900,563025600,563026300,563028200,563028400,563029100,563029800,563032400,563033800,563046100,563048400,563048500,563052300,563054800,563059700,563077000,563079000,563119000,563178000,563214000,563231000,563262000,563270000,563298000,563329000,563335000,563343000,563353000,563358000,563361000,563364000,563366000,563385000,563405000,563418000,563422000,563471000,563518000,563525000,563589000,563605000,563610000,563637000,563640000,563659000,563689000,563701000,563707000,563710000,563727000,563758000,563876000,563885000,563896000,563911000,564047000,564090000,564096000,564137000,564157000,564246000,564254000,564268000,564295000,564352000,564361000,564396000,564421000,564430000,564454000,564561000,564580000,564692000,564735000,564793000,564811000,564818000,564882000,564902000,564938000,565030000,565043000,565092000,565097000,565099000,565112000,565142000,565156000,565192000,565214000,565238000,565250000,565256000,565311000,565347000,565359000,565365000,565370000,565431000,565435000,565503000,565524000,565528000,565550000,565605000,565765000,565778000,565807000,565835000,565882000,565887000,565947000,565963000,565964000,566002000,566044000,566086000,566095000,566126000,566157000,566169000,566183000,566192000,566241000,566252000,566259000,566263000,566300000,566303000,566335000,566367000,566369000,566402000,566421000,566433000,566448000,566454000,566466000,566524000,566714000,566813000,566826000,566851000,566916000,566923000,566929000,566932000,566980000,567473000,567503000,567548000,567554000,576229000,576460000,576470000,576646000,577310000,577368000,584123456,621819030,636009174,636010789,636011023,636011255,636011280,636011454,636011610,636011617,636011792,636012155,636012596,636013068,636013073,636013098,636013308,636013456,636013457,636013521,636013522,636013938,636013946,636013947,636014046,636014073,636014129,636014240,636014241,636014332,636014368,636014410,636014515,636014525,636014655,636014987,636015032,636015110,636015168,636015173,636015198,636015352,636015428,636015431,636015509,636015557,636015559,636015598,636015640,636015657,636015725,636015771,636015782,636015819,636015871,636015896,636015912,636015921,636015949,636015959,636015960,636016044,636016096,636016207,636016327,636016413,636016414,636016420,636016447,636016454,636016511,636016533,636016535,636016556,636016557,636016655,636016799,636016804,636016900,636016958,636016988,636017005,636017062,636017063,636017082,636017102,636017108,636017119,636017161,636017162,636017294,636017295,636017359,636017419,636017422,636017423,636017468,636017509,636017539,636017583,636017637,636017643,636017703,636017710,636017717,636017718,636017733,636017757,636017765,636017853,636017968,636018112,636018152,636018168,636018186,636018231,636018245,636018273,636018303,636018341,636018390,636018470,636018522,636018525,636090646,636091105,636092175,636092734,657744000,667830000,671051000,671069100,671759000,671853000,677054700,701000623,701006063,701526000,710009510,725004230,730151041,770576322,983300000}'::integer[]))
  • Filter: ((date_trunc('hour'::text, GREATEST(last_known_position_timestamp, predicted_position_timestamp)) + '01:00:00'::interval) > (timezone('UTC'::text, now()) - '168:00:00'::interval))
  • Rows Removed by Filter: 2,267,877
Planning time : 5.858 ms
Execution time : 1,223,882.462 ms