explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rjsU

Settings
# exclusive inclusive rows x rows loops node
1. 45.901 12,475.856 ↓ 25.8 20,000 1

Sort (cost=1,994,413.29..1,994,415.23 rows=774 width=424) (actual time=12,467.322..12,475.856 rows=20,000 loops=1)

  • Output: b.id, b.d1, b.d2, b.d3, (COALESCE((concat('[', string_agg((companies_x_rounds.entity1_id)::text, ','::text ORDER BY companies_x_rounds.entity1_id), ']')), '[]'::text)), b.d4, b.d21, b.d22, b.d23, b.d24, b.d25, b.d26, b.d27, b.d28, b.d4
  • Sort Key: b.d4 DESC NULLS LAST, b.id
  • Sort Method: external merge Disk: 4,000kB
  • Buffers: shared hit=5,614,811, temp read=26,340 written=26,800
2.          

CTE b

3. 8.082 6,692.673 ↓ 25.8 20,000 1

Limit (cost=1,500,160.08..1,500,162.02 rows=774 width=203) (actual time=6,676.517..6,692.673 rows=20,000 loops=1)

  • Output: a1.id, a4.id, a1.name, (('http://www.'::text || a1.url)), (COALESCE(a3.bb_stock_ticker_last, a4.symbol)), ((SubPlan 1)), a1.top_level_industry, a1.sub_level_industry, a1.hq_city, a1.hq_state, a1.hq_country, a1.hq_address, a1.hq_phone, a1.id
  • Buffers: shared hit=5,560,820, temp read=1,602 written=1,610
4. 57.164 6,684.591 ↓ 25.8 20,000 1

Sort (cost=1,500,160.08..1,500,162.02 rows=774 width=203) (actual time=6,676.515..6,684.591 rows=20,000 loops=1)

  • Output: a1.id, a4.id, a1.name, (('http://www.'::text || a1.url)), (COALESCE(a3.bb_stock_ticker_last, a4.symbol)), ((SubPlan 1)), a1.top_level_industry, a1.sub_level_industry, a1.hq_city, a1.hq_state, a1.hq_country, a1.hq_address, a1.hq_phone, a1.id
  • Sort Key: ((SubPlan 1)) DESC NULLS LAST, a1.id
  • Sort Method: external merge Disk: 3,592kB
  • Buffers: shared hit=5,560,820, temp read=1,602 written=1,610
5. 73.910 6,627.427 ↓ 25.8 20,000 1

Nested Loop Left Join (cost=1,059,061.31..1,500,122.95 rows=774 width=203) (actual time=1,490.702..6,627.427 rows=20,000 loops=1)

  • Output: a1.id, a4.id, a1.name, ('http://www.'::text || a1.url), COALESCE(a3.bb_stock_ticker_last, a4.symbol), (SubPlan 1), a1.top_level_industry, a1.sub_level_industry, a1.hq_city, a1.hq_state, a1.hq_country, a1.hq_address, a1.hq_phone, a1.id
  • Inner Unique: true
  • Buffers: shared hit=5,560,820, temp read=1,153 written=1,160
6. 16.922 2,013.517 ↓ 25.8 20,000 1

Nested Loop Left Join (cost=1,059,060.88..1,257,354.86 rows=774 width=129) (actual time=1,489.974..2,013.517 rows=20,000 loops=1)

  • Output: a1.id, a1.name, a1.url, a1.top_level_industry, a1.sub_level_industry, a1.hq_city, a1.hq_state, a1.hq_country, a1.hq_address, a1.hq_phone, a1.private_company_id, a3.bb_stock_ticker_last
  • Inner Unique: true
  • Buffers: shared hit=517,688, temp read=1,153 written=1,160
7. 18.152 1,976.595 ↓ 25.8 20,000 1

Nested Loop Left Join (cost=1,059,060.47..1,256,994.16 rows=774 width=124) (actual time=1,489.970..1,976.595 rows=20,000 loops=1)

  • Output: a1.id, a1.name, a1.url, a1.top_level_industry, a1.sub_level_industry, a1.hq_city, a1.hq_state, a1.hq_country, a1.hq_address, a1.hq_phone, a1.private_company_id, a2.id
  • Inner Unique: true
  • Buffers: shared hit=509,238, temp read=1,153 written=1,160
8. 21.520 1,938.443 ↓ 25.8 20,000 1

Nested Loop Semi Join (cost=1,059,060.17..1,256,754.06 rows=774 width=124) (actual time=1,489.964..1,938.443 rows=20,000 loops=1)

  • Output: a1.id, a1.name, a1.url, a1.top_level_industry, a1.sub_level_industry, a1.hq_city, a1.hq_state, a1.hq_country, a1.hq_address, a1.hq_phone, a1.stock_id, a1.private_company_id
  • Buffers: shared hit=501,009, temp read=1,153 written=1,160
9. 25.269 1,636.923 ↑ 1.0 20,000 1

Nested Loop (cost=1,059,059.61..1,210,575.17 rows=20,000 width=128) (actual time=1,489.943..1,636.923 rows=20,000 loops=1)

  • Output: a1.id, a1.name, a1.url, a1.top_level_industry, a1.sub_level_industry, a1.hq_city, a1.hq_state, a1.hq_country, a1.hq_address, a1.hq_phone, a1.stock_id, a1.private_company_id, software_product_usage_2.software_customer_id
  • Inner Unique: true
  • Buffers: shared hit=250,057, temp read=1,153 written=1,160
10. 12.841 1,511.654 ↑ 1.0 20,000 1

Limit (cost=1,059,059.17..1,059,109.17 rows=20,000 width=36) (actual time=1,489.920..1,511.654 rows=20,000 loops=1)

  • Output: software_product_usage_2.software_customer_id, (avg(software_product_usage_2.intensity))
  • Buffers: shared hit=170,020, temp read=1,153 written=1,160
11. 268.963 1,498.813 ↑ 23.8 20,000 1

Sort (cost=1,059,059.17..1,060,246.86 rows=475,076 width=36) (actual time=1,489.919..1,498.813 rows=20,000 loops=1)

  • Output: software_product_usage_2.software_customer_id, (avg(software_product_usage_2.intensity))
  • Sort Key: (avg(software_product_usage_2.intensity)) DESC
  • Sort Method: top-N heapsort Memory: 2,985kB
  • Buffers: shared hit=26,143, temp read=167 written=168
12. 400.574 1,229.850 ↑ 1.4 339,959 1

Finalize GroupAggregate (cost=1,001,839.19..1,022,745.04 rows=475,076 width=36) (actual time=526.996..1,229.850 rows=339,959 loops=1)

  • Output: software_product_usage_2.software_customer_id, avg(software_product_usage_2.intensity)
  • Group Key: software_product_usage_2.software_customer_id
  • Buffers: shared hit=26,143, temp read=167 written=168
