explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nxFV : Optimization for: plan #UyJx

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=497.73..497.83 rows=1 width=72) (actual rows= loops=)

  • Group Key: t_intake.intake_id
2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=497.73..497.77 rows=1 width=97) (actual rows= loops=)

  • Group Key: t_intake.ttcustomer_id, t_intake.intake_id, t_user_score.user_score_id, t_scoring_profile.calculation_type
3. 0.000 0.000 ↓ 0.0

Sort (cost=497.73..497.73 rows=1 width=48) (actual rows= loops=)

  • Sort Key: t_intake.intake_id, t_user_score.user_score_id, t_scoring_profile.calculation_type
4. 0.000 0.000 ↓ 0.0

Result (cost=2.26..497.72 rows=1 width=48) (actual rows= loops=)

  • One-Time Filter: ((current_setting('arena.ttcustomerId'::text))::numeric = '865412021'::numeric)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.26..497.72 rows=1 width=48) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.83..489.36 rows=1 width=56) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.41..480.96 rows=1 width=37) (actual rows= loops=)

  • Join Filter: (t_scoring_profile.scoring_profile_id = t_user_score.scoring_profile_id)
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..472.96 rows=1 width=57) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using t_intake_type_idx1 on t_intake_type (cost=0.29..8.30 rows=1 width=27) (actual rows= loops=)

  • Index Cond: ((current_entry = '1'::numeric) AND (ttcustomer_id = '865412021'::numeric))
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..464.65 rows=1 width=59) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using t_intake_idx1 on t_intake (cost=0.42..456.33 rows=1 width=38) (actual rows= loops=)

  • Index Cond: ((intake_type_id = t_intake_type.intake_type_id) AND (ttcustomer_id = '865412021'::numeric) AND (current_entry = '1'::numeric))
  • Filter: (intake_id = ANY ('{2050798156,2060444533,2060167715,2060156416,2060258708,2057715841,2060188608,2060447191,2060544677,2060443895,2059704394,2056378061,2059939040,2059375765,2059740237,2045661749,2058168893,2054793768,2060497405,2050520446,2060379393,2060274581,2059880087,2060223813,2057952746,2055602251,2055604046,2059123844,2055074017,2055575516,2055579743,2060058863,2057927836,1975289025,2059725326,2051228383,2059620494,2059623044,2059060945,2060445970,2060426364,1974640697,2059439454,2059439485,2059439515,2042614484,2048848857,2057711246,1996090395,2060370701,2049620845,2048449947,2060427582,2047603503,2050953730,1897875494,2059128725,2020195088,2048751515,2059396354,2057279189,2044518396,2033784214,2058039584,2060287025,2060273599,2060401779,2059747443,2059749616,2059750997,2060379260,2060242236,2059209042,2060148638,2059329926,2059771482,2059762277,2053487771,2060238812,2059531785,2060482479,2058628640,2058085916,2060388273,2060370461,2060341323,2060378423,2060365983,2055659284,2055762351,2060159656,2056560950,2034287887,2059583282,2059581066,2059190204,2059143126,2058973676,2058950827,2059099456,2058472170,2059498908,2049084103,2059190394,2060308866,2060406626,2060349561,2059421412,2054695078,2056276143,2058276939,2058276188,2057275816,2057114527,2055815453,2058329194,2060212545,2060373771,2050661752,2060311781,2058116205,2060363678,2060412025,2060379427,1668620129,1969058679,1725164127,1990943374,1977605791,1657279828,1657283976,1657288637,1990165393,2001489525,1905433393,2046981561,2043049098,2042705614,2038159406,2045972042,2035969122,988640188,988640809,988642226,1754069120,988640988,988640137,988642307,988638624,988638692,988640110,988640227,988639093,988641872,988640783,988640238,1694660624,988638684,988639501,988641613,988642200,1929162652,988640603,1694654646,1662755840,988640545,988640662,988640438,988640440,988641463,988640114,988638632,988642012,988639612,988640081,988640194,1733086646,988642028,1018198469,1018204919,1963421592,998228322,1694660566,1663809195,988638739,1001066467,1001062494,988640250,988640050,988638640,1650985930,2026461802,2026461739,2026461774,988639219,1706773859,1754892239,988639226,988641354,988640853,1524097082,1749545791,1751239936,988641531,1532848567,1647589596,1679609301,1690464344,1596857232,1666715633,1666716106,1667639355,1638890308,1618983644,1685737777,1523513482,988638869,1676004612,1991334908,987022883,988641866,988638893,988638604,2041935597,988640386,988641959,2016044851,2016072312,2016072349,988640677,988638771,988641069,1591335462,1663891117,1960318173,1960322022,1960323996,1960315174,1760784316,1613713683,2040795796,1914025920,1745237617,1766806882,1768226451,2025612856,1996469583,1990073955,1987633443,2016724815,2024946558,988640396,1610548808,2001837407,1532520866,1604005185,1663808197,1663808318,1663808342,2042426889,2049478510,2023343217,1724263982,1726392120,1551934309,1957827156,1638688734,1711625416,1950919281,1987350568,1925546454,1609706595,1002620213,1648621787,1697658197,1968259286,2000401122,1651333103,1652086842,1652566398,1986406538,1986406870,1751836827,1993424776,1976999228,1978582153,1598404617,2018736929,2014772952,2022996393,2022996944,1739588294,1715262183,994244883,2016334163,1694012546,1664166293,1684367539,2020513250,2043149956,1642897650,1949887869,1956530098,1969479070,1676478778,1905345900,1917320856,1694460418,1982542027,1901714637,1639080240,2008755956,1657716613,1926795018,1698523316,2049872021,2049860991,2054231362,2054230755,2054229609,2054231704,2030499264,2054228925,2054228560,2054228256,2048835919,2048851878,2046691262,2046688358,2017648735,2017653235,2029006994,1725199629,1725544884,1912986337,1912988082,1938786582,1676881471,1546914682,1647761568,2017689408,1918807057,1654113530,1902149624,1706654115,1945782171,1766876704,2031870494,1699064487,1650853162,1538608868,2031090625,1972897450,1972894648,1636103494,1931367669,1666391988,1686262826,1657542494,1680200503,1961873049,1533176148,1895441544,1896026187,1937710326,1961874402,2054234516,1733061425,1619783288,1544099543,1611557629,1604188017,1580308674,1610161189,1604188337,1604188568,1598686119,1553517571,1584057341,1546947986,1541343815,1596629661,1596631626,988639865,2040702574,2031074022,2054308348,1961880345,2041728189,1917518559,2026605806,1980622817,991225776,2034049081,1970747395,1970730504,1008114386,1611546700,986451113,988640070,988639349,1971935799,1983878538,1989392641,1989382140,1012143079,1733492298,2048690889,1977358979,1606282178,988640937,2057191712,2057195298,1959957861,1929642247,1968398627,1968408196,1963013996,1963026701,2055979288,1581796715,2019034917,1012620226,1012623007,1013778128,1013778901,1763852681,1765876585,1982199448,1011666119,1597265239,1985864985,992242992,2000557318,1773806225,1763433527,1759733382,1767862162,1767862242,1767862112,1704593883,1712141850,1651687679,1651692518,1662235257,1616508624,1661872561,1593351751,1648681988,1026662935,1678456305,1678462620,1905552877,2029793679,2045916903,2027728860,1950797771,1651798012,1897986976,1771962412,1693611780,1646683246,1987491543,1934593164,1969781108,2040353334,2042770524,1962449361,1611745720,1645759777,1924713574,1941448807,1943240314,2041369592,1924710443,2038416433,2057598867,2051616781,2032994289,1987528326,2025044323,2027500367,2025612077,2013792729,2044724745,988639085,988638648,1549523960,1934964977,1925861094,1663545231,2028728902,1964252426,1969505643,1969502673,988640769,1724743683,2052414236,988884414,1003253955}'::numeric[]))
