explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vcY

Settings
# exclusive inclusive rows x rows loops node
1. 0.121 176,466.147 ↓ 396.0 396 1

GroupAggregate (cost=378,466.42..378,466.46 rows=1 width=127) (actual time=176,466.015..176,466.147 rows=396 loops=1)

  • Group Key: c.uuid, (CASE WHEN (s.followers <> 0) THEN (((COALESCE(c.comments, 0) + COALESCE(c.likes, 0)))::double precision / (s.followers)::double precision) ELSE '0'::double precision END)
2. 1.046 176,466.026 ↓ 397.0 397 1

Sort (cost=378,466.42..378,466.42 rows=1 width=63) (actual time=176,466.008..176,466.026 rows=397 loops=1)

  • Sort Key: c.uuid, (CASE WHEN (s.followers <> 0) THEN (((COALESCE(c.comments, 0) + COALESCE(c.likes, 0)))::double precision / (s.followers)::double precision) ELSE '0'::double precision END)
  • Sort Method: quicksort Memory: 80kB
3. 176.071 176,464.980 ↓ 397.0 397 1

Nested Loop Left Join (cost=352,117.49..378,466.41 rows=1 width=63) (actual time=1,038.705..176,464.980 rows=397 loops=1)

  • Join Filter: ((c.uuid)::text = (cp.content_uuid)::text)
  • Rows Removed by Join Filter: 2634977
4. 1.798 67.325 ↓ 396.0 396 1

Nested Loop (cost=5,295.37..31,438.40 rows=1 width=59) (actual time=41.823..67.325 rows=396 loops=1)

5. 15.624 58.399 ↓ 30.5 396 1