13. 223.081 829.276 ↑ 1.2 471,942 1

Gather Merge (cost=1,001,839.19..1,013,872.20 rows=586,878 width=36) (actual time=526.987..829.276 rows=471,942 loops=1)

  • Output: software_product_usage_2.software_customer_id, (PARTIAL avg(software_product_usage_2.intensity))
  • Workers Planned: 6
  • Workers Launched: 6
  • Buffers: shared hit=170,020, temp read=1,153 written=1,160
14. 60.122 606.195 ↑ 1.5 67,420 7 / 7

Partial GroupAggregate (cost=1,001,829.09..1,003,540.82 rows=97,813 width=36) (actual time=519.035..606.195 rows=67,420 loops=7)

  • Output: software_product_usage_2.software_customer_id, PARTIAL avg(software_product_usage_2.intensity)
  • Group Key: software_product_usage_2.software_customer_id
  • Buffers: shared hit=170,020, temp read=1,153 written=1,160
  • Worker 0: actual time=515.724..606.011 rows=66,510 loops=1
  • Buffers: shared hit=22,666, temp read=162 written=163
  • Worker 1: actual time=516.936..612.847 rows=65,565 loops=1
  • Buffers: shared hit=22,868, temp read=159 written=160
  • Worker 2: actual time=518.459..602.646 rows=68,856 loops=1
  • Buffers: shared hit=24,478, temp read=168 written=169
  • Worker 3: actual time=518.926..599.646 rows=68,527 loops=1
  • Buffers: shared hit=24,699, temp read=167 written=168
  • Worker 4: actual time=518.869..601.042 rows=67,309 loops=1
  • Buffers: shared hit=24,584, temp read=165 written=166
  • Worker 5: actual time=518.750..615.881 rows=67,088 loops=1
  • Buffers: shared hit=24,582, temp read=165 written=166
15. 73.815 546.073 ↑ 1.3 74,255 7 / 7

Sort (cost=1,001,829.09..1,002,073.62 rows=97,813 width=8) (actual time=519.023..546.073 rows=74,255 loops=7)

  • Output: software_product_usage_2.software_customer_id, software_product_usage_2.intensity
  • Sort Key: software_product_usage_2.software_customer_id
  • Sort Method: external merge Disk: 1,336kB
  • Worker 0: Sort Method: external merge Disk: 1,296kB
  • Worker 1: Sort Method: external merge Disk: 1,272kB
  • Worker 2: Sort Method: external merge Disk: 1,344kB
  • Worker 3: Sort Method: external merge Disk: 1,336kB
  • Worker 4: Sort Method: external merge Disk: 1,320kB
  • Worker 5: Sort Method: external merge Disk: 1,320kB
  • Buffers: shared hit=170,020, temp read=1,153 written=1,160
  • Worker 0: actual time=515.711..543.557 rows=73,043 loops=1
  • Buffers: shared hit=22,666, temp read=162 written=163
  • Worker 1: actual time=516.921..546.447 rows=71,872 loops=1
  • Buffers: shared hit=22,868, temp read=159 written=160
  • Worker 2: actual time=518.447..544.711 rows=75,800 loops=1
  • Buffers: shared hit=24,478, temp read=168 written=169
  • Worker 3: actual time=518.914..543.775 rows=75,493 loops=1
  • Buffers: shared hit=24,699, temp read=167 written=168
  • Worker 4: actual time=518.856..544.332 rows=74,257 loops=1
  • Buffers: shared hit=24,584, temp read=165 written=166
  • Worker 5: actual time=518.737..548.860 rows=74,156 loops=1
  • Buffers: shared hit=24,582, temp read=165 written=166
16. 463.535 472.258 ↑ 1.3 74,255 7 / 7

Parallel Bitmap Heap Scan on public.software_product_usage software_product_usage_2 (cost=10,988.87..993,721.50 rows=97,813 width=8) (actual time=63.625..472.258 rows=74,255 loops=7)

  • Output: software_product_usage_2.software_customer_id, software_product_usage_2.intensity
  • Recheck Cond: (software_product_usage_2.software_vendor_id = ANY ('{2191}'::integer[]))
  • Rows Removed by Index Recheck: 2,257,552
  • Heap Blocks: exact=4,915 lossy=19,804
  • Buffers: shared hit=169,966
  • Worker 0: actual time=60.620..469.309 rows=73,043 loops=1
  • Buffers: shared hit=22,657
  • Worker 1: actual time=62.088..470.495 rows=71,872 loops=1
  • Buffers: shared hit=22,859
  • Worker 2: actual time=62.738..470.447 rows=75,800 loops=1
  • Buffers: shared hit=24,469
  • Worker 3: actual time=63.333..472.058 rows=75,493 loops=1
  • Buffers: shared hit=24,690
  • Worker 4: actual time=63.513..471.753 rows=74,257 loops=1
  • Buffers: shared hit=24,575
  • Worker 5: actual time=63.435..472.110 rows=74,156 loops=1
  • Buffers: shared hit=24,573
17. 8.723 8.723 ↑ 1.1 519,784 1 / 7

Bitmap Index Scan on software_product_usage_with_vendor_software_vendor_id_idx (cost=0.00..10,842.15 rows=586,878 width=0) (actual time=61.063..61.064 rows=519,784 loops=1)

  • Index Cond: (software_product_usage_2.software_vendor_id = ANY ('{2191}'::integer[]))
  • Buffers: shared hit=1,424
18. 100.000 100.000 ↑ 1.0 1 20,000

Index Scan using software_product_customers_pkey on public.software_product_customers a1 (cost=0.43..7.56 rows=1 width=124) (actual time=0.005..0.005 rows=1 loops=20,000)

  • Output: a1.id, a1.name, a1.url, a1.top_level_industry, a1.sub_level_industry, a1.hq_city, a1.hq_state, a1.hq_country, a1.hq_address, a1.hq_phone, a1.stock_id, a1.private_company_id
  • Index Cond: (a1.id = software_product_usage_2.software_customer_id)
  • Buffers: shared hit=80,037
19. 280.000 280.000 ↑ 1.0 1 20,000

Index Scan using software_product_usage_with_vendor_software_customer_id_idx on public.software_product_usage software_product_usage_1 (cost=0.57..2.31 rows=1 width=4) (actual time=0.014..0.014 rows=1 loops=20,000)

  • Output: software_product_usage_1.software_product_id, software_product_usage_1.software_customer_id, software_product_usage_1.first_verified, software_product_usage_1.last_verified, software_product_usage_1.intensity, software_product_usage_1.location_count, software_product_usage_1.digital_signature, software_product_usage_1.decile, software_product_usage_1.software_vendor_id, software_product_usage_1.id
  • Index Cond: (software_product_usage_1.software_customer_id = a1.id)
  • Filter: (software_product_usage_1.software_vendor_id = ANY ('{2191}'::integer[]))
  • Rows Removed by Filter: 8
  • Buffers: shared hit=250,952
