explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lr8V

Settings
# exclusive inclusive rows x rows loops node
1. 221.999 19,763.029 ↑ 1.3 242 1

HashAggregate (cost=1,527,226.63..1,527,229.73 rows=310 width=23) (actual time=19,763.006..19,763.029 rows=242 loops=1)

  • Group Key: driver
2. 19,541.030 19,541.030 ↑ 1.2 1,013,959 1

Seq Scan on driver_events_raw_last_2_months (cost=0.00..1,521,069.99 rows=1,231,329 width=23) (actual time=0.201..19,541.030 rows=1,013,959 loops=1)

  • Filter: ((driver)::text = ANY ('{17503081257600,15308181005700,HUG00001132950,UAD00000826500,18909130639000,18604271241300,UAD00000700820,19111060597900,16705141543000,17506150039800,UAD00000639860,16702160135900,17906131411500,17703151819200,UAD00000907630,16404220459000,15910121385700,17408210847700,UAD00000866210,17204280891100,16605200101700,17603161575500,18310101147400,UAD00001102600,UAD00001284860,17407170603301,15805011115100,15612060135700,16611130977100,DF000003880960,UAD00001047140,UAD00000097450,00000000053IB0,18805101311400,UAD00001335760,15309061537100,15412270829400,17603031199700,00000000058220,UAD00001293540,19707220589900,19112270313300,UAD00000319710,15412271027500,UAD0000003TCV0,UAD00000750040,UAD00001554630,GE100000044580,17308170039000,UAD00001189640,15901120369200,17807081229800,UAD00001394050,18108181365700,16801030973500,18209101545300,17411220339000,UAD00000476680,DB170971620448,UAD0000003YTC0,16501020541200,15908310895400,16503221005200,UAD00000687580,18005271035900,16301041321500,18310131231500,UAD00000244140,16201090107200,17108220207100,00000000725200,UAD00001334680,14602010293100,07137130917900,15805251219600,17410110431800,UAD0000004FIE0,17305191249500,16901070667600,UAD00000691970,17205101011000,UAD00000602930,16305041161300,17508041001400,18006021339800,18307170355100,17711061525900,17807150201900,19004130707100,17705071039900,16301020705200,UAD00001075360,17606181585100,19501110589300,17003201047200,16612080499500,18112231127400,16502220585500,UAD00000521720,UAD00000406610,UAD0000004CY80,15404230983800,UAD0000003OJC0,16001190331400,18901210807800,15509131147800,17803091183200,HUG00000975270,18106171959300,15512200003400,18905280851400,UAD00000670290,UAD00000717090,UAD00000409230,UAD00000082610,17606240441400,17611140747800,UAD00000871390,UAD00000292400,14605200457900,16405180349400,18312251613000,18308161219900,UAD00001053610,18203020911800,UAD00000320260,UAD00001376460,UAD00000686760,UAD00000943110,17903292129800,18010220243600,16212281295801,16907270517400,19404010857200,17309211121700,17009071287700,16609160329000,UAD00001536710,UAD00001322450,UAD00000690010,18102150093700,15901120807900,16009230485300,15901290397300,17804150019900,18504131287701,16006200419400,15603301009300,00000001271000,16811290097500,18010210843500,07130917900900,17401221079300,UAD00000905730,UAD00000450420,UAD00000312510,00000001337660,UAD00000704690,16204100449400,16807140207500,17902261689200,15811231055700,UAD00000943220,19308270677500,18212301155200,18307101945200,19307221177700,44001D00346A72,UAD00001012830,17910271399600,16811260701800,16710030915000,19308310637600,UAD00000911470,UAD00001177570,UAD00000613180,15906241261600,DF000059975020,16807110191200,UAD00001020320,19702151001600,18103081205800,UAD00000769050,18302131957100,18904271737200,18302150335400,19109110977400,UAD00001220840,UAD0000004A4Z0,17808171000000,15510150121300,UAD00000893150,16812290637800,UAD00001171370,18607011297300,17910151605700,18211030443200,UAD00001288310,19209221139000,16503140457700,UAD00000630050,18801261255400,17201241443800,18306171301000,16606211351500,17207221423200,UAD00000317950,18304111967800,17108180275300,16509181459800,0000000008LSM0,19308040271000,16308250000000,17603181831800,UAD00000516610,UAD0000003PGK0,18802160551800,17602251823000,16902160777900,16710310549400,00000000031JN0,18309282157700,UAD00000843860,17903010585800,UAD00001473360,UAD00000754980,UAD00001517700,17607291593300,18403071977600,17808020139200,19708110577100,UAD00001072510,D3000200443ACD,17604250709200,17611020495300,UAD00000692760,DF000082498210,UAD0000003LCL0,16110130151700,16105141027300,16001230091200,15708230379000,19508170921600,16709120127300,18601071191600,19203220745800,UAD00000593480,18412301393000,UAD00000908610,18811040989401,15606071333600,19010200003300,19206140063300,00000000122650,16107010435100,UAD00000617540,19502270777400,19311020299600,16608010271301,16105110363000,17402201339700,UAD00001276120,UAD00000680840,UAD00000354320,18408311657500,UAD00000473090,DF000168760440,16408060717700,16806150691400,UAD00001045140,18001070893200,17403110411000,19204051253500,16401230911700,UAD0000003EFQ0,UAD00001066570,15502140795200,17902181833200,16211210769100,17912011315800,19306290829800,18907130917900,DF000229965500,17611141129100,UAD00000242220,17307271017900,18306041267500,UAD00001487750,18410031631700,UAD00001534690,18704061707600,16703300045401,UAD00000308030,19308080181600,17809220945000,18901041157200,17209161137700,18211220103400,16207200921700,UAD00000305550,UAD00000471180,18604011761600,18807160713300,UAD00000469620,51400000344110,16309050865600,15601041763100,17004130021201,19505091203000,UAD00001451020,V1000001217580,16404020817600,15906111181300,19506130163800,UAD00001068200,17403151497500,UAD00001113670,19204030771700,18002061801400,16804261195400,18708240839300,15708120605600}'::text[]))
  • Rows Removed by Filter: 2558024