Bitmap Heap Scan on instagrampost c (cost=5,294.95..31,328.63 rows=13 width=85) (actual time=41.795..58.399 rows=396 loops=1)

  • Recheck Cond: ((createddate >= '2019-05-01 00:00:00'::timestamp without time zone) AND (createddate <= '2019-06-01 00:00:00'::timestamp without time zone) AND ((sourceid)::text = ANY ('{instagram_101428_17841401625745061,instagram_101428_17841400513933281,instagram_101428_54366860,instagram_101428_572679179,youtube_101428_UCVAFAVDJrSU1qCHP321HVVA,instagram_101428_6766640229,instagram_101428_17841402369456685,youtube_101428_UCxVa4ZcWGi_VStlkfmoteQ,instagram_101428_4608977435,twitter_101428_19763619,instagram_101428_17841401368600414,instagram_101428_17841400480364685,instagram_101428_182398809,youtube_101428_UCHQ6Rz7caWv2PCr6L9yVhHg,instagram_101428_17841401059762976,yotube_101428_UCAnWjBV2o6t5ATS_FgCqtlg,instagram_101428_17841400647512194,instagram_101428_182042831,youtube_101428_UCSEJEBvznNGTS8n21fB37fA,instagram_101428_17841401334524684,twitter_101428_207938014,twitter_101428_19226153,instagram_101428_1784140075044755,youtube_101428_UCbSJ0rahph9f8pOwih-k9RA,instagram_101428_17841401173425797,164344830303453,instagram_101428_17841401229613937,twitter_101428_1184765671,instagram_101428_17841402364302021,youtube_101428_UCj8vLYLtXOJ1y3t48pfxtZQ,linkedin101428_3823681,1654816274778494,instagram_101428_17841402976434559,twitter_101428_163539975,instagram_101428_17841401202073015,234551906637540,199262693510628,116919588378323,twitter_101428_137544133,instagram_101428_17841400652605503,instagam_101428_17841403300680401,youtube_101428_UCqxM1SVVcJh2xHeeegoJlA,youtube_101428_UCOliHkYnUVDRCU7DYDzH5tg,245745028798233,youtube_101428_UCVqdDRIjrr8v0ykaCMR5IyQ,linkedin_101428_10113587,twitter_101428_1603385773,youtube_101428_UCj4tEdLmxjWXemSLOLu4XLg,youtube_101428_UCB7coJSXQaDESKcpBUTR8g,twitter_101428_747238206198820866,youtube_101428_UC9O_4b4XNxhHN9vAa-duZ9Q,twitter_101428_16220541,instagram_101428_17841400332960779,twitter_101428_20687324,twitter_101428_16254749,youtube_101428_UCeguwe9wysMX9zo_05PMx_A,11516515204000,instagram_101428_17841400568497727,youtube_101428_UC9XZPfTheB2xRE0rgYCB__Q,twitter_101428_371643021,youtube_101428_UCutsOmLamc8i3AvWo0VxJag,instagram_101428_3180332777,303818232963593,twitter_101428_72887574,youtube_101428_UCbdZjWzvTFLJsZBcqkgCpA,219651984778,instagram_101428_17841401348974117,youtube_101428_UCsAGbvOnLc4ItBWb4NYcK8g,youtube_101428_UCbDRu9Div0_C6ZXvQc4_-gg,youtube_101428_UCCrXgAik4puBIzPB1O48dFA,twitter_101428_4327350677,instagram_101428_6977324703,twitter_10428_1671560886,youtube_101428_UCsD3GyoJxzGr1_DRZa93Qlw,150696651738343,325817471225019,youtube_101428_UCmRDr8pTzI4ax_7efGkKMxA,instagram_101428_2124366150,youtube_101428_UC5hvIpOrblUtn0GD5eewIFA,youtube_101428_UCfuN9GrSllq5GJBXMNe8D3g,11304054541372,youtube_101428_UC1BFRUlUTbNI8BcRuyzEzYg,youtube_101428_UCBI-ogjBiEumO7JdYig70Fw,youtube_101428_UCXs6YUQ_qmhmchbzL2YpACQ,instagram_101428_477429019,youtube_101428_UC2NoJxTcHcwspsjquLw9Wqw,230797369582,101654093505341,instagram_101428_316119180,203029819720261,twitter_101428_2444176508,instagram_101428_17841401360115413,twitter_101428_1306945568,linkedin_101428_10943471,youtube_101428_UCx_zipTqoqkRKPUEwxgU7Cw,137240856682254,linkedin_101428_354473,302162109826876,instagram_10142_17841403318901782,linkedin_101428_2973026,linkedin_101428_484989,youtube_101428_UC8o8WvGsJB-k56-NFgf76zw,108968472464808,twitter_101428_154317351,270760246277876,twitter_101428_266406710,instagram_101428_17841402244007480,youtube_101428_UCeItYFFgPrXaRrL_pFsemQ,twitter_101428_120860188,instagram_101428_17841401476244364,instagram_101428_17841404899399248,326392084137905,twitter_101428_270726905,twitter_101428_2510215220,instagram_101428_17841401643673717,instagram_101428_1784140042910765,169865066407184,twitter_101428_64310527,twitter_101428_550363554,instagram_101428_1564764785,instagram_101428_3262881250,instagram_101428_17841401079606276,instagram_101428_17841412692413734,213601155729878,youtube_101428_UCxqjuWga--j4srKTYfw2cA,119431368114185,98382332197,instagram_101428_3083640346,instagram_101428_6312822287,instagram_101428_17841400266242139,instagram_101428_510185780,linkedin_101428_253312,144233322294872,instagram_101428_17841404989938502,55313231186772,323521961007753,120418771304011,274879576155,instagram_101428_17841400308733095,twitter_101428_213989280,135686563182270,179435388852020,162718927219149,twitter_101428_716064169,twitter_101428_258085189,twitter_101428_3301540007,45597391106483,instagram_101428_17841400204325000,131040973594936,183095551814931,141741622549044,instagram_101428_1560197450,107063285999134,twitter_101428_73382470,twitter_101428_41357718,instagram_101428_17841411034786125,linkedin_101428_582124,118441848306394,354163943981,125295054164529,116973501711435,213578798776120,1567590116824705,423621277668397,instagram_101428_5360692717,linkedin_101428_391735,instagram_101428_2860565939,instagram_101428_17841402141265555,linkedin_10128_970270,106475286088699,308878909205138,253862057262,120751887966844,linkedin_101428_258764,135271909857940,128195630586736,302965153616,575650389288407,286838774747225,146373332096152,101023943313734,166627061784,twitter_101428_57444432,twitter_101428_93896343,twitter_101428_1454452975,268113030040415,youtube_101428_UCqskSYeJ78lBDa6UCsjtIMQ,instagram_101428_331063503,f12ceddcc3344e91acf7ddb1775c4012,ff057752ab5b409fbb1d4bd53584136c,twitter_101428_384750535,twitter_2720_2709143856,youtube_101428_UCruLj2Gof6qPEpRVuJwQ6g,203977802962086,3799672bb99545caaa9c812798853d36,plus_101428_102113148151914459613,543466079423037,plus_101428_110654567104035276870,youtube_101428_UCUZzk4CtfPHKvB_XEsG1mWg,plus_101428_113894790576409626650,youtube_101428_UCV6AeRlUh655OQSiF794lw,youtube_101428_UCGyRZSHJb_Lm0-i3kz1k38g,eaea54bab2664a129f05341434c45b76,youtube_101428_UCGXeXuaGgCJ3tiDb9Qaoh5Q,430457856994464,youtube_101428_UCJLk7f0XahfbbWpEBNRRkYQ,youtube_101428_UCiZ2iocKgFcWbqVmX5nIFg,instagram_101428_231592869,youtube_101428_UC8cfz0c_t-dv5NoPOr8TiGQ,169392416808399,youtube_101428_UCfPMbaHYuGQ_LQ0A1bJoGjw,youtube_101428_UCKsiLSu6EbqPtlWA1ngbnpA,125265894155793,tumblr_101428_toyoddity,instagram_101428_2953341913,instagram_01428_3035476359,instagram_101428_382338159,linkedin_101428_36319,2148409268753716,521246601620534,instagram_101428_1938956018,plus_101428_101118286389323713249,twitter_101428_864778735496593409,youtube_101428_UCbXMgZoVMFy7zgMjPwRoGgA,plus_10128_116369988986224957848,youtube_101428_UCQLvbIKfAFFewOMSFKPzNig,plus_101428_118417351732913711468,youtube_101428_UCgAh8iSarVGK9zU5V7UlTrA,youtube_101428_UC4DskZ7ft8IubOmsacUdY5A,2fb2dc85-ce8b-4c97-ade77f37acc49def,twitter_101428_719650350,twitter_101428_3330052408,youtube_101428_UCwTgzB2JVJjUOyd8D2AVmpA,twitter_101428_849493004,youtube_101428_UCQBMx6Za3P1h7YvGbYiX2hQ,youtube_101428_UCVVFxfkX3wRzfNT-wmpS78Q,instagram_101428_547568493,youtube_11428_UCEv16u061guYXA7AjdSfx6Q,linkedin_101428_10261111,tumblr_101428_toyotamotorsport,twitter_101428_864394739864526848,youtube_101428_UCIvwEoRfG5oxUXxcsReopVw,instagram_101428_17841410847589198,youtube_101428_UCSYQuEjBZsPA9YCefcaO21w,linkedin_10128_9996237,plus_101428_113339910343138619745,instagram_101428_2274823220,instagram_101428_2296523130,linkedin_101428_10117428,instagram_101428_3105423503,instagram_101428_17841401758414921,twitter_101428_22804069,plus_101428_10360517994128593344,twitter_101428_41126119,instagram_101428_1677351128,instagram_101428_3158275360,twitter_101428_135105301,linkedin_101428_3313287,linkedin_101428_2619251,youtube_101428_UCHaE6kocTycIbZE4bFenQ8g,twitter_101428_779285103277182976,instagram_10142_2934064559,583129878386334,1762014767240168,129505010790825,instagram_101428_8333547,249918695126825,115054468608217,180246608655750,128699503851268,298087080252800,twitter_101428_65598747,391795967559285,140450422724637,139104652783804,217662561586695,youtube_101428_UCPK0dZpX1untVQh8gFUkkeA,976352929152958,youtube_101428_UCJVVzh0kATH9n9x4QbBLhAQ,linkedin_101428_10861082,instagram_101428_2276014307,167554178643,1609925119226961,twitter_101428_2785061891,instagram_101428_476251898,youtube_101428_UCXULCUu_lK89zNMw2j7GfoQ,twitter_101428_227239765,123538507674613,instagram_101428_6821334940,instagram_101428_547582103,instagram_101428_528460391,twitter_101428_175122552,twitter_101428_758664529056178176,twitter_10128_533150309,linkedin_101428_848610,youtube_101428_UClY71fl9hZa3dIvrnYHfGjA,instagram_101428_3966785392,instagram_101428_2953331098,instagram_101428_514452173,instagram_101428_17841405950285961,instagram_101428_2664167201,instagram_101428_151458125,twitter_101428_1905223496,instagram_101428_17841400927895671,twitter_101428_2989517710,193882058154202,linkedin_101428_35450195,674307932664627,154286877976840,1542442245968069,instagram_101428_2070717041,instagram_101428_1784140338723242,instagram_101428_2644858495,517588405388597,674352842602964,instagram_101428_17841412501622682,twitter_101428_443663457,105518809505324,plus_101428_104369273543217688384,instagram_101428_457911289,instagram_101428_281241691,instagram_10142_17841407658826951,173533619429363,248954465174600,361944910866915,twitter_101428_1057760305,223666664438882,188186581192773,1856186184660461,instagram_101428_5930806628,443316539417434,instagram_101428_17841412409430795,201043293631197,72339499826857,245108635644456,instagram_101428_17841405958861350,1565690203710812,instagram_101428_17841402083692860,twitter_101428_741237227792044032,321807518632736,431611997174235,386925448027932,2325683497664553,linkedin_101428_2109,istagram_101428_17841402951049143,twitter_101428_1641775844,youtube_101428_UCzLk0KTS86oy2r8eTRYbbDw,269219549925670,plus_101428_108261334918782723005,158139660914197,linkedin_101428_9190463,twitter_101428_707864570728202240,plus_101428_10467170598552431634,instagram_101428_19250380,youtube_101428_UCRRtKQToUgONlW4FC2k7UHg,346945618654842,plus_101428_104648467976093885548,318147284889313,256505648048804,linkedin_101428_829960,twitter_101428_216389027,instagram_101428_17841401132323448,353210448121782,166408843371733,215937232323938,162344743818520,377291675798596,linkedin_101428_1002740,461569204019871,instagram_101428_17841400345728238,794974070573548,247938415252445,274880759207660,114869555254344,225042300865624,71075042980246,185179594854945,80323149329,100175607632,108330332551513,instagram_101428_17841404234984110}'::text[])))
  • Rows Removed by Index Recheck: 4919
  • Filter: ((NOT archived) AND (fmsstatus <> ALL ('{6,7}'::integer[])) AND ((type)::text = ANY ('{image,video,carousel}'::text[])) AND ((fromid)::text = ANY ('{17841401625745061,17841400513933281,17841402369456685,17841400215378948,17841401368600414,17841406726875830,17841400925800849,17841404603056122,17841400480364685,17841401884272849,17841401059762976,17841400647512194,17841400804932844,17841401334524684,17841408075044755,17841401173425797,17841401229613937,17841402364302021,17841402976434559,17841401202073015,17841400652605503,17841403300680401,17841400332960779,17841400568497727,17841403263317541,17841401348974117,17841407101092165,17841402104525545,17841401590577459,17841403332405148,17841401360115413,17841403318901782,17841402244007480,17841401476244364,17841404899399248,17841401643673717,17841400429120765,17841400863574449,17841403157517860,17841401079606276,17841412692413734,17841402890405455,17841406428619102,17841400266242139,17841401253407971,17841404989938502,17841400308733095,17841400204325000,17841400163524378,17841411034786125,17841405421520086,17841402818197570,17841402141265555,331063503,231592869,2953341913,3035476359,382338159,1938956018,547568493,17841410847589198,2274823220,2296523130,3105423503,17841401758414921,1677351128,3158275360,2934064559,8333547,2276014307,17841403476954531,6821334940,547582103,528460391,17841403881775848,17841402972949166,17841400605198038,17841405950285961,2664167201,1514586125,17841400927895671,17841402071248839,17841403387232492,2644858495,17841412501622682,457911289,281241691,17841407658826951,17841405958861350,17841412409430795,17841405958861350,17841402083692860,17841402951049143,19250380,17841401132323448,17841400345728238,17841404234984110}'::text[])) AND ((publicationid IS NULL) OR (NOT (SubPlan 1))))
  • Rows Removed by Filter: 12
  • Heap Blocks: exact=210 lossy=947
