explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jdtK

Settings
# exclusive inclusive rows x rows loops node
1. 0.282 2.716 ↑ 1.0 619 1

Hash Join (cost=304.57..1,387.03 rows=620 width=142) (actual time=1.481..2.716 rows=619 loops=1)

  • Buffers: shared hit=1302
2. 0.436 2.357 ↑ 1.0 619 1

Hash Join (cost=302.04..1,382.78 rows=620 width=90) (actual time=1.332..2.357 rows=619 loops=1)

  • Buffers: shared hit=1298
3. 0.665 1.755 ↑ 1.0 619 1

Bitmap Heap Scan on mod_object o (cost=293.5..1,372.52 rows=620 width=78) (actual time=1.128..1.755 rows=619 loops=1)

  • Buffers: shared hit=1291
4. 1.090 1.090 ↑ 1.0 619 1

Bitmap Index Scan on sys_c0016839 (cost=0..293.35 rows=620 width=0) (actual time=1.09..1.09 rows=619 loops=1)

  • Index Cond: (o.object_pk = ANY ('{11790,11663,11644,11642,10560,11659,11712,11746,11199,11204,11786,11795,11789,13430,11115,11211,11793,11190,11222,11111,11828,11821,10706,11807,10529,11321,11239,11818,11271,11234,11261,11279,11295,11212,10483,10550,11296,9664,9237,11341,11343,11326,9810,11385,9816,9818,11238,10249,11384,10244,11464,10370,11477,9897,10260,10204,10327,10696,11512,10321,11525,10747,10739,10790,10736,10820,10755,10999,10759,11000,11885,10746,12422,10824,10838,10865,10858,10813,10867,10881,10793,10724,10757,10852,10893,10899,10917,10915,10918,10896,10822,2452,10851,11077,11038,11169,11053,11056,10548,10883,11082,10880,10251,11127,11980,11137,11899,11895,11900,11967,11966,11981,11985,12011,11973,11983,12017,10701,11623,11582,11584,11558,11608,11662,11660,10537,11698,10708,10305,12910,10603,10524,10721,10704,10754,13304,12535,12688,12763,12781,4339,12710,13511,12780,12435,12800,12388,12667,12589,12405,12443,12935,12397,12385,12927,12366,12804,12803,12802,12568,12806,12824,12975,12419,12801,12607,12613,12807,12808,12816,11957,12812,12805,12814,12817,12818,12815,12819,12615,12556,12566,12552,12822,12832,12820,12827,12826,12823,12831,12828,12833,12829,12830,12657,12663,12664,12840,12073,12873,12861,4442,12871,12866,12565,12838,12541,12874,12083,12860,12869,12306,12872,12862,12867,12839,12868,12108,12685,12863,12841,12558,12656,1323,12836,12307,12912,12865,12809,12882,12880,12876,12896,12864,12878,12908,12837,12898,12899,12879,12665,1059,12909,10931,12897,12900,12911,13273,12204,12635,12883,12913,12923,12925,12884,12920,13431,12901,12903,12921,12918,12924,12919,12622,12885,12886,12888,12889,12926,12929,12915,12712,3167,13492,12969,12933,12569,12887,12890,12892,12377,12378,12916,12936,12905,12931,12891,12441,8095,844,13478,13471,13434,12653,12456,12932,12928,12906,12937,12893,12894,12895,12687,12957,12821,12960,12941,12983,12973,12959,12958,12961,12904,12942,10185,13368,12287,12953,12952,8048,13454,12454,12944,12962,12945,9481,12963,12946,12966,12947,12948,12949,12582,13030,12954,7580,12950,12971,12974,7581,12951,11051,12972,10895,7582,13411,13359,13303,12978,13000,12988,12979,12970,12980,12989,13002,12981,12985,12982,7942,13342,12811,13435,12286,12991,12984,12993,12986,13006,12992,12987,12994,12995,12996,12997,13010,12998,12999,13011,4853,13023,12934,13035,13033,13032,13012,13024,13031,13025,13026,13046,13034,13050,13040,13036,11166,11716,13014,13059,13047,12055,13015,13041,13056,13048,11898,13064,12090,13060,13037,13051,11672,11749,12717,13016,13057,13049,13029,13058,11221,13017,13042,13038,13052,11720,11756,11748,10621,11207,11213,13018,11214,11197,13043,7934,13044,11753,11758,13039,13019,13045,11236,11237,10351,13020,11206,11275,11277,11235,5209,10552,10345,10482,11349,9766,11387,13021,11274,9848,9905,9899,13055,9886,10505,10509,11501,10344,11514,11533,11553,11630,11632,10620,6134,10514,10694,10613,10703,10726,10559,9604,12902,10553,10841,10959,10979,11081,10906,10795,10513,10932,10897,11017,13053,11034,11046,11071,11136,11833,11988,12086,12216,13063,13008,13027,2597,5316,13070,13071,13066,13083,13065,13122,13429,13069,13077,13072,13078,13068,13073,13079,13080,13004,13075,13076,13074,13086,13084,13085,13124,13125,13105,13113,13114,13115,13088,13089,13090,13092,13133,13141,13101,13158,13146,13413,13099,13485,13191,13494,13149,13170,13148,13135,13137,13129,13132,13100,13140,13154,13180,13160,13167,13177,12977,13182,13183,13181,9480,13022,13224,13220,13192,13493,13201,8125,13240,13373,13195,13229,13260,13230,12834,13422,13175,13423,13222,13225,12677,13196,12198,12453,13263,12662,13226,13525,13264,13189,13266,12943,13227,13265,13267,13269,13270,13271,7992,12955,13200,13097,13098,13103,13087,13198,13199,13268,13272,13526,3977,13121,13126,1}'::bigint[]))
  • Buffers: shared hit=1244
5. 0.037 0.166 ↑ 1.0 68 1

Hash (cost=7.68..7.68 rows=68 width=28) (actual time=0.166..0.166 rows=68 loops=1)

  • Buffers: shared hit=7
6. 0.129 0.129 ↑ 1.0 68 1

Seq Scan on mod_object_type ot (cost=0..7.68 rows=68 width=28) (actual time=0.022..0.129 rows=68 loops=1)

  • Buffers: shared hit=7
7. 0.038 0.077 ↑ 1.0 68 1

Hash (cost=1.68..1.68 rows=68 width=22) (actual time=0.077..0.077 rows=68 loops=1)

  • Buffers: shared hit=1
8. 0.039 0.039 ↑ 1.0 68 1

Seq Scan on mod_status mod_status (cost=0..1.68 rows=68 width=22) (actual time=0.016..0.039 rows=68 loops=1)

  • Buffers: shared hit=1