explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OcO8

Settings
# exclusive inclusive rows x rows loops node
1. 573.950 873.485 ↑ 3.0 662 1

Bitmap Heap Scan on used_vehicles_usedcarinventory (cost=25,901.13..108,054.77 rows=1,957 width=5) (actual time=307.791..873.485 rows=662 loops=1)

  • Recheck Cond: (model_id = ANY ('{1120,1282,2329,1197,1425,1145}'::integer[]))
  • Filter: ((NOT removed) AND ((condition)::text = 'Pre-Owned'::text) AND (lead_provider_id = ANY ('{1,2,3,4,6}'::integer[])) AND (year_id = ANY ('{1,2,3,33,30,31}'::integer[])) AND ((dealer_zipcode)::text = ANY ('{32976,32834,32839,33622,32887,33803,33679,32853,33154,33906,32792,33449,34106,32814,33321,33571,34760,33950,32712,32708,33846,34958,32969,33684,32810,33848,33424,34292,34436,33164,33967,33990,33151,33838,34983,34265,32777,34778,33141,33655,33076,34949,33064,33884,33313,33461,34661,32710,33944,34769,33197,33428,33862,33682,33875,33336,32950,34461,34235,34142,33487,32901,33056,33826,32932,33903,33675,33896,34281,33567,33586,33177,33850,33883,33339,32836,33125,32756,34956,34982,33093,33156,33427,33152,33307,33455,33618,33530,33222,33245,33835,33607,34995,33036,33303,32931,32903,33133,33144,34120,33844,33689,33513,33482,33462,33830,33158,33484,33062,34268,33865,32757,34143,33845,33585,33024,33010,32896,33956,33308,33685,34992,32821,34112,32791,33574,33858,33306,33345,33686,33919,33584,34736,33432,33101,33340,34202,33965,33162,33016,32859,34744,34777,33073,33419,33142,33563,32971,33598,33885,33570,34713,33917,33852,33820,34948,32835,33023,33493,34947,33170,33565,33025,33332,33902,34280,33526,32922,33082,34101,33910,32970,33349,33870,33454,33315,33579,33153,32789,34135,33806,34136,32822,34240,34289,32783,34729,32966,33122,32745,33650,33051,32937,33921,33955,34603,33039,33403,34985,33539,32909,33915,33334,33261,33116,33619,33014,33426,32960,33280,32955,33437,33255,34950,34762,33070,33929,34295,34988,33922,33050,33335,34238,32825,33680,32820,33021,33002,32752,33481,34285,34275,32858,32964,32978,33169,33827,33042,32878,34953,33017,32958,34758,33928,34223,33498,33907,34979,33901,33322,33673,33569,34786,33231,33127,33161,33157,33265,33416,34711,33441,32919,33559,33876,33458,33417,34145,33859,33150,34291,33931,33310,34114,33972,33434,33867,34741,34611,33028,33973,33325,32707,33348,32727,34116,33409,33991,33004,34636,34973,32815,33508,33037,33015,34984,33464,33243,32714,33834,32953,33404,34787,33324,33694,33473,33620,33662,33596,32701,33930,33179,33825,34789,33296,33040,34773,32924,33849,34749,33075,33475,33030,33166,32957,33688,33578,33957,34745,34103,32927,33857,33890,33066,32808,33593,33031,33198,33330,33425,32718,33092,33549,33631,33976,32857,33466,34761,34771,33568,33445,34287,33239,34637,34605,34140,33077,33401,34232,33188,33233,33521,34251,33084,32905,33882,33052,32826,33305,32817,32778,33994,33412,34946,34288,33429,33328,33918,33547,34996,33595,33146,33474,33160,33823,33543,34113,32751,33193,32962,34266,32746,33541,33327,33480,33026,33575,33971,33114,33811,33815,33418,33914,32762,33143,32956,34785,32730,34284,33032,33422,33630,32805,33911,33174,34737,33438,33510,33033,32856,33266,33908,32860,33938,33981,34974,33483,32807,33435,33304,34746,34450,33633,32963,34224,33019,34201,34797,33083,34994,33951,33525,32912,33149,32831,33847,32794,33128,32798,33102,33312,33182,32951,33687,32775,33566,33945,33408,33124,34739,32759,32959,34715,33388,34107,33613,32750,33511,33063,33196,32904,32795,34705,33446,34712,33810,33807,33603,33137,32801,33468,33020,33949,33548,33043,33359,32967,33168,32779,33542,33802,32830,33905,33178,33194,33163,33524,32811,33311,33947,33433,33172,34146,32868,33936,33471,32816,34742,33074,34987,32861,33337,33801,33132,33497,33459,33813,33993,33924,33238,34957,32833,32911,32926,34604,32773,32949,33871,32872,32703,32886,33065,32781,33841,34117,34141,33351,34990,33496,32799,34453,33060,32948,34743,33309,33155,32715,32812,34119,34734,33185,33809,33090,33605,33854,33184,33131,33012,33623,33527,33935,33974,33186,33932,33440,34212,33612,33646,33564,34104,34233,33045,33909,33467,32961,33136,33234,34945,32828,33514,33247,33138,33448,33523,33326,32935,33041,32854,33863,34241,32867,32954,32891,32934,34102,33355,33011,33920,33470,33805,32869,33545,34110,33839,33421,32819,32908,32793,33488,33954,33192,33329,32824,33672,33460,34997,33486,32733,33509,33617,34740,34639,33856,34951,33407,33946,33544,32716,33576,34601,32902,33027,33851,34759,34274,33176,32754,32764,33681,33173,33430,33477,33912,34108,33877,33463,32719,32829,34219,33256,33055,33242,33916,33301,33420,34211,33269,32809,33853,34972,34290,32704,34272,33913,32776,32906,33572,33587,33135,33346,33189,33868,34731,33181,33411,33109,33597,33443,34204,33147,33167,32837,33145,33013,33897,34133,33904,33503,33469,33069,34991,32796,32940,33472,33338,32965,32790,33647,33111,33664,34954,32732,34952,33415,33067,34748,33677,33034,33476,33927,34602,33534,33314,33608,32877,32936,33299,33165,34139,33190,33206,33414,33898,33983,33022,33402,32862,32923,33436,33982,33948,33602,34138,34134,33604,32780,34137,33431,34638,33068,34282,33674,33873,32802,32855,32803,33840,33071,33970,33018,33860,33257,32818,33199,33081,33660,33323,33606,32747,33410,33610,32899,33499,32920,33836,33316,34756,33180,32766,33035,33140,34986,33621,33966,33318,32897,33812,33855,33054,33478,34105,33394,34260,32885,33413,33537,33594,33583,34451,33405,33837,33960,33119,32832,33195,34229,34753,33129,33444,33283,33134,33097,34747,32952,33538,33442,32765,33663,33804,32768,32910,33953,32709,33843,32941,33009,34109,33975,33406,34293,34772,34267,32968,33061,34269,33139,32907,33465,33880,33872,33302,33573,33175,32806,33001,34286,33952,32771,33331,33317,33888,33980,33191,33072,34755,33126,33881,33320,32804,33592,32827,33831,34452,34714,33319,34770,33540,33112,34981,33130,33008,32772,33661,33029,33637,32925,33183,33187,32726,33550}'::text[])))
  • Rows Removed by Filter: 30881
  • Heap Blocks: exact=26399
2. 49.399 299.535 ↓ 0.0 0 1

BitmapAnd (cost=25,901.13..25,901.13 rows=17,482 width=0) (actual time=299.535..299.535 rows=0 loops=1)

3. 95.700 95.700 ↓ 1.2 399,909 1

Bitmap Index Scan on used_vehicles_usedcarinventory_removed_eca6c46f (cost=0.00..9,426.01 rows=328,210 width=0) (actual time=95.700..95.700 rows=399,909 loops=1)

  • Index Cond: (removed = false)
4. 154.436 154.436 ↓ 1.2 560,727 1

Bitmap Index Scan on used_vehicles_usedcarinventory_477cbf8a (cost=0.00..16,473.89 rows=484,703 width=0) (actual time=154.436..154.436 rows=560,727 loops=1)

  • Index Cond: (model_id = ANY ('{1120,1282,2329,1197,1425,1145}'::integer[]))
Planning time : 6.334 ms
Execution time : 874.415 ms