explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WW1g0

Settings
# exclusive inclusive rows x rows loops node
1. 0.129 144,976.787 ↓ 400.0 400 1

GroupAggregate (cost=378,687.72..378,687.75 rows=1 width=127) (actual time=144,976.646..144,976.787 rows=400 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.008 144,976.658 ↓ 401.0 401 1

Sort (cost=378,687.72..378,687.72 rows=1 width=63) (actual time=144,976.638..144,976.658 rows=401 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: 81kB
3. 173.963 144,975.650 ↓ 401.0 401 1

Nested Loop Left Join (cost=352,338.80..378,687.71 rows=1 width=63) (actual time=875.676..144,975.650 rows=401 loops=1)

  • Join Filter: ((c.uuid)::text = (cp.content_uuid)::text)
  • Rows Removed by Join Filter: 2661593
4. 1.603 66.487 ↓ 400.0 400 1

Nested Loop (cost=5,295.37..31,438.39 rows=1 width=59) (actual time=43.926..66.487 rows=400 loops=1)

5. 12.803 57.684 ↓ 30.8 400 1

Bitmap Heap Scan on instagrampost c (cost=5,294.95..31,328.63 rows=13 width=85) (actual time=43.905..57.684 rows=400 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: 4837
  • 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=192 lossy=939
6. 3.419 43.173 ↓ 0.0 0 1

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

7. 32.317 32.317 ↓ 3.5 203,925 1

Bitmap Index Scan on instagrampost_createddate_idx (cost=0.00..1,367.15 rows=58,272 width=0) (actual time=32.316..32.317 rows=203,925 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.437 7.437 ↑ 6.0 16,116 1

Bitmap Index Scan on instagrampost_sourceid_idx (cost=0.00..3,927.55 rows=95,989 width=0) (actual time=7.437..7.437 rows=16,116 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.708 1.708 ↓ 0.0 0 122

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

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

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=400)

  • Index Cond: ((id)::text = (c.sourceid)::text)
  • Filter: (organization = 101428)
12. 818.000 144,735.200 ↓ 4.7 6,654 400

Finalize GroupAggregate (cost=347,043.42..347,217.67 rows=1,406 width=111) (actual time=355.271..361.838 rows=6,654 loops=400)

  • Group Key: cp.pub_id, cp.content_uuid, p.id
13. 0.000 143,917.200 ↓ 5.7 6,654 400

Gather Merge (cost=347,043.42..347,191.89 rows=1,172 width=111) (actual time=355.266..359.793 rows=6,654 loops=400)

  • Workers Planned: 2
  • Workers Launched: 2
14. 860.916 361,069.500 ↓ 4.1 2,402 1,108

Partial GroupAggregate (cost=346,043.40..346,056.58 rows=586 width=111) (actual time=324.914..325.875 rows=2,402 loops=1,108)

  • Group Key: cp.pub_id, cp.content_uuid, p.id
15. 5,584.320 360,208.584 ↓ 4.1 2,412 1,108

Sort (cost=346,043.40..346,044.86 rows=586 width=136) (actual time=324.907..325.098 rows=2,412 loops=1,108)

  • Sort Key: cp.pub_id, cp.content_uuid, p.id
  • Sort Method: quicksort Memory: 422kB
  • Worker 0: Sort Method: quicksort Memory: 388kB
  • Worker 1: Sort Method: quicksort Memory: 419kB
16. 1,095.192 354,624.264 ↓ 4.1 2,412 1,108

Nested Loop (cost=164,318.58..346,016.46 rows=586 width=136) (actual time=55.440..320.058 rows=2,412 loops=1,108)

17. 167,822.112 309,225.072 ↑ 1.7 3,076 1,108

Parallel Hash Join (cost=164,318.02..208,402.40 rows=5,350 width=136) (actual time=55.381..279.084 rows=3,076 loops=1,108)

  • Hash Cond: ((cp.clone_id)::text = (p.id)::text)
18. 80,313.380 80,313.380 ↑ 1.2 716,068 1,108

Parallel Seq Scan on contentpoolclone cp (cost=0.00..41,890.11 rows=835,911 width=99) (actual time=0.005..72.485 rows=716,068 loops=1,108)

19. 6,809.768 61,089.580 ↑ 1.1 18,901 1,108

Parallel Hash (cost=164,048.54..164,048.54 rows=21,559 width=37) (actual time=55.134..55.135 rows=18,901 loops=1,108)

  • Buckets: 65536 Batches: 1 Memory Usage: 4256kB
20. 51,405.412 54,279.812 ↑ 1.1 18,901 1,108

Parallel Bitmap Heap Scan on publication p (cost=981.43..164,048.54 rows=21,559 width=37) (actual time=13.636..48.989 rows=18,901 loops=1,108)

  • Recheck Cond: (orgid = 101428)
  • Heap Blocks: exact=8120247
21. 2,874.400 2,874.400 ↓ 1.0 53,170 400

Bitmap Index Scan on idx_orgid (cost=0.00..968.50 rows=51,742 width=0) (actual time=7.186..7.186 rows=53,170 loops=400)

  • Index Cond: (orgid = 101428)
22. 44,304.000 44,304.000 ↑ 1.0 1 3,408,000

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,408,000)

  • 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