20. 20.000 20.000 ↓ 0.0 0 20,000

Index Only Scan using stocks_pkey on public.stocks a2 (cost=0.29..0.31 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=20,000)

  • Output: a2.id
  • Index Cond: (a2.id = a1.stock_id)
  • Heap Fetches: 2,739
  • Buffers: shared hit=8,229
21. 20.000 20.000 ↓ 0.0 0 20,000

Index Only Scan using stock_fields_stock_id_ticker_idx on public.stock_fields a3 (cost=0.42..0.47 rows=1 width=13) (actual time=0.001..0.001 rows=0 loops=20,000)

  • Output: a3.stock_id, a3.bb_stock_ticker_last
  • Index Cond: (a3.stock_id = a2.id)
  • Heap Fetches: 228
  • Buffers: shared hit=8,450
22. 40.000 40.000 ↑ 1.0 1 20,000

Index Scan using private_company_fields_pkey on public.private_company_fields a4 (cost=0.43..0.60 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=20,000)

  • Output: a4.id, a4.entity_id, a4.archived_on, a4.wire_status, a4.board_call_status, a4.locationtext, a4.referredby, a4.exchnage_after_ipo, a4.brainstorm_process_status, a4.boolean0953, a4.moic_co_invested, a4.cbi_last_round_date, a4.co_invested_amount_usd, a4.co_invested_exposure, a4.last_round_amt, a4.deal_managers, a4.exposure_in_exuma, a4.pr_status, a4.laptop_closing_status, a4.board_seat_process, a4.close_investment_status, a4.s_m_growth_mom, a4.app_download_growth, a4.moic, a4.lastinteraction, a4.meeting_date, a4.rational, a4.coatuecapitalallocation_kona, a4.cbi_last_round_amt, a4.book_status, a4.second_meeting_status, a4.category, a4.capital_raised, a4.expected_ipo_price_range, a4.prop_team_push2, a4.commited_amount, a4.briefdescription, a4.share_count_ipo, a4.amount_invested_exuma, a4.data_request_status, a4.moic_for_exuma, a4.google_interest, a4.cbi_url, a4.offering_size, a4.vcindustry, a4.moic_for_flagship, a4.anticipated_sector, a4.interactioncount, a4.relationship_status, a4.description, a4.amount_invested_flagship, a4.followup, a4.ic_meeting, a4.legal_status, a4.app_download_count, a4.moic_for_kona2, a4.customer_calls_status, a4.coatuetotalinvestment_kona, a4.news_url, a4.ticker_after_ipo, a4.google_interest_growth, a4.coatuecapitalallocation, a4.advisory_check_process_status, a4.ownership_in_flagship, a4.prop_team_status, a4.exposure_to_flagship, a4.coatue_referer, a4.market_cap, a4.valuation_last_round, a4.last_round_valuation, a4.background_check, a4.ownership_in_kona2, a4.coatueidealsize, a4.allinvestors, a4.cbi_geocity, a4.ipo_allocation, a4.people_to_meet, a4.companyname, a4.date0704, a4.current_ownership, a4.last_capital_raised_date, a4.cbi_capital_raised, a4.initial_meeting_status, a4.cbi_geostate, a4.ownership_in_exuma, a4.co_invested_amount, a4.totalcoatueinvestment, a4.co_invested_ownership, a4.closing_dinner, a4.symbol, a4.pitchbook_companyid, a4.key_investors, a4.s_m_employees_on_linkedin, a4.date0702, a4.last_round_type_cbi, a4.last_round_amount_cbi, a4.last_round_date_cbi, a4.tag__39207, a4.tag__39216, a4.tag__39223, a4.tag__39206, a4.tag__39222, a4.tag__39220, a4.tag__39204, a4.tag__39218, a4.tag__39212, a4.tag__39201, a4.tag__39200, a4.tag__39217, a4.tag__39213, a4.tag__39205, a4.tag__39211, a4.tag__39208, a4.tag__39203, a4.tag__39214, a4.tag__39210, a4.tag__39221, a4.tag__39215, a4.tag__39209, a4.tag__39202, a4.sponsor_user_id, a4.f102818, a4.f102819, a4.f102833, a4.f103982, a4.analyst_user_id, a4.sponsor_partner_user_id, a4.tag__39242, a4.tag__39233, a4.tag__39232, a4.tag__39238, a4.tag__39240, a4.tag__39234, a4.tag__39231, a4.tag__39236, a4.tag__39237, a4.tag__39239, a4.tag__39243, a4.tag__39235, a4.tag__39241, a4.number0232, a4.number0233, a4.number0234, a4.number0235, a4.number0236, a4.number0237, a4.newroundtopinvestors, a4.number0241, a4.number0242, a4.aaa_initialinvestment_year, a4.number0244, a4.date0707, a4.number0245, a4.number0246, a4.number0247, a4.date0708, a4.number0248, a4.number0252, a4.number0253, a4.number0254, a4.number0256, a4.number0257, a4.number0259, a4.number0260, a4.date0710, a4.topinvestors, a4.number0243, a4.number0255, a4.number0265, a4.date0713, a4.number0264, a4.string0491, a4.string0492, a4.string0493, a4.string0494, a4.initial_investment_date, a4.tag__39245, a4.tag__39244, a4.f104630, a4.f104631, a4.boolean0968, a4.boolean0970, a4.override_description, a4.f104912, a4.f104913, a4.f104969, a4.f104974, a4.f104975, a4.f105057, a4.alltopinvestorslastround, a4.last_round_date_cbi_old, a4.f105065, a4.f105138, a4.f105175, a4.f105176, a4.f105177, a4.f106012, a4.f106013, a4.f106014, a4.f106015, a4.f106016, a4.f106017, a4.f106018, a4.f106019, a4.f106020, a4.f106022, a4.f106023, a4.f106024, a4.f106025, a4.f106026, a4.f106027, a4.f106095, a4.f106134, a4.f106159, a4.f106160, a4.f106162, a4.f106164, a4.f106169, a4.f106170, a4.f106172, a4.f106173, a4.f106174, a4.f106175, a4.f106177, a4.f106178, a4.f106183, a4.f106184, a4.f106185, a4.f106186, a4.f106187, a4.f106214, a4.f106215, a4.f106216, a4.f106217, a4.f106218, a4.f106219, a4.f106221, a4.f106222, a4.aaa_investor_count, a4.a_investor_count, a4.f106229, a4.f106230, a4.f106258, a4.f106259, a4.f106260, a4.aaa_rounds, a4.days_between_rounds, a4.last_valuation_change, a4.aaa_investors_followed_on_rounds, a4.f106270, a4.f106272, a4.aaa_investors, a4.a_investors, a4.temp_country, a4.f106308, a4.f106309, a4.f106310, a4.f106311, a4.f106312, a4.f106321, a4.f106322, a4.f106323, a4.f106324, a4.f106356, a4.cbi_companyid, a4.f106762, a4.f106769, a4.f108486, a4.f108487, a4.f108718, a4.f108719, a4.f108720, a4.f108726, a4.f108785, a4.cbi_address2, a4.cbi_address1, a4.cbi_geocountry, a4.f108796, a4.f108797, a4.f108798, a4.f108860, a4.cbi_sector, a4.cbi_industry, a4.f108861, a4.has_duplicate, a4.f108872, a4.f108873, a4.cbi_update_time, a4.cbi_update_date, a4.f108908, a4.f108909, a4.f108910, a4.f108911, a4.f108912, a4.f108913, a4.f108914, a4.f108915, a4.f108916, a4.f108917, a4.f108918, a4.f108919, a4.f108921, a4.f108922, a4.f108923, a4.f108924, a4.f108925, a4.f108926, a4.f108927, a4.f108928, a4.f108929, a4.f108930, a4.f108931, a4.f109005, a4.f109017, a4.f109020, a4.f109021, a4.f109056, a4.f109057, a4.f109058, a4.camera_category, a4.f109078, a4.f109080, a4.f109081, a4.f109082, a4.f109083, a4.f109084, a4.f109085, a4.f109087, a4.f109088, a4.f109098, a4.topvc_initial_inv_date_materialized, a4.vc_valuation_materialized, a4.last_round_date_materialized, a4.f109184, a4.f109186, a4.f109187, a4.f109193, a4.f109195, a4.f109196, a4.f109197, a4.f109232, a4.f109235, a4.f109236, a4.f109237, a4.f109238, a4.f109239, a4.f109242, a4.f109243, a4.f109244, a4.f109245, a4.f109246, a4.f109247, a4.f109249, a4.f109250, a4.f109251, a4.f109252, a4.f109253, a4.audit_date, a4.audit_pps, a4.f109256, a4.f109257, a4.f109258, a4.f109260, a4.f109261, a4.f109262, a4.f109263, a4.f109264, a4.f109265, a4.f109266, a4.f109267, a4.f109268, a4.f109269, a4.f109270, a4.f109272, a4.f109273, a4.f109274, a4.f109275, a4.f109278, a4.f109280, a4.f109281, a4.f109282, a4.f109284, a4.f109289, a4.f109291, a4.f109304, a4.f109330, a4.f109331, a4.f109332, a4.f109333, a4.f109334, a4.f109335, a4.f109336, a4.f109337, a4.f109338, a4.f109339, a4.f109340, a4.f109341, a4.f109342, a4.f109343, a4.f109344, a4.f109345, a4.f109346, a4.f109347, a4.f109348, a4.f109350, a4.f109351, a4.f109352, a4.f109353, a4.f109354, a4.f109355, a4.f109361, a4.f109362, a4.f109363, a4.f109364, a4.f109365, a4.f109366, a4.f109367, a4.f109368, a4.f109371, a4.f109372, a4.f109373, a4.f109374, a4.f109375, a4.f109376, a4.f109377, a4.f109378, a4.f109379, a4.f109380, a4.f109381, a4.f109382, a4.f109404, a4.f109438, a4.f109439, a4.f109440, a4.f109441, a4.f109445, a4.f109446, a4.f109448, a4.f109449, a4.f109466, a4.f109468, a4.f109476, a4.f109477, a4.f109478, a4.f109479, a4.f109481, a4.f109482, a4.f109483, a4.f109484, a4.f109485, a4.f109486, a4.f109487, a4.f109489, a4.f109491, a4.f109492, a4.f109493, a4.f109494, a4.f109495, a4.f109496, a4.f109497, a4.f109498, a4.f109500, a4.f109501, a4.f109502, a4.f109503, a4.f109504, a4.f109511, a4.f109512, a4.f109513, a4.f109514, a4.f109515, a4.f109516, a4.f109517, a4.f109518, a4.f109519, a4.f109520, a4.f109521, a4.f109522, a4.f109523, a4.f109524, a4.f109525, a4.f109526, a4.f109527, a4.f109528, a4.f109529, a4.f109530, a4.f109532, a4.f109533, a4.f109537, a4.f109541, a4.f109545, a4.f109548, a4.f109549, a4.f109550, a4.f109551, a4.f109552, a4.f109553, a4.f109554, a4.f109555, a4.f109556, a4.f109557, a4.f109558, a4.f109559, a4.f109560, a4.f109561, a4.f109571, a4.f109573, a4.f109583, a4.f109867, a4.f109890, a4.f109891, a4.f109892, a4.f109893, a4.f109894, a4.f109895, a4.f109896, a4.f109898, a4.f109907, a4.f109908, a4.f109909, a4.f109910, a4.f109911, a4.f109913, a4.f109914, a4.f109915, a4.model_attachment, a4.f110065, a4.f110068, a4.f110069, a4.f110070, a4.f110071, a4.f110073, a4.f110077, a4.f110080, a4.f110083, a4.f110084, a4.f110187, a4.f110189, a4.f110190, a4.f110191, a4.f110289, a4.f110449, a4.f110450, a4.f110451, a4.f110452, a4.f110453, a4.f110454, a4.f110455, a4.f110456, a4.f110457, a4.f110458, a4.f110459, a4.f110460, a4.f110512, a4.f110553, a4.f110611, a4.f110630, a4.f110637, a4.f110638, a4.f110639, a4.f110641, a4.f110646, a4.f110647, a4.f110660, a4.f110674, a4.f110694, a4.f110695, a4.f110696, a4.is_public, a4.f110697, a4.f110698, a4.stock_id, a4.f110700, a4.f110712, a4.f110713, a4.f110715, a4.f110716, a4.f110718, a4.f110719, a4.f110720, a4.f110721, a4.f110722, a4.f110723, a4.f110724, a4.f110725, a4.f110727, a4.f110728, a4.f110729, a4.f110730, a4.f110731, a4.f110732, a4.f110733, a4.f110734, a4.f110736, a4.f110737, a4.f110738, a4.f110739, a4.f110742, a4.f110744, a4.f110745, a4.f110746, a4.f110747, a4.f110749, a4.f110750, a4.f110751, a4.f110752, a4.f110754, a4.f110758, a4.f110759, a4.f110760, a4.f110762, a4.f110764, a4.f110765, a4.f110766, a4.f110767, a4.f110769, a4.f110770, a4.f110771, a4.f110772, a4.f110773, a4.f110774, a4.f110775, a4.f110776, a4.f110777, a4.f110778, a4.f110779, a4.f110780, a4.f110781, a4.f110782, a4.f110783, a4.f110784, a4.f110785, a4.f110786, a4.f110792, a4.f110794, a4.f110795, a4.f110798, a4.f110804, a4.f110805, a4.f110807, a4.f110810, a4.f110811, a4.f110812, a4.f110814, a4.f110816, a4.f110818, a4.f110820, a4.f110822, a4.f110823, a4.f110824, a4.f110825, a4.f110826, a4.f110828, a4.f110830, a4.f110832, a4.f110833, a4.f110836, a4.f110839, a4.f110840, a4.f110841, a4.f110842, a4.f110843, a4.f110844, a4.f110845, a4.f110846, a4.f110847, a4.f110848, a4.f110849, a4.f110850, a4.f110852, a4.f110853, a4.f110854, a4.f110870, a4.f110879, a4.f110911, a4.f110945, a4.f110946, a4.invited_to_prior_emws, a4.f111001, a4.f111002, a4.f111003, a4.f111004, a4.f111005, a4.f111006, a4.f111007, a4.f111008, a4.f111009, a4.f111010, a4.f111011, a4.f111012, a4.f111013, a4.f111014, a4.f111015, a4.f111016, a4.f111017, a4.f111018, a4.f111019, a4.f111020, a4.f111021, a4.f111022, a4.f111023, a4.f111024, a4.f111025, a4.f111026, a4.f111027, a4.f111028, a4.f111029, a4.f111030, a4.f111031, a4.f111032, a4.f111033, a4.f111034, a4.f111035, a4.f111036, a4.f111037, a4.f111038, a4.f111039, a4.f111040, a4.f111041, a4.f111042, a4.f111043, a4.f111044, a4.f111045, a4.f111046, a4.f111047, a4.f111048, a4.f111049, a4.f111050, a4.f111051, a4.f111052, a4.f111053, a4.f111054, a4.f111055, a4.f111056, a4.f111057, a4.f111058, a4.f111059, a4.f111060, a4.f111061, a4.f111062, a4.f111063, a4.f111064, a4.f111065, a4.f111066, a4.f111067, a4.f111068, a4.f111069, a4.f111070, a4.f111071, a4.f111072, a4.f111073, a4.f111074, a4.f111075, a4.f111076, a4.f111077, a4.f111078, a4.f111079, a4.f111080, a4.f111081, a4.f111082, a4.f111083, a4.f111084, a4.f111085, a4.f111086, a4.f111087, a4.f111088, a4.f111089, a4.f111090, a4.f111091, a4.f111092, a4.f111093, a4.f111094, a4.f111095, a4.f111096, a4.f111097, a4.f111098, a4.f111099, a4.f111100, a4.f111101, a4.f111102, a4.f111103, a4.f111104, a4.f111105, a4.f111106, a4.f111107, a4.f111108, a4.f111109, a4.f111110, a4.f111111, a4.f111112, a4.f111113, a4.f111114, a4.f111115, a4.f111116, a4.f111117, a4.f111118, a4.f111119, a4.f111120, a4.f111121, a4.f111122, a4.f111123, a4.f111124, a4.f111125, a4.f111126, a4.f111127, a4.f111128, a4.f111129, a4.f111130, a4.f111131, a4.f111132, a4.f111133, a4.f111134, a4.f111135, a4.f111136, a4.f111137, a4.f111138, a4.f111139, a4.f111140, a4.f111141, a4.f111142, a4.f111143, a4.f111144, a4.f111145, a4.f111146, a4.f111147, a4.f111148, a4.f111149, a4.f111150, a4.f111151, a4.f111152, a4.f111153, a4.f111154, a4.f111155, a4.f111156, a4.f111157, a4.f111158, a4.f111159, a4.f111160, a4.f111161, a4.f111162, a4.f111163, a4.f111164, a4.f111165, a4.f111166, a4.f111167, a4.f111168, a4.f111169, a4.f111170, a4.f111171, a4.f111172, a4.f111173, a4.f111174, a4.f111175, a4.f111176, a4.f111177, a4.f111178, a4.f111179, a4.f111180, a4.f111181, a4.f111182, a4.f111183, a4.f111184, a4.f111185, a4.f111186, a4.f111187, a4.f111188, a4.f111189, a4.f111190, a4.f111191, a4.f111192, a4.f111193, a4.f111194, a4.f111195, a4.f111196, a4.f111197, a4.f111198, a4.f111199, a4.f111200, a4.f111201, a4.f111202, a4.f111203, a4.f111204, a4.f111205, a4.f111206, a4.f111207, a4.f111208, a4.f111209, a4.f111210, a4.f111211, a4.f111212, a4.f111213, a4.f111214, a4.f111215, a4.f111216, a4.f111217, a4.f111218, a4.f111219, a4.f111220, a4.f111221, a4.f111222, a4.f111223, a4.f111224, a4.f111225, a4.f111226, a4.f111227, a4.f111228, a4.f111229, a4.f111230, a4.f111231, a4.f111232, a4.f111233, a4.f111234, a4.f111235, a4.f111236, a4.f111237, a4.f111238, a4.f111239, a4.f111240, a4.f111241, a4.f111242, a4.f111243, a4.f111244, a4.f111245, a4.f111246, a4.f111247, a4.f111248, a4.f111249, a4.f111250, a4.f111251, a4.f111252, a4.f111253, a4.f111254, a4.f111255, a4.f111256, a4.f111257, a4.f111258, a4.f111259, a4.f111260, a4.f111261, a4.f111262, a4.f111263, a4.f111264, a4.f111265, a4.f111266, a4.f111267, a4.f111268, a4.f111269, a4.f111270, a4.f111271, a4.f111272, a4.f111273, a4.f111274, a4.f111275, a4.f111276, a4.f111277, a4.f111278, a4.f111279, a4.f111280, a4.f111281, a4.f111282, a4.f111283, a4.f111284, a4.f111285, a4.f111286, a4.f111287, a4.f111288, a4.f111289, a4.f111290, a4.f111291, a4.f111292, a4.f111293, a4.f111294, a4.f111295, a4.f111296, a4.f111297, a4.f111298, a4.f111299, a4.f111300, a4.f111301, a4.f111302, a4.f111303, a4.f111304, a4.f111305, a4.f111306, a4.f111307, a4.f111308, a4.f111309, a4.f111310, a4.f111311, a4.f111312, a4.f111313, a4.f111314, a4.f111315, a4.f111316, a4.f111317, a4.f111318, a4.f111319, a4.f111320, a4.f111321, a4.f111322, a4.f111323, a4.f111324, a4.f111325, a4.f111326, a4.f111327, a4.f111328, a4.f111329, a4.f111330, a4.f111331, a4.f111332, a4.f111333, a4.f111334, a4.f111335, a4.f111336, a4.f111337, a4.f111338, a4.f111339, a4.f111340, a4.f111341, a4.f111342, a4.f111343, a4.f111344, a4.f111345, a4.f111346, a4.f111347, a4.f111348, a4.f111349, a4.f111350, a4.f111351, a4.f111352, a4.f111353, a4.f111354, a4.f111355, a4.f111356, a4.f111357, a4.f111358, a4.f111359, a4.f111360, a4.f111361, a4.f111362, a4.f111363, a4.f111364, a4.f111365, a4.f111366, a4.f111367, a4.f111368, a4.f111369, a4.f111370, a4.f111371, a4.f111372, a4.f111373, a4.f111374, a4.f111375, a4.f111376, a4.f111377, a4.f111378, a4.f111379, a4.f111380, a4.f111381, a4.f111382, a4.f111383, a4.f111384, a4.f111385, a4.f111386, a4.f111387, a4.f111388, a4.f111389, a4.f111390, a4.f111391, a4.f111392, a4.f111393, a4.f111395, a4.f111396, a4.f111397, a4.f111398, a4.f111399, a4.f111400, a4.f111443, a4.f111452, a4.f111497, a4.f111627, a4.f111628, a4.f111629, a4.f111630, a4.review_date, a4.f111644, a4.f111690, a4.fund_id, a4.f111695, a4.f111696, a4.f111697, a4.f111698, a4.f111699, a4.f111710, a4.f111714, a4.f111715, a4.f111717, a4.f111729, a4.f111951, a4.f111982, a4.f111999, a4.f112020, a4.f112021, a4.f112039, a4.f112048, a4.f112096, a4.f112099, a4.f112101, a4.f112102, a4.f112103, a4.f112104, a4.f112105, a4.f112112, a4.f112113, a4.f112120, a4.f112132, a4.f112133, a4.f112134, a4.f112135, a4.f112136, a4.f112197, a4.f112198, a4.f112205, a4.f112207, a4.f112208, a4.f112209, a4.f112211, a4.f112239, a4.f112469, a4.f112481, a4.f112485, a4.f112528, a4.f112544, a4.source_contact, a4.source_company, a4.early_stage_type, a4.f112579, a4.f112582, a4.f112594, a4.f112595, a4.f112596, a4.f112600, a4.f112601, a4.f112603, a4.f112604, a4.f112605, a4.f112631, a4.f112639, a4.f112710, a4.f112711, a4.f112759, a4.f112846, a4.f112847, a4.f112886, a4.f112887, a4.deal_captain, a4.f112948, a4.f112957, a4.f113017, a4.f113118, a4.f113210, a4.f113211, a4.f113212, a4.f113213, a4.f113215, a4.f113216, a4.f113217, a4.f113218, a4.f113219, a4.f113254, a4.f113310, a4.f113311, a4.f113312, a4.f113313, a4.f113315, a4.f113320, a4.f113326, a4.f113331, a4.f113332, a4.f113336, a4.f113352, a4.f113355, a4.f113360, a4.f113363, a4.f113364, a4.f113365, a4.f113376, a4.f113404, a4.f113403, a4.f113405, a4.f113406, a4.f113407, a4.f113425, a4.f113426, a4.f113442, a4.f113443, a4.f113444, a4.f113445, a4.f113446, a4.f113447, a4.f113448, a4.f113449, a4.f113450, a4.f113451, a4.f113452, a4.f113453, a4.f113454, a4.f113455, a4.f113456, a4.f113457, a4.f113458, a4.f113459, a4.f113460, a4.f113461, a4.f113462, a4.f113463, a4.f113464, a4.f113465, a4.f113466, a4.f113467, a4.f113468, a4.f113469, a4.f113470, a4.f113471, a4.f113472, a4.f113473, a4.f113474, a4.f113475, a4.f113476, a4.f113477, a4.f113478, a4.f113479, a4.f113480, a4.f113481, a4.f113482, a4.f113483, a4.f113484, a4.f113485, a4.f113486, a4.f113487, a4.f113488, a4.f113489, a4.f113490, a4.f113491, a4.f113492, a4.f113493, a4.f113494, a4.f113495, a4.f113496, a4.f113497, a4.f113498, a4.f113499, a4.f113500, a4.f113501, a4.f113502, a4.f113503, a4.f113504, a4.f113505, a4.f113506, a4.f113507, a4.f113508, a4.f113509, a4.f113510, a4.f113511, a4.f113512, a4.f113513, a4.f113514, a4.f113515, a4.f113516, a4.f113517, a4.f113518, a4.f113519, a4.f113520, a4.f113521, a4.f113522, a4.f113523, a4.f113524, a4.f113525, a4.f113526, a4.f113527, a4.f113528, a4.f113529, a4.f113530, a4.f113531, a4.f113532, a4.f113533, a4.f113534, a4.f113535, a4.f113536, a4.f113537, a4.f113538, a4.f113539, a4.f113540, a4.f113541, a4.f113542, a4.f113543, a4.f113544, a4.f113545, a4.f113546, a4.f113547, a4.f113548, a4.f113549, a4.f113550, a4.f113551, a4.f113552, a4.f113553, a4.f113554, a4.f113555, a4.f113556, a4.f113557, a4.f113558, a4.f113559, a4.f113560, a4.f113561, a4.f113562, a4.f113563, a4.f113564, a4.f113565, a4.f113566, a4.f113567, a4.f113568, a4.f113569, a4.f113570, a4.f113571, a4.f113572, a4.f113573, a4.f113574, a4.f113575, a4.f113576, a4.f113577, a4.f113578, a4.f113579, a4.f113580, a4.f113581, a4.f113582, a4.f113583, a4.f113584, a4.f113585, a4.f113586, a4.f113587, a4.f113588, a4.f113589, a4.f113590, a4.f113591, a4.f113592, a4.f113593, a4.f113594, a4.f113595, a4.f113596, a4.f113597, a4.f113598, a4.f113599, a4.f113600, a4.f113601, a4.f113602, a4.f113603, a4.f113604, a4.f113605, a4.f113606, a4.f113607, a4.f113608, a4.f113609, a4.f113610, a4.f113611, a4.f113612, a4.f113613, a4.f113614, a4.f113615, a4.f113616, a4.f113617, a4.f113618, a4.f113619, a4.f113620, a4.f113621, a4.f113622, a4.f113623, a4.f113624, a4.f113625, a4.f113626, a4.f113627, a4.f113628, a4.f113629, a4.f113630, a4.f113631, a4.f113632, a4.f113633, a4.f113634, a4.f113635, a4.f113636, a4.f113637, a4.f113638, a4.f113639, a4.f113640, a4.f113641, a4.f113642, a4.f113643, a4.f113644, a4.f113645, a4.f113646, a4.f113647, a4.f113648, a4.f113649, a4.f113650, a4.f113651, a4.f113652, a4.f113653, a4.f113654, a4.f113655, a4.f113656, a4.f113657, a4.f113658, a4.f113659, a4.f113660, a4.f113661, a4.f113662, a4.f113663, a4.f113664, a4.f113665, a4.f113666, a4.f113667, a4.f113668, a4.f113669, a4.f113670, a4.f113671, a4.f113672, a4.f113673, a4.f113674, a4.f113675, a4.f113676, a4.f113677, a4.f113678, a4.f113679, a4.f113680, a4.f113681, a4.f113682, a4.f113683, a4.f113694, a4.f113730, a4.is_stock_of_interest, a4.f113747, a4.f113758, a4.f113760, a4.f113761, a4.f113762, a4.f113763, a4.f113802, a4.f113816, a4.f113867, a4.private_angel_user_id, a4.f114118, a4.f114154, a4.f114155, a4.f114156, a4.f114157, a4.f114179, a4.f114180, a4.f114181, a4.f114182, a4.f114183, a4.f114184, a4.f114188, a4.f114191, a4.f114194, a4.f114196, a4.f114199, a4.f114200, a4.f114201, a4.f114228, a4.f114305, a4.f114306, a4.f114307, a4.f114349, a4.f114426, a4.f114444, a4.f114472, a4.f114497, a4.f114504, a4.f114523, a4.f114524, a4.f114584, a4.f114586, a4.f109254, a4.f114664, a4.f114705, a4.f114833, a4.f114893, a4.f114894, a4.f114895, a4.f114896, a4.f114897, a4.f114898, a4.f114899, a4.f114900, a4.f114903, a4.f114912, a4.f114917, a4.lead_investor, a4.f114944, a4.f114945, a4.f114969, a4.f114970, a4.f114971, a4.f114972, a4.f114973, a4.f114975, a4.f114976, a4.f114977, a4.f114978, a4.f114979, a4.f114993, a4.f115006, a4.f115007, a4.f115008, a4.cbi_sub_industry, a4.f115056, a4.f115094, a4.f115095, a4.f115096, a4.f115097, a4.f115098, a4.f115099, a4.f115100, a4.f115101, a4.f115102, a4.f115103, a4.f115105, a4.f115122, a4.f115123, a4.f115124, a4.f115126, a4.f115127, a4.f115128, a4.f115132, a4.f115133, a4.f115134, a4.f115135, a4.f115136, a4.f115137, a4.f115176, a4.f115188, a4.f115189, a4.f115190, a4.f115191, a4.f115192, a4.f115193, a4.f115194, a4.f115195, a4.f115196, a4.f115363, a4.f115366, a4.f115367, a4.f115371, a4.f115373, a4.f115377, a4.f115378, a4.f115379, a4.f115395, a4.f115407, a4.f115414, a4.f115418, a4.f115420, a4.f115421, a4.f115435, a4.f115516, a4.f115517, a4.f115523, a4.f115542, a4.f115549, a4.f115550, a4.valuation_captain_id, a4.pb_url, a4.pb_address1, a4.pb_address2, a4.pb_geocountry, a4.pb_geocity, a4.pb_geostate, a4.pb_sector, a4.pb_industry, a4.pb_capital_raised, a4.pb_update_date, a4.del_dup, a4.total_cap_raised_materialized, a4.e_plus_g_aaa_materialized, a4.last_meeting_with_company_materialized
  • Index Cond: (a4.id = a1.private_company_id)
  • Buffers: shared hit=41,025