6. 4.705 40.855 ↓ 0.0 0 1

BitmapAnd (cost=5,294.95..5,294.95 rows=2,006 width=0) (actual time=40.855..40.855 rows=0 loops=1)

7. 28.997 28.997 ↓ 3.3 189,941 1

Bitmap Index Scan on instagrampost_createddate_idx (cost=0.00..1,367.15 rows=58,272 width=0) (actual time=28.997..28.997 rows=189,941 loops=1)

  • Index Cond: ((createddate >= '2019-05-01 00:00:00'::timestamp without time zone) AND (createddate <= '2019-06-01 00:00:00'::timestamp without time zone))
8. 7.153 7.153 ↑ 6.0 16,130 1

Bitmap Index Scan on instagrampost_sourceid_idx (cost=0.00..3,927.55 rows=95,989 width=0) (actual time=7.153..7.153 rows=16,130 loops=1)

  • Index Cond: ((sourceid)::text = ANY ('{instagram_101428_17841401625745061,instagram_101428_17841400513933281,instagram_101428_54366860,instagram_101428_572679179,youtube_101428_UCVAFAVDJrSU1qCHP321HVVA,instagram_101428_6766640229,instagram_101428_17841402369456685,youtube_101428_UCxVa4ZcWGi_VStlkfmoteQ,instagram_101428_4608977435,twitter_101428_19763619,instagram_101428_17841401368600414,instagram_101428_17841400480364685,instagram_101428_182398809,youtube_101428_UCHQ6Rz7caWv2PCr6L9yVhHg,instagram_101428_17841401059762976,yotube_101428_UCAnWjBV2o6t5ATS_FgCqtlg,instagram_101428_17841400647512194,instagram_101428_182042831,youtube_101428_UCSEJEBvznNGTS8n21fB37fA,instagram_101428_17841401334524684,twitter_101428_207938014,twitter_101428_19226153,instagram_101428_1784140075044755,youtube_101428_UCbSJ0rahph9f8pOwih-k9RA,instagram_101428_17841401173425797,164344830303453,instagram_101428_17841401229613937,twitter_101428_1184765671,instagram_101428_17841402364302021,youtube_101428_UCj8vLYLtXOJ1y3t48pfxtZQ,linkedin101428_3823681,1654816274778494,instagram_101428_17841402976434559,twitter_101428_163539975,instagram_101428_17841401202073015,234551906637540,199262693510628,116919588378323,twitter_101428_137544133,instagram_101428_17841400652605503,instagam_101428_17841403300680401,youtube_101428_UCqxM1SVVcJh2xHeeegoJlA,youtube_101428_UCOliHkYnUVDRCU7DYDzH5tg,245745028798233,youtube_101428_UCVqdDRIjrr8v0ykaCMR5IyQ,linkedin_101428_10113587,twitter_101428_1603385773,youtube_101428_UCj4tEdLmxjWXemSLOLu4XLg,youtube_101428_UCB7coJSXQaDESKcpBUTR8g,twitter_101428_747238206198820866,youtube_101428_UC9O_4b4XNxhHN9vAa-duZ9Q,twitter_101428_16220541,instagram_101428_17841400332960779,twitter_101428_20687324,twitter_101428_16254749,youtube_101428_UCeguwe9wysMX9zo_05PMx_A,11516515204000,instagram_101428_17841400568497727,youtube_101428_UC9XZPfTheB2xRE0rgYCB__Q,twitter_101428_371643021,youtube_101428_UCutsOmLamc8i3AvWo0VxJag,instagram_101428_3180332777,303818232963593,twitter_101428_72887574,youtube_101428_UCbdZjWzvTFLJsZBcqkgCpA,219651984778,instagram_101428_17841401348974117,youtube_101428_UCsAGbvOnLc4ItBWb4NYcK8g,youtube_101428_UCbDRu9Div0_C6ZXvQc4_-gg,youtube_101428_UCCrXgAik4puBIzPB1O48dFA,twitter_101428_4327350677,instagram_101428_6977324703,twitter_10428_1671560886,youtube_101428_UCsD3GyoJxzGr1_DRZa93Qlw,150696651738343,325817471225019,youtube_101428_UCmRDr8pTzI4ax_7efGkKMxA,instagram_101428_2124366150,youtube_101428_UC5hvIpOrblUtn0GD5eewIFA,youtube_101428_UCfuN9GrSllq5GJBXMNe8D3g,11304054541372,youtube_101428_UC1BFRUlUTbNI8BcRuyzEzYg,youtube_101428_UCBI-ogjBiEumO7JdYig70Fw,youtube_101428_UCXs6YUQ_qmhmchbzL2YpACQ,instagram_101428_477429019,youtube_101428_UC2NoJxTcHcwspsjquLw9Wqw,230797369582,101654093505341,instagram_101428_316119180,203029819720261,twitter_101428_2444176508,instagram_101428_17841401360115413,twitter_101428_1306945568,linkedin_101428_10943471,youtube_101428_UCx_zipTqoqkRKPUEwxgU7Cw,137240856682254,linkedin_101428_354473,302162109826876,instagram_10142_17841403318901782,linkedin_101428_2973026,linkedin_101428_484989,youtube_101428_UC8o8WvGsJB-k56-NFgf76zw,108968472464808,twitter_101428_154317351,270760246277876,twitter_101428_266406710,instagram_101428_17841402244007480,youtube_101428_UCeItYFFgPrXaRrL_pFsemQ,twitter_101428_120860188,instagram_101428_17841401476244364,instagram_101428_17841404899399248,326392084137905,twitter_101428_270726905,twitter_101428_2510215220,instagram_101428_17841401643673717,instagram_101428_1784140042910765,169865066407184,twitter_101428_64310527,twitter_101428_550363554,instagram_101428_1564764785,instagram_101428_3262881250,instagram_101428_17841401079606276,instagram_101428_17841412692413734,213601155729878,youtube_101428_UCxqjuWga--j4srKTYfw2cA,119431368114185,98382332197,instagram_101428_3083640346,instagram_101428_6312822287,instagram_101428_17841400266242139,instagram_101428_510185780,linkedin_101428_253312,144233322294872,instagram_101428_17841404989938502,55313231186772,323521961007753,120418771304011,274879576155,instagram_101428_17841400308733095,twitter_101428_213989280,135686563182270,179435388852020,162718927219149,twitter_101428_716064169,twitter_101428_258085189,twitter_101428_3301540007,45597391106483,instagram_101428_17841400204325000,131040973594936,183095551814931,141741622549044,instagram_101428_1560197450,107063285999134,twitter_101428_73382470,twitter_101428_41357718,instagram_101428_17841411034786125,linkedin_101428_582124,118441848306394,354163943981,125295054164529,116973501711435,213578798776120,1567590116824705,423621277668397,instagram_101428_5360692717,linkedin_101428_391735,instagram_101428_2860565939,instagram_101428_17841402141265555,linkedin_10128_970270,106475286088699,308878909205138,253862057262,120751887966844,linkedin_101428_258764,135271909857940,128195630586736,302965153616,575650389288407,286838774747225,146373332096152,101023943313734,166627061784,twitter_101428_57444432,twitter_101428_93896343,twitter_101428_1454452975,268113030040415,youtube_101428_UCqskSYeJ78lBDa6UCsjtIMQ,instagram_101428_331063503,f12ceddcc3344e91acf7ddb1775c4012,ff057752ab5b409fbb1d4bd53584136c,twitter_101428_384750535,twitter_2720_2709143856,youtube_101428_UCruLj2Gof6qPEpRVuJwQ6g,203977802962086,3799672bb99545caaa9c812798853d36,plus_101428_102113148151914459613,543466079423037,plus_101428_110654567104035276870,youtube_101428_UCUZzk4CtfPHKvB_XEsG1mWg,plus_101428_113894790576409626650,youtube_101428_UCV6AeRlUh655OQSiF794lw,youtube_101428_UCGyRZSHJb_Lm0-i3kz1k38g,eaea54bab2664a129f05341434c45b76,youtube_101428_UCGXeXuaGgCJ3tiDb9Qaoh5Q,430457856994464,youtube_101428_UCJLk7f0XahfbbWpEBNRRkYQ,youtube_101428_UCiZ2iocKgFcWbqVmX5nIFg,instagram_101428_231592869,youtube_101428_UC8cfz0c_t-dv5NoPOr8TiGQ,169392416808399,youtube_101428_UCfPMbaHYuGQ_LQ0A1bJoGjw,youtube_101428_UCKsiLSu6EbqPtlWA1ngbnpA,125265894155793,tumblr_101428_toyoddity,instagram_101428_2953341913,instagram_01428_3035476359,instagram_101428_382338159,linkedin_101428_36319,2148409268753716,521246601620534,instagram_101428_1938956018,plus_101428_101118286389323713249,twitter_101428_864778735496593409,youtube_101428_UCbXMgZoVMFy7zgMjPwRoGgA,plus_10128_116369988986224957848,youtube_101428_UCQLvbIKfAFFewOMSFKPzNig,plus_101428_118417351732913711468,youtube_101428_UCgAh8iSarVGK9zU5V7UlTrA,youtube_101428_UC4DskZ7ft8IubOmsacUdY5A,2fb2dc85-ce8b-4c97-ade77f37acc49def,twitter_101428_719650350,twitter_101428_3330052408,youtube_101428_UCwTgzB2JVJjUOyd8D2AVmpA,twitter_101428_849493004,youtube_101428_UCQBMx6Za3P1h7YvGbYiX2hQ,youtube_101428_UCVVFxfkX3wRzfNT-wmpS78Q,instagram_101428_547568493,youtube_11428_UCEv16u061guYXA7AjdSfx6Q,linkedin_101428_10261111,tumblr_101428_toyotamotorsport,twitter_101428_864394739864526848,youtube_101428_UCIvwEoRfG5oxUXxcsReopVw,instagram_101428_17841410847589198,youtube_101428_UCSYQuEjBZsPA9YCefcaO21w,linkedin_10128_9996237,plus_101428_113339910343138619745,instagram_101428_2274823220,instagram_101428_2296523130,linkedin_101428_10117428,instagram_101428_3105423503,instagram_101428_17841401758414921,twitter_101428_22804069,plus_101428_10360517994128593344,twitter_101428_41126119,instagram_101428_1677351128,instagram_101428_3158275360,twitter_101428_135105301,linkedin_101428_3313287,linkedin_101428_2619251,youtube_101428_UCHaE6kocTycIbZE4bFenQ8g,twitter_101428_779285103277182976,instagram_10142_2934064559,583129878386334,1762014767240168,129505010790825,instagram_101428_8333547,249918695126825,115054468608217,180246608655750,128699503851268,298087080252800,twitter_101428_65598747,391795967559285,140450422724637,139104652783804,217662561586695,youtube_101428_UCPK0dZpX1untVQh8gFUkkeA,976352929152958,youtube_101428_UCJVVzh0kATH9n9x4QbBLhAQ,linkedin_101428_10861082,instagram_101428_2276014307,167554178643,1609925119226961,twitter_101428_2785061891,instagram_101428_476251898,youtube_101428_UCXULCUu_lK89zNMw2j7GfoQ,twitter_101428_227239765,123538507674613,instagram_101428_6821334940,instagram_101428_547582103,instagram_101428_528460391,twitter_101428_175122552,twitter_101428_758664529056178176,twitter_10128_533150309,linkedin_101428_848610,youtube_101428_UClY71fl9hZa3dIvrnYHfGjA,instagram_101428_3966785392,instagram_101428_2953331098,instagram_101428_514452173,instagram_101428_17841405950285961,instagram_101428_2664167201,instagram_101428_151458125,twitter_101428_1905223496,instagram_101428_17841400927895671,twitter_101428_2989517710,193882058154202,linkedin_101428_35450195,674307932664627,154286877976840,1542442245968069,instagram_101428_2070717041,instagram_101428_1784140338723242,instagram_101428_2644858495,517588405388597,674352842602964,instagram_101428_17841412501622682,twitter_101428_443663457,105518809505324,plus_101428_104369273543217688384,instagram_101428_457911289,instagram_101428_281241691,instagram_10142_17841407658826951,173533619429363,248954465174600,361944910866915,twitter_101428_1057760305,223666664438882,188186581192773,1856186184660461,instagram_101428_5930806628,443316539417434,instagram_101428_17841412409430795,201043293631197,72339499826857,245108635644456,instagram_101428_17841405958861350,1565690203710812,instagram_101428_17841402083692860,twitter_101428_741237227792044032,321807518632736,431611997174235,386925448027932,2325683497664553,linkedin_101428_2109,istagram_101428_17841402951049143,twitter_101428_1641775844,youtube_101428_UCzLk0KTS86oy2r8eTRYbbDw,269219549925670,plus_101428_108261334918782723005,158139660914197,linkedin_101428_9190463,twitter_101428_707864570728202240,plus_101428_10467170598552431634,instagram_101428_19250380,youtube_101428_UCRRtKQToUgONlW4FC2k7UHg,346945618654842,plus_101428_104648467976093885548,318147284889313,256505648048804,linkedin_101428_829960,twitter_101428_216389027,instagram_101428_17841401132323448,353210448121782,166408843371733,215937232323938,162344743818520,377291675798596,linkedin_101428_1002740,461569204019871,instagram_101428_17841400345728238,794974070573548,247938415252445,274880759207660,114869555254344,225042300865624,71075042980246,185179594854945,80323149329,100175607632,108330332551513,instagram_101428_17841404234984110}'::text[]))
