explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5kS4

Settings
# exclusive inclusive rows x rows loops node
1. 27.531 1,660.532 ↓ 10.8 185,161 1

Hash Join (cost=1,739.70..171,574.33 rows=17,204 width=4) (actual time=14.237..1,660.532 rows=185,161 loops=1)

  • Hash Cond: (x.zo_id = z.zo_id)
2. 22.768 1,619.054 ↓ 10.8 185,161 1

Nested Loop (cost=2.89..169,600.96 rows=17,204 width=4) (actual time=0.246..1,619.054 rows=185,161 loops=1)

3. 0.879 1.482 ↓ 10.0 1,598 1

Hash Join (cost=2.32..166.91 rows=160 width=4) (actual time=0.189..1.482 rows=1,598 loops=1)

  • Hash Cond: (n.shop_concept = (sh.sh_id)::double precision)
4. 0.580 0.580 ↑ 1.0 1,599 1

Seq Scan on calc_nodes n (cost=0.00..154.99 rows=1,599 width=12) (actual time=0.079..0.580 rows=1,599 loops=1)

  • Filter: ((pe_id = 3) AND (se_id = 3013))
5. 0.005 0.023 ↑ 1.0 2 1

Hash (cost=2.30..2.30 rows=2 width=4) (actual time=0.023..0.023 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.018 0.018 ↑ 1.0 2 1

Seq Scan on calc_shopconcepts sh (cost=0.00..2.30 rows=2 width=4) (actual time=0.015..0.018 rows=2 loops=1)

  • Filter: ((pe_id = 3) AND (se_id = 3013))
  • Rows Removed by Filter: 18
7. 1,594.804 1,594.804 ↓ 1.1 116 1,598

Index Only Scan using rtpezocoav_unique on rtpezocoav x (cost=0.56..1,057.88 rows=108 width=8) (actual time=0.316..0.998 rows=116 loops=1,598)

  • Index Cond: ((pe_id = 3) AND (zo_id = ANY ('{629444,629445,629446,629447,629448,629449,629450,629451,629452,629453,629454,629455,629456,629457,629458,629459,629460,629461,629462,629463,629464,629465,629466,629467,629468,629469,629470,629471,629472,629473,629474,629475,629476,629477,629478,629479,629480,629481,629482,629483,629484,629485,629486,629487,629488,629489,629490,629491,629492,629493,629494,629495,629496,629497,629498,629499,629500,629501,629502,629503,629504,629505,629506,629507,629508,629509,629510,629511,629512,629513,629514,629515,629516,629517,629518,629519,629520,629521,629522,629523,629524,629525,629526,629527,629528,629529,629530,629531,629532,629533,629534,629535,629536,629537,629538,629539,629540,629541,629542,629543,629544,629545,629546,629547,629548,629549,629550,629551,629552,629553,629554,629555,629556,629557,629558,629559,629560,629561,629562,629563,629564,629565,629566,629567,629568,629569,629570,629571,629572,629573,629574,629575,629576,629577,629578,629579,629580,629581,629582,629583,629584,629585,629586,629587,629588,629589,629590,629591,629592,629593,629594,629595,629596,629597,629598,629599,629600,629601,629602,629603,629604,629605,629606,629607,629608,629609,629610,629611,629612,629613,629614,629615,629616,629617,629618,629619,629620,629621,629622,629623,629624,629625,629626,629627,629628,629629,629630,629631,629632,629633,629634,629635,629636,629637,629638,629639,629640,629641,629642,629643,629644,629645,629646,629647,629648,629649,629650,629651,629652,629653,629654,629655,629656,629657,629658,629659,629660,629661,629662,629663,629664,629665,629666,629667,629668,629669,629670,629671,629672,629673,629674,629675,629676,629677,629678,629679,629680,629681,629682,629683,629684,629685,629686,629687,629688,629689,629690,629691,629692,629693,629694,629695,629696,629697,629698,629699,629700,629701,629702,629703,629704,629705,629706,629707,629708,629709,629710,629711,629712,629713,629714,629715,629716,629717,629718,629719,629720,629721,629722,629723,629724,629725,629726,629727,629728,629729,629730,629731,629732,629733,629734,629735,629736,629737,629738,629739,629740,629741,629742,629743,629744,629745,629746,629747,629748,629749,629750,629751,629752,629753,629754,629755,629756,629757,629758,629759,629760,629761,629762,629763,629764,629765,629766,629767,629768,629769,629770,629771,629772,629773,629774,629775,629776,629777,629778,629779,629780,629781,629782,629783,629784,629785,629786,629787,629788,629789,629790,629791,629792,629793,629794,629795,629796,629797,629798,629799,629800,629801,629802,629803,629804,629805,629806,629807,629808,629809,629810,629811,629812,629813,629814,629815,629816,629817,629818,629819,629820,629821,629822,629823,629824,629825,629826,629827,629828,629829,629830,629831,629832,629833,629834,629835,629836,629837,629838,629839,629840,629841,629842,629843,629844,629845,629846,629847,629848,629849,629850,629851,629852,629853,629854,629855,629856,629857,629858,629859,629860,629861,629862,629863,629864,629865,629866,629867,629868,629869,629870,629871,629872,629873,629874,629875,629876,629877,629878,629879,629880,629881,629882,629883,629884,629885,629886,629887,629888,629889,629890,629891,629892,629893,629894,629895,629896,629897,629898,629899,629900,629901,629902,629903,629904,629905,629906,629907,629908,629909,629910,629911,629912,629913,629914,629915,629916,629917,629918,629919,629920,629921,629922,629923,629924,629925,629926,629927,629928,629929,629930,629931,629932,629933,629934,629935,629936,629937,629938,629939,629940,629941,629942,629943,629944,629945,629946,629947,629948,629949,629950,629951,629952,629953,629954,629955,629956,629957,629958,629959,629960,629961,629962,629963,629964,629965,629966,629967,629968,629969,629970,629971,629972,629973,629974,629975,629976,629977,629978,629979,629980,629981,629982,629983,629984,629985,629986,629987,629988,629989,629990,629991,629992,629993,629994,629995,629996,629997,629998,629999,630000,630001,630002,630003,630004,630005,630006,630007,630008,630009,630010,630011,630012,630013,630014,630015,630016,630017,630018,630019,630020,630021,630022,630023,630024,630025,630026,630027,630028,630029,630030,630031,630032,630033,630034,630035,630036,630037,630038,630039,630040,630041,630042,630043,630044,630045,630046,630047,630048,630049,630050,630051,630052,630053,630054,630055,630056,630057,630058,630059,630060,630061,630062,630063,630064,630065,630066,630067,630068,630069,630070,630071,630072,630073,630074,630075,630076,630077,630078,630079,630080,630081,630082,630083,630084,630085,630086,630087,630088,630089,630090,630091,630092,630093,630094,630095,630096,630097,630098,630099,630100,630101,630102,630103,630104,630105,630106,630107,630108,630109,630110,630111,630112,630113,630114,630115,630116,630117,630118,630119,630120,630121,630122,630123,630124,630125,630126,630127,630128,630129,630130,630131,630132,630133,630134,630135,630136,630137,630138,630139,630140,630141,630142,630143,630144,630145,630146,630147,630148,630149,630150,630151,630152,630153,630154,630155,630156,630157,630158,630159,630160,630161,630162,630163,630164,630165,630166,630167,630168,630169,630170,630171,630172,630173}'::integer[])) AND (co_id = n.co_id) AND (ad_id = 4))
  • Heap Fetches: 185161
8. 5.427 13.947 ↑ 1.0 21,884 1

Hash (cost=1,463.26..1,463.26 rows=21,884 width=4) (actual time=13.947..13.947 rows=21,884 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1026kB
9. 8.520 8.520 ↑ 1.0 21,884 1

Seq Scan on calc_zones z (cost=0.00..1,463.26 rows=21,884 width=4) (actual time=0.007..8.520 rows=21,884 loops=1)

  • Filter: ((pe_id = 3) AND (se_id = 3013))
Planning time : 2.761 ms
Execution time : 1,664.089 ms