23.          

SubPlan (for Nested Loop Left Join)

24. 60.000 4,500.000 ↑ 1.0 1 20,000

Aggregate (cost=313.04..313.05 rows=1 width=32) (actual time=0.225..0.225 rows=1 loops=20,000)

  • Output: avg(software_product_usage.intensity)
  • Buffers: shared hit=5,002,107
25. 4,440.000 4,440.000 ↓ 3.0 3 20,000

Index Scan using software_product_usage_with_vendor_software_customer_id_idx on public.software_product_usage (cost=0.57..313.03 rows=1 width=4) (actual time=0.008..0.222 rows=3 loops=20,000)

  • Output: software_product_usage.software_product_id, software_product_usage.software_customer_id, software_product_usage.first_verified, software_product_usage.last_verified, software_product_usage.intensity, software_product_usage.location_count, software_product_usage.digital_signature, software_product_usage.decile, software_product_usage.software_vendor_id, software_product_usage.id
  • Index Cond: (software_product_usage.software_customer_id = a1.id)
  • Filter: (software_product_usage.software_vendor_id = ANY ('{2191}'::integer[]))
  • Rows Removed by Filter: 267
  • Buffers: shared hit=5,002,107
26. 15.437 12,429.955 ↓ 25.8 20,000 1

Hash Right Join (cost=411,727.58..494,214.14 rows=774 width=424) (actual time=10,233.036..12,429.955 rows=20,000 loops=1)

  • Output: b.id, b.d1, b.d2, b.d3, COALESCE((concat('[', string_agg((companies_x_rounds.entity1_id)::text, ','::text ORDER BY companies_x_rounds.entity1_id), ']')), '[]'::text), b.d4, b.d21, b.d22, b.d23, b.d24, b.d25, b.d26, b.d27, b.d28, b.d4
  • Hash Cond: (rounds.private_company_id = b.d0)
  • Buffers: shared hit=5,614,811, temp read=25,840 written=26,299
