explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1oWX

Settings
# exclusive inclusive rows x rows loops node
1. 104.602 125,308.737 ↓ 685.3 4,797 1

Hash Join (cost=5,412.51..75,939.54 rows=7 width=48) (actual time=1,780.565..125,308.737 rows=4,797 loops=1)

  • Hash Cond: (card_field_values.card_phase_detail_id = card_phase_details.id)
2. 123,425.402 123,425.402 ↓ 1.7 137,754 1

Index Scan using idx_cfv_on_field_id_deleted_at on card_field_values (cost=0.57..70,228.43 rows=79,758 width=51) (actual time=1.759..123,425.402 rows=137,754 loops=1)

  • Index Cond: ((field_id = ANY ('{5647467,5647518,5647674,6069559,6312806,6813621,6813691,7081391,7251428,8507262}'::integer[])) AND (deleted_at IS NULL))
3. 2.191 1,778.733 ↑ 1.4 4,387 1

Hash (cost=5,334.83..5,334.83 rows=6,168 width=8) (actual time=1,778.733..1,778.733 rows=4,387 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 236kB
4. 1,776.542 1,776.542 ↑ 1.4 4,387 1

Index Scan using idx_cpd_on_card_id_deleted_at on card_phase_details (cost=0.57..5,334.83 rows=6,168 width=8) (actual time=0.010..1,776.542 rows=4,387 loops=1)

  • Index Cond: ((card_id = ANY ('{18049897,18074385,18078304,18173221,18189803,18190921,18214676,18217028,18217413,18257564,18260002,18267195,18277445,18313137,18460240,18460852,18493646,18504789,18539466,18543016,18552093,18557026,18614356,18621756,18656181,18659528,18678020,18714281,18719318,18721206,18722290,18727862,18730983,18732821,18771806,18776317,18791741,18791775,18838154,18849697,18854240,18863556,18868157,18877258,18877271,18877410,18877718,18879587,18881156,18884755,18891504,18905082,18911342,18914314,18916758,18925915,18934181,18934763,18966521,18973894,19024803,19080912,19096417,19103040,19104946,19109220,19122313,19123009,19149357,19158888,19168367,19170584,19174517,19175717,19176554,19246377,19257361,19261291,19272826,19293690,19296272,19296511,19307693,19323136,19326763,19356809,19356898,19361671,19379682,19380215,19380360,19381039,19381655,19383026,19397691,19442039,19449232,19449778,19461248,19476755,19480538,19502788,19504333,19504499,19523341,19558425,19566303,19586399,19587812,19592478,19594409,19595761,19595917,19624141,19629718,19635717,19642621,19644320,19696442,19714198,19733344,19757177,19764279,19788836,19788960,19828079,19850395,19850735,19898211,19918620,19920527,19950551,19957796,19987328,20003364,20009780,20011101,20015595,20043316,20077864,20080922,20084317,20087135,20094859,20113653,20114017,20114710,20188666,20190527,20199939,20208472,20219221,20220688,20221207,20222680,20253323,20273007,20307841,20313305,20330344,20345400,20350242,20351968,20365961,20369863,20373039,20373613,20373668,20375942,20377954,20383850,20392441,20398900,20401818,20403288,20407334,20411020,20434888,20435136,20436755,20444232,20444418,20486504,20486604,20492527,20500833,20508534,20513573,20536883,20545192,20563146,20570512,20572981,20588170,20590430,20596464,20596684,20599675,20600802,20623210,20639382,20729872,20738162,20738350,20745693,20754817,20758748,20763695,20763714,20764751,20765373,20766432,20766473,20777515,20795541,20795622,20796302,20797094,20799042,20807738,20810693,20813096,20819440,20827677,20829690,20833486,20861507,20864960,20868512,20882879,20886495,20896241,20897555,20897993,20924700,20929309,20934499,20936414,20938842,20939340,20941165,20947188,20947924,20949047,20957354,20957513,20968088,20975137,20975195,20986617,20992430,21005438,21015213,21017849,21022084,21023541,21056468,21058260,21090155,21091933,21117953,21122450,21138666,21157271,21160875,21161327,21161934,21164735,21165343,21175238,21198325,21200706,21201357,21213846,21218649,21237656,21240144,21240893,21241279,21255151,21257732,21288388,21298519,21351299,21361714,21384504,21385823,21404549,21407491,21415744,21416804,21419198,21425609,21427388,21911870,21973905,21980086,21985450,21993845,22018879,22042626,22189084,22208023,22220640,22237518,22305394,22368730,22372860,22383935,22396214,22396614,22411740,22412563,22420469,22508176,22552252,22558857,22582990,22585229,22598135,22601178,22604127,22612493,22633873,22679708,22701147,22712724,22745366,23240253,23281259,23292009,23302310,23323445,23349206,23353114,23353641,23413640,23507162,23529526,23537346,23538209,23550645,23574092,23583356,23734883,23743897,23745833,23757262,23791746,23795603,23798397,23811099,23812270,23824073,23841910,23967556,23984386,24019079,24044502,24114649,24127072,24134610,24146039,24152348,24156062,24231752,24240026,24241405,24244474,24248530,24252961,24259764,24274428,24278908,24281781,24288043,24338218,24355835,24356833,24359778,24363025,24377212,24385653,24392561,24403377,24432960,24445272,24449316,24461963,24464288,24466775,24470484,24473915,24475038,24478724,24482237,24501609,24520017,24520894,24523802,24548791,24581626,24586167,24586613,24586624,24588133,24590449,24598911,24600181,24600906,24607222,24608199,24616938,24620792,24622468,24623474,24624976,24627106,24741278,24743563,24748927,24751804,24810470,24820457,24846684,24858337,24858803,24860794,24913105,24914808,24922535,24938781,24938794,24941179,24945057,24947829,24954558,24971325,24976170,24997595,25023261,25025718,25031013,25033592,25058686,25086026,25105474,25114319,25121953,25122505,25209698,25210156,25227026,25249556,25253612,25254269,25269857,25293218,25301788,25302008,25315706,25317880,25320769,25329515,25376688,25377187,25381711,25387873,25415447,25420042,25431780,25435386,25464680,25466314,25466943,25486438,25488087,25490949,25515017,25532404,25555463,25557252,25561648,25578981,25582113,25589047,25656799,25658101,25673318,25685184,25688011,25689528,25689927,25705464,25722344,25730349,25749509,25770137,25811568,25814258}'::integer[])) AND (deleted_at IS NULL))