explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kZSR

Settings
# exclusive inclusive rows x rows loops node
1. 547,581.280 547,581.280 ↓ 1.9 1,763,989 1

Index Scan using idx_cached_application_logs_property_id_reporting_daterange on cached_application_logs cal (cost=0.56..1,073,363.81 rows=923,435 width=215) (actual time=6.820..547,581.280 rows=1,763,989 loops=1)

  • Index Cond: ((property_id = ANY ('{53002,53005,53006,53008,53009,53015,53020,53022,53025,53027,53029,53031,53032,53036,53037,53046,53047,57617,57626,57631,57635,57637,57643,60945,63910,73612,77450,77451,77455,82061,82327,83208,85970,85971,85972,92513,95602,97348,98122,98598,103188,105916,105919,105920,105922,105923,105925,111331,111334,111336,111621,124964,124965,124966,136761,136767,140052,141581,152516,158104,158105,161971,168770,175391,176044,176045,176049,188355,188640,188641,188642,194280,194327,194828,197785,198582,203558,203559,203560,203561,203562,203563,203564,203566,203567,203574,203575,203576,203577,203581,203582,203584,203587,203588,203590,203591,203592,203593,203594,203595,203596,203597,203598,203599,203600,203601,203602,203603,203604,203605,203606,203607,203608,203609,203610,203611,203612,203613,203614,203617,203620,203621,203622,203623,203624,203625,203626,203628,203629,203630,203631,203632,205546,206787,206844,207222,227416,228797,239797,239798,239799,241830,246413,257418,257975,259345,260068,260071,260072,260613,261098,262530,262531,262532,262533,262534,262535,262536,262537,265107,265108,267298,267887,324570,324606,325212,328174,329162,336664,336665,336666,336667,336668,336670,351637,351638,354393,356930,359671,489322,490356,490992,490993,490994,496584,496585,497202,497293,502779,502780,502781,505973,505974,506114,506115,506814,506815,508483,508485,508487,508491,508492,509361,509867,509868,515534,519458,519600,519601,522088,522089,522090,522091,522092,522094,522095,522096,526846,531718,532286,532287,532367,536130,536132,536133,536634,536635,536699,544145,553515,553516,553517,555976,557962,557963,557964,570902,570903,575742,577292,577293,577841,577842,582920,585686,590181,592295,614503,614504,614505,614506,614507,628897,628898,628899,628900,628901,628902,628903,628904,628905,629387,629388,629389,629390,629391,629392,629393,629394,629395,637776,637777,637778,637779,637780,637781,637782,637783,640618,640840,640841,640842,640843,640844,640850,640851,641400,641401,642940,643591,643592,644178,653376,653377,662849,662850,662851,666596,666597,666598,666599,666600,666601,666602,666603,666604,666605,667430,672230,672231,672232,672233,674353,674354,674355,675762,675771,675772,676465,676466,678310,681195,686618,687239,691025,691725,691726,691727,691728,691729,691730,691731,691732,691733,691734,691735,691736,692215,692216,701973,701974,705117,710670,710671,714316,714317,714318,714319,714320,714321,714322,714323,714324,714325,714326,714327,714328,714329,714330,714331,714332,714333,714334,714335,714341,714342,723988,744020,744028,773829,773830,779456,782769,782770,792420,792421,792422,792423,792424,792425,792426,792427,792428,792429,792430,792431,792432,792433,792434,794129}'::integer[])) AND ('12/31/2019'::date >= reporting_post_date) AND ('12/31/2019'::date <= apply_through_post_date))
  • Filter: (cid = 3395)
Planning time : 4.860 ms
Execution time : 547,863.611 ms