27. 35.035 5,686.852 ↓ 35.6 7,125 1

GroupAggregate (cost=411,702.42..494,159.49 rows=200 width=36) (actual time=3,505.127..5,686.852 rows=7,125 loops=1)

  • Output: rounds.private_company_id, concat('[', string_agg((companies_x_rounds.entity1_id)::text, ','::text ORDER BY companies_x_rounds.entity1_id), ']')
  • Group Key: rounds.private_company_id
  • Buffers: shared hit=53,991, temp read=24,087 written=24,092
28. 360.199 5,651.817 ↑ 27.6 42,635 1

Merge Join (cost=411,702.42..482,377.48 rows=1,177,901 width=8) (actual time=3,504.787..5,651.817 rows=42,635 loops=1)

  • Output: rounds.private_company_id, companies_x_rounds.entity1_id
  • Inner Unique: true
  • Merge Cond: (rounds.private_company_id = b_1.d0)
  • Buffers: shared hit=53,991, temp read=24,087 written=24,092
29. 979.253 5,267.261 ↑ 1.7 1,383,995 1

Unique (cost=411,675.36..429,343.88 rows=2,355,802 width=12) (actual time=3,483.689..5,267.261 rows=1,383,995 loops=1)

  • Output: 89, rounds.private_company_id, companies_x_rounds.entity1_id
  • Buffers: shared hit=53,991, temp read=23,640 written=24,091