9.          

SubPlan (forBitmap Heap Scan)

10. 1.920 1.920 ↓ 0.0 0 120

Index Only Scan using contentpoolclone_cloneid_idx on contentpoolclone cpc (cost=0.55..8.57 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=120)

  • Index Cond: (clone_id = (c.publicationid)::text)
  • Heap Fetches: 12
11. 7.128 7.128 ↑ 1.0 1 396

Index Scan using source_pkey on source s (cost=0.42..8.44 rows=1 width=26) (actual time=0.018..0.018 rows=1 loops=396)

  • Index Cond: ((id)::text = (c.sourceid)::text)
  • Filter: (organization = 101428)
12. 843.876 176,221.584 ↓ 4.7 6,654 396

Finalize GroupAggregate (cost=346,822.12..346,996.36 rows=1,406 width=111) (actual time=438.190..445.004 rows=6,654 loops=396)

  • Group Key: cp.pub_id, cp.content_uuid, p.id
13. 0.000 175,377.708 ↓ 5.7 6,654 396

Gather Merge (cost=346,822.12..346,970.58 rows=1,172 width=111) (actual time=438.184..442.873 rows=6,654 loops=396)

  • Workers Planned: 2
  • Workers Launched: 2
14. 892.206 369,659.444 ↓ 4.4 2,578 1,022