12. 0.000 0.000 ↓ 0.0

Index Scan using t_scoring_profile_idx on t_scoring_profile (cost=0.28..8.31 rows=1 width=21) (actual rows= loops=)

  • Index Cond: ((ttcustomer_id = '865412021'::numeric) AND (scoring_profile_id = CASE t_intake.scoring_is_locked WHEN '1'::numeric THEN t_intake.orig_scoring_profile_id ELSE t_intake_type.scoring_profile_id END) AND (current_entry = '1'::numeric))
13. 0.000 0.000 ↓ 0.0

Index Scan using t_user_score_idx1 on t_user_score (cost=0.42..7.99 rows=1 width=33) (actual rows= loops=)

  • Index Cond: ((parent_type_id = '96'::numeric) AND (parent_id = t_intake.intake_id) AND (ttcustomer_id = '865412021'::numeric) AND (current_entry = '1'::numeric))
14. 0.000 0.000 ↓ 0.0

Index Scan using t_user_score_cat_lin_idx1 on t_user_score_cat_link (cost=0.42..8.38 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((ttcustomer_id = '865412021'::numeric) AND (user_score_id = t_user_score.user_score_id) AND (current_entry = '1'::numeric))
15. 0.000 0.000 ↓ 0.0

Index Scan using t_user_score_crit_li_idx1 on t_user_score_crit_link (cost=0.42..8.34 rows=1 width=25) (actual rows= loops=)

  • Index Cond: ((ttcustomer_id = '865412021'::numeric) AND (user_score_cat_link_id = t_user_score_cat_link.user_score_cat_link_id) AND (current_entry = '1'::numeric))