30. 2,495.707 4,288.008 ↑ 1.0 2,354,081 1

Sort (cost=411,675.36..417,564.87 rows=2,355,802 width=12) (actual time=3,483.687..4,288.008 rows=2,354,081 loops=1)

  • Output: 89, rounds.private_company_id, companies_x_rounds.entity1_id
  • Sort Key: rounds.private_company_id, companies_x_rounds.entity1_id
  • Sort Method: external merge Disk: 50,800kB
  • Buffers: shared hit=53,991, temp read=23,640 written=24,091
31. 493.391 1,792.301 ↑ 1.0 2,355,802 1

Gather (cost=45,307.78..81,818.79 rows=2,355,802 width=12) (actual time=941.899..1,792.301 rows=2,355,802 loops=1)

  • Output: (89), rounds.private_company_id, companies_x_rounds.entity1_id
  • Workers Planned: 3
  • Workers Launched: 3
  • Buffers: shared hit=53,991, temp read=12,643 written=13,052
32. 700.341 1,298.910 ↑ 1.3 588,950 4 / 4

Parallel Hash Join (cost=45,297.78..79,452.99 rows=759,936 width=12) (actual time=934.440..1,298.910 rows=588,950 loops=4)

  • Output: 89, rounds.private_company_id, companies_x_rounds.entity1_id
  • Inner Unique: true
  • Hash Cond: (companies_x_rounds.entity2_id = rounds.id)
  • Buffers: shared hit=53,991, temp read=12,643 written=13,052
  • Worker 0: actual time=927.287..1428.402 rows=823,443 loops=1
  • Buffers: shared hit=13,258, temp read=4,299 written=3,036
  • Worker 1: actual time=933.597..1407.425 rows=752,277 loops=1
  • Buffers: shared hit=14,681, temp read=4,052 written=3,708
  • Worker 2: actual time=936.291..1418.559 rows=778,913 loops=1
  • Buffers: shared hit=13,290, temp read=4,143 written=3,404