Partial GroupAggregate (cost=345,822.09..345,835.28 rows=586 width=111) (actual time=360.610..361.702 rows=2,578 loops=1,022)

  • Group Key: cp.pub_id, cp.content_uuid, p.id
15. 5,927.600 368,767.238 ↓ 4.4 2,589 1,022

Sort (cost=345,822.09..345,823.56 rows=586 width=136) (actual time=360.602..360.829 rows=2,589 loops=1,022)

  • Sort Key: cp.pub_id, cp.content_uuid, p.id
  • Sort Method: quicksort Memory: 401kB
  • Worker 0: Sort Method: quicksort Memory: 393kB
  • Worker 1: Sort Method: quicksort Memory: 435kB
16. 2,337.528 362,839.638 ↓ 4.4 2,589 1,022

Nested Loop (cost=164,167.95..345,795.15 rows=586 width=136) (actual time=58.655..355.029 rows=2,589 loops=1,022)

17. 174,654.690 316,641.150 ↑ 1.6 3,301 1,022

Parallel Hash Join (cost=164,167.39..208,232.04 rows=5,348 width=136) (actual time=58.595..309.825 rows=3,301 loops=1,022)

  • Hash Cond: ((cp.clone_id)::text = (p.id)::text)
18. 82,378.310 82,378.310 ↑ 1.1 768,496 1,022