33. 269.699 269.699 ↑ 1.3 588,950 4 / 4

Parallel Seq Scan on public.companies_x_rounds (cost=0.00..24,922.36 rows=759,936 width=8) (actual time=0.011..269.699 rows=588,950 loops=4)

  • Output: companies_x_rounds.entity1_id, companies_x_rounds.entity2_id
  • Buffers: shared hit=17,323
  • Worker 0: actual time=0.010..270.034 rows=526,166 loops=1
  • Buffers: shared hit=3,869
  • Worker 1: actual time=0.011..275.010 rows=726,573 loops=1
  • Buffers: shared hit=5,343
  • Worker 2: actual time=0.011..268.328 rows=608,180 loops=1
  • Buffers: shared hit=4,472
34. 166.438 328.870 ↓ 1.0 336,184 4 / 4

Parallel Hash (cost=39,840.68..39,840.68 rows=332,568 width=8) (actual time=328.870..328.870 rows=336,184 loops=4)

  • Output: rounds.private_company_id, rounds.id
  • Buckets: 131,072 Batches: 32 Memory Usage: 2,720kB
  • Buffers: shared hit=36,515, temp written=4,660
  • Worker 0: actual time=327.412..327.413 rows=335,201 loops=1
  • Buffers: shared hit=9,338, temp written=1,156
  • Worker 1: actual time=327.601..327.601 rows=335,453 loops=1
  • Buffers: shared hit=9,287, temp written=1,148
  • Worker 2: actual time=327.219..327.220 rows=356,036 loops=1
  • Buffers: shared hit=8,767, temp written=1,240
35. 162.432 162.432 ↓ 1.0 336,184 4 / 4

Parallel Seq Scan on public.rounds (cost=0.00..39,840.68 rows=332,568 width=8) (actual time=0.005..162.432 rows=336,184 loops=4)

  • Output: rounds.private_company_id, rounds.id
  • Buffers: shared hit=36,515
  • Worker 0: actual time=0.004..162.272 rows=335,201 loops=1
  • Buffers: shared hit=9,338
  • Worker 1: actual time=0.004..162.301 rows=335,453 loops=1
  • Buffers: shared hit=9,287
  • Worker 2: actual time=0.006..160.816 rows=356,036 loops=1
  • Buffers: shared hit=8,767
36. 7.405 24.357 ↓ 50.4 10,074 1

Sort (cost=27.06..27.56 rows=200 width=4) (actual time=21.091..24.357 rows=10,074 loops=1)

  • Output: b_1.d0
  • Sort Key: b_1.d0
  • Sort Method: quicksort Memory: 857kB
  • Buffers: temp read=447 written=1
37. 9.692 16.952 ↓ 50.4 10,074 1

HashAggregate (cost=17.41..19.41 rows=200 width=4) (actual time=14.209..16.952 rows=10,074 loops=1)

  • Output: b_1.d0
  • Group Key: b_1.d0
  • Buffers: temp read=447 written=1
38. 7.260 7.260 ↓ 25.8 20,000 1

CTE Scan on b b_1 (cost=0.00..15.48 rows=774 width=4) (actual time=0.027..7.260 rows=20,000 loops=1)

  • Output: b_1.d0
  • Buffers: temp read=447 written=1
39. 15.568 6,727.666 ↓ 25.8 20,000 1

Hash (cost=15.48..15.48 rows=774 width=364) (actual time=6,727.666..6,727.666 rows=20,000 loops=1)

  • Output: b.id, b.d1, b.d2, b.d3, b.d4, b.d21, b.d22, b.d23, b.d24, b.d25, b.d26, b.d27, b.d28, b.d0
  • Buckets: 32,768 (originally 1024) Batches: 2 (originally 1) Memory Usage: 3,841kB
  • Buffers: shared hit=5,560,820, temp read=1,602 written=2,177
40. 6,712.098 6,712.098 ↓ 25.8 20,000 1

CTE Scan on b (cost=0.00..15.48 rows=774 width=364) (actual time=6,676.521..6,712.098 rows=20,000 loops=1)

  • Output: b.id, b.d1, b.d2, b.d3, b.d4, b.d21, b.d22, b.d23, b.d24, b.d25, b.d26, b.d27, b.d28, b.d0
  • Buffers: shared hit=5,560,820, temp read=1,602 written=2,056
Planning time : 3.511 ms
Execution time : 12,522.884 ms