Parallel Seq Scan on contentpoolclone cp (cost=0.00..41,871.37 rows=835,537 width=99) (actual time=0.005..80.605 rows=768,496 loops=1,022)

19. 6,845.356 59,608.150 ↑ 1.1 20,287 1,022

Parallel Hash (cost=163,898.15..163,898.15 rows=21,539 width=37) (actual time=58.325..58.325 rows=20,287 loops=1,022)

  • Buckets: 65536 Batches: 1 Memory Usage: 4256kB
20. 49,863.282 52,762.794 ↑ 1.1 20,287 1,022

Parallel Bitmap Heap Scan on publication p (cost=981.06..163,898.15 rows=21,539 width=37) (actual time=13.926..51.627 rows=20,287 loops=1,022)

  • Recheck Cond: (orgid = 101428)
  • Heap Blocks: exact=9659360
21. 2,899.512 2,899.512 ↓ 1.0 53,163 396

Bitmap Index Scan on idx_orgid (cost=0.00..968.14 rows=51,694 width=0) (actual time=7.322..7.322 rows=53,163 loops=396)

  • Index Cond: (orgid = 101428)
22. 43,860.960 43,860.960 ↑ 1.0 1 3,373,920

Index Scan using publicationsources_publicationid_idx on publicationsources cpps (cost=0.56..25.71 rows=1 width=33) (actual time=0.013..0.013 rows=1 loops=3,373,920)

  • Index Cond: ((publicationid)::text = (cp.clone_id)::text)
  • Filter: ((sourceid)::text = ANY ('{instagram_101428_17841401625745061,instagram_101428_17841400513933281,instagram_101428_54366860,instagram_101428_572679179,youtube_101428_UCVAFAVDJrSU1qCHP321HVVA,instagram_101428_6766640229,instagram_101428_17841402369456685,youtube_101428_UCxVa4ZcWGi_VStlkfmoteQ,instagram_101428_4608977435,twitter_101428_19763619,instagram_101428_17841401368600414,instagram_101428_17841400480364685,instagram_101428_182398809,youtube_101428_UCHQ6Rz7caWv2PCr6L9yVhHg,instagram_101428_17841401059762976,yotube_101428_UCAnWjBV2o6t5ATS_FgCqtlg,instagram_101428_17841400647512194,instagram_101428_182042831,youtube_101428_UCSEJEBvznNGTS8n21fB37fA,instagram_101428_17841401334524684,twitter_101428_207938014,twitter_101428_19226153,instagram_101428_1784140075044755,youtube_101428_UCbSJ0rahph9f8pOwih-k9RA,instagram_101428_17841401173425797,164344830303453,instagram_101428_17841401229613937,twitter_101428_1184765671,instagram_101428_17841402364302021,youtube_101428_UCj8vLYLtXOJ1y3t48pfxtZQ,linkedin101428_3823681,1654816274778494,instagram_101428_17841402976434559,twitter_101428_163539975,instagram_101428_17841401202073015,234551906637540,199262693510628,116919588378323,twitter_101428_137544133,instagram_101428_17841400652605503,instagam_101428_17841403300680401,youtube_101428_UCqxM1SVVcJh2xHeeegoJlA,youtube_101428_UCOliHkYnUVDRCU7DYDzH5tg,245745028798233,youtube_101428_UCVqdDRIjrr8v0ykaCMR5IyQ,linkedin_101428_10113587,twitter_101428_1603385773,youtube_101428_UCj4tEdLmxjWXemSLOLu4XLg,youtube_101428_UCB7coJSXQaDESKcpBUTR8g,twitter_101428_747238206198820866,youtube_101428_UC9O_4b4XNxhHN9vAa-duZ9Q,twitter_101428_16220541,instagram_101428_17841400332960779,twitter_101428_20687324,twitter_101428_16254749,youtube_101428_UCeguwe9wysMX9zo_05PMx_A,11516515204000,instagram_101428_17841400568497727,youtube_101428_UC9XZPfTheB2xRE0rgYCB__Q,twitter_101428_371643021,youtube_101428_UCutsOmLamc8i3AvWo0VxJag,instagram_101428_3180332777,303818232963593,twitter_101428_72887574,youtube_101428_UCbdZjWzvTFLJsZBcqkgCpA,219651984778,instagram_101428_17841401348974117,youtube_101428_UCsAGbvOnLc4ItBWb4NYcK8g,youtube_101428_UCbDRu9Div0_C6ZXvQc4_-gg,youtube_101428_UCCrXgAik4puBIzPB1O48dFA,twitter_101428_4327350677,instagram_101428_6977324703,twitter_10428_1671560886,youtube_101428_UCsD3GyoJxzGr1_DRZa93Qlw,150696651738343,325817471225019,youtube_101428_UCmRDr8pTzI4ax_7efGkKMxA,instagram_101428_2124366150,youtube_101428_UC5hvIpOrblUtn0GD5eewIFA,youtube_101428_UCfuN9GrSllq5GJBXMNe8D3g,11304054541372,youtube_101428_UC1BFRUlUTbNI8BcRuyzEzYg,youtube_101428_UCBI-ogjBiEumO7JdYig70Fw,youtube_101428_UCXs6YUQ_qmhmchbzL2YpACQ,instagram_101428_477429019,youtube_101428_UC2NoJxTcHcwspsjquLw9Wqw,230797369582,101654093505341,instagram_101428_316119180,203029819720261,twitter_101428_2444176508,instagram_101428_17841401360115413,twitter_101428_1306945568,linkedin_101428_10943471,youtube_101428_UCx_zipTqoqkRKPUEwxgU7Cw,137240856682254,linkedin_101428_354473,302162109826876,instagram_10142_17841403318901782,linkedin_101428_2973026,linkedin_101428_484989,youtube_101428_UC8o8WvGsJB-k56-NFgf76zw,108968472464808,twitter_101428_154317351,270760246277876,twitter_101428_266406710,instagram_101428_17841402244007480,youtube_101428_UCeItYFFgPrXaRrL_pFsemQ,twitter_101428_120860188,instagram_101428_17841401476244364,instagram_101428_17841404899399248,326392084137905,twitter_101428_270726905,twitter_101428_2510215220,instagram_101428_17841401643673717,instagram_101428_1784140042910765,169865066407184,twitter_101428_64310527,twitter_101428_550363554,instagram_101428_1564764785,instagram_101428_3262881250,instagram_101428_17841401079606276,instagram_101428_17841412692413734,213601155729878,youtube_101428_UCxqjuWga--j4srKTYfw2cA,119431368114185,98382332197,instagram_101428_3083640346,instagram_101428_6312822287,instagram_101428_17841400266242139,instagram_101428_510185780,linkedin_101428_253312,144233322294872,instagram_101428_17841404989938502,55313231186772,323521961007753,120418771304011,274879576155,instagram_101428_17841400308733095,twitter_101428_213989280,135686563182270,179435388852020,162718927219149,twitter_101428_716064169,twitter_101428_258085189,twitter_101428_3301540007,45597391106483,instagram_101428_17841400204325000,131040973594936,183095551814931,141741622549044,instagram_101428_1560197450,107063285999134,twitter_101428_73382470,twitter_101428_41357718,instagram_101428_17841411034786125,linkedin_101428_582124,118441848306394,354163943981,125295054164529,116973501711435,213578798776120,1567590116824705,423621277668397,instagram_101428_5360692717,linkedin_101428_391735,instagram_101428_2860565939,instagram_101428_17841402141265555,linkedin_10128_970270,106475286088699,308878909205138,253862057262,120751887966844,linkedin_101428_258764,135271909857940,128195630586736,302965153616,575650389288407,286838774747225,146373332096152,101023943313734,166627061784,twitter_101428_57444432,twitter_101428_93896343,twitter_101428_1454452975,268113030040415,youtube_101428_UCqskSYeJ78lBDa6UCsjtIMQ,instagram_101428_331063503,f12ceddcc3344e91acf7ddb1775c4012,ff057752ab5b409fbb1d4bd53584136c,twitter_101428_384750535,twitter_2720_2709143856,youtube_101428_UCruLj2Gof6qPEpRVuJwQ6g,203977802962086,3799672bb99545caaa9c812798853d36,plus_101428_102113148151914459613,543466079423037,plus_101428_110654567104035276870,youtube_101428_UCUZzk4CtfPHKvB_XEsG1mWg,plus_101428_113894790576409626650,youtube_101428_UCV6AeRlUh655OQSiF794lw,youtube_101428_UCGyRZSHJb_Lm0-i3kz1k38g,eaea54bab2664a129f05341434c45b76,youtube_101428_UCGXeXuaGgCJ3tiDb9Qaoh5Q,430457856994464,youtube_101428_UCJLk7f0XahfbbWpEBNRRkYQ,youtube_101428_UCiZ2iocKgFcWbqVmX5nIFg,instagram_101428_231592869,youtube_101428_UC8cfz0c_t-dv5NoPOr8TiGQ,169392416808399,youtube_101428_UCfPMbaHYuGQ_LQ0A1bJoGjw,youtube_101428_UCKsiLSu6EbqPtlWA1ngbnpA,125265894155793,tumblr_101428_toyoddity,instagram_101428_2953341913,instagram_01428_3035476359,instagram_101428_382338159,linkedin_101428_36319,2148409268753716,521246601620534,instagram_101428_1938956018,plus_101428_101118286389323713249,twitter_101428_864778735496593409,youtube_101428_UCbXMgZoVMFy7zgMjPwRoGgA,plus_10128_116369988986224957848,youtube_101428_UCQLvbIKfAFFewOMSFKPzNig,plus_101428_118417351732913711468,youtube_101428_UCgAh8iSarVGK9zU5V7UlTrA,youtube_101428_UC4DskZ7ft8IubOmsacUdY5A,2fb2dc85-ce8b-4c97-ade77f37acc49def,twitter_101428_719650350,twitter_101428_3330052408,youtube_101428_UCwTgzB2JVJjUOyd8D2AVmpA,twitter_101428_849493004,youtube_101428_UCQBMx6Za3P1h7YvGbYiX2hQ,youtube_101428_UCVVFxfkX3wRzfNT-wmpS78Q,instagram_101428_547568493,youtube_11428_UCEv16u061guYXA7AjdSfx6Q,linkedin_101428_10261111,tumblr_101428_toyotamotorsport,twitter_101428_864394739864526848,youtube_101428_UCIvwEoRfG5oxUXxcsReopVw,instagram_101428_17841410847589198,youtube_101428_UCSYQuEjBZsPA9YCefcaO21w,linkedin_10128_9996237,plus_101428_113339910343138619745,instagram_101428_2274823220,instagram_101428_2296523130,linkedin_101428_10117428,instagram_101428_3105423503,instagram_101428_17841401758414921,twitter_101428_22804069,plus_101428_10360517994128593344,twitter_101428_41126119,instagram_101428_1677351128,instagram_101428_3158275360,twitter_101428_135105301,linkedin_101428_3313287,linkedin_101428_2619251,youtube_101428_UCHaE6kocTycIbZE4bFenQ8g,twitter_101428_779285103277182976,instagram_10142_2934064559,583129878386334,1762014767240168,129505010790825,instagram_101428_8333547,249918695126825,115054468608217,180246608655750,128699503851268,298087080252800,twitter_101428_65598747,391795967559285,140450422724637,139104652783804,217662561586695,youtube_101428_UCPK0dZpX1untVQh8gFUkkeA,976352929152958,youtube_101428_UCJVVzh0kATH9n9x4QbBLhAQ,linkedin_101428_10861082,instagram_101428_2276014307,167554178643,1609925119226961,twitter_101428_2785061891,instagram_101428_476251898,youtube_101428_UCXULCUu_lK89zNMw2j7GfoQ,twitter_101428_227239765,123538507674613,instagram_101428_6821334940,instagram_101428_547582103,instagram_101428_528460391,twitter_101428_175122552,twitter_101428_758664529056178176,twitter_10128_533150309,linkedin_101428_848610,youtube_101428_UClY71fl9hZa3dIvrnYHfGjA,instagram_101428_3966785392,instagram_101428_2953331098,instagram_101428_514452173,instagram_101428_17841405950285961,instagram_101428_2664167201,instagram_101428_151458125,twitter_101428_1905223496,instagram_101428_17841400927895671,twitter_101428_2989517710,193882058154202,linkedin_101428_35450195,674307932664627,154286877976840,1542442245968069,instagram_101428_2070717041,instagram_101428_1784140338723242,instagram_101428_2644858495,517588405388597,674352842602964,instagram_101428_17841412501622682,twitter_101428_443663457,105518809505324,plus_101428_104369273543217688384,instagram_101428_457911289,instagram_101428_281241691,instagram_10142_17841407658826951,173533619429363,248954465174600,361944910866915,twitter_101428_1057760305,223666664438882,188186581192773,1856186184660461,instagram_101428_5930806628,443316539417434,instagram_101428_17841412409430795,201043293631197,72339499826857,245108635644456,instagram_101428_17841405958861350,1565690203710812,instagram_101428_17841402083692860,twitter_101428_741237227792044032,321807518632736,431611997174235,386925448027932,2325683497664553,linkedin_101428_2109,istagram_101428_17841402951049143,twitter_101428_1641775844,youtube_101428_UCzLk0KTS86oy2r8eTRYbbDw,269219549925670,plus_101428_108261334918782723005,158139660914197,linkedin_101428_9190463,twitter_101428_707864570728202240,plus_101428_10467170598552431634,instagram_101428_19250380,youtube_101428_UCRRtKQToUgONlW4FC2k7UHg,346945618654842,plus_101428_104648467976093885548,318147284889313,256505648048804,linkedin_101428_829960,twitter_101428_216389027,instagram_101428_17841401132323448,353210448121782,166408843371733,215937232323938,162344743818520,377291675798596,linkedin_101428_1002740,461569204019871,instagram_101428_17841400345728238,794974070573548,247938415252445,274880759207660,114869555254344,225042300865624,71075042980246,185179594854945,80323149329,100175607632,108330332551513,instagram_101428_17841404234984110}'::text[]))
  • Rows Removed by Filter: 0