explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SIsl

Settings
# exclusive inclusive rows x rows loops node
1. 48.261 93,422.435 ↑ 1.2 10,934 1

Sort (cost=1,246,558.99..1,246,591.25 rows=12,902 width=1,600) (actual time=93,420.927..93,422.435 rows=10,934 loops=1)

  • Sort Key: my_company.id DESC
  • Sort Method: quicksort Memory: 21,040kB
  • JIT:
  • Functions: 71
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 6.576 ms, Inlining 153.968 ms, Optimization 404.078 ms, Emission 260.011 ms, Total 824.634 ms
2. 58.414 93,374.174 ↑ 1.2 10,934 1

Hash Semi Join (cost=511,240.57..1,245,678.09 rows=12,902 width=1,600) (actual time=5,997.812..93,374.174 rows=10,934 loops=1)

  • Hash Cond: (my_company.id = u0.company_id)
3. 87,442.167 92,718.751 ↑ 1.9 106,119 1

Bitmap Heap Scan on my_company (cost=499,793.38..1,233,166.59 rows=197,175 width=1,600) (actual time=5,397.255..92,718.751 rows=106,119 loops=1)

  • Recheck Cond: ((fulltext_search_index @@ ''trade'' | ''bank'' | ''bank'' | ''financ'' | ''financ'' | ''transact'' | ''complianc'' | ''insur'' | ''currenc'' | ''currenc'' | ''credit'' <-> ''card'' | ''financi'' <-> ''servic'' | ''invoic'' | ''loan'' | ''leas'' | ''cryptocurr'' | ''risk'' <-> ''manag'' | ''stock'' <-> ''exchang'' | ''asset'' <-> ''manag'' | ''fintech'' | ''incub'' | ''bitcoin'' | ''lend'' | ''point'' <2> ''sale'' | ''cyber'' <-> ''secur'' | ''trade'' <-> ''platform'' | ''smart'' <-> ''contract'' | ''peer'' <2> ''peer'' | ''debit'' <-> ''card'' | ''ventur'' <-> ''capit'' | ''mortgag'' | ''p2p'' | ''wealth'' <-> ''manag'' | ''crowdfund'' | ''financi'' <-> ''plan'' | ''stock'' <-> ''market'' | ''life'' <-> ''insur'' | ''mobil'' <-> ''payment'' | ''health'' <-> ''insur'' | ''remitt'' | ''real'' <-> ''estat'' <-> ''invest'' | ''busi'' <-> ''financ'' | ''invest'' <-> ''servic'' | ''financi'' <-> ''technolog'' | ''pos'' <-> ''solut'' | ''transact'' <-> ''process'' | ''privat'' <-> ''bank'' | ''credit'' <-> ''score'' | ''hedg'' <-> ''fund'' | ''person'' <-> ''financ'' | ''retail'' <-> ''bank'' | ''claim'' <-> ''manag'' | ''fraud'' <-> ''detect'' | ''insurtech'' | ''virtual'' <-> ''currenc'' | ''angel'' <-> ''invest'' | ''crowd'' <-> ''fund'' | ''core'' <-> ''bank'' | ''digit'' <-> ''bank'' | ''fin'' <-> ''tech'' | ''consum'' <-> ''financ'' | ''impact'' <-> ''invest'' | ''p2p'' <-> ''lend'' | ''debt'' <-> ''collect'' | ''bank'' <-> ''platform'' | ''auto'' <-> ''insur'' | ''properti'' <-> ''insur'' | ''commerci'' <-> ''insur'' | ''predict'' <-> ''market'' | ''creditworthi'' | ''regtech'' | ''financi'' <-> ''exchang'' | ''consum'' <-> ''lend'' | ''credit'' <-> ''bureau'' | ''bank'' <-> ''api'' | ''authent'' <-> ''technolog'' | ''micro'' <-> ''lend'' | ''microloan'' | ''regulatori'' <-> ''tech'' | ''peer'' <2> ''peer'' <-> ''bank'' | ''commerci'' <-> ''lend'' | ''financi'' <-> ''manag'' <-> ''applic'' | ''microinvest'' | ''p2p'' <-> ''insur'' | ''reg'' <-> ''tech'' | ''bank'' <-> ''clearanc'' | ''crowd'' <-> ''financ'' | ''crowdfinnc'' | ''invest'' <-> ''manag'' <-> ''system'' | ''p2p'' <-> ''bank''::tsquery) AND (company_type = 2) AND (url_status = 1))
  • Rows Removed by Index Recheck: 54,965
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 57,142
  • Heap Blocks: exact=197,083
4. 23.329 3,605.515 ↓ 0.0 0 1

BitmapAnd (cost=94,060.43..94,060.43 rows=394,349 width=0) (actual time=3,605.515..3,605.515 rows=0 loops=1)

5. 2,419.704 2,419.704 ↑ 1.8 352,274 1

Bitmap Index Scan on my_company_main_fulltext (cost=0.00..6,414.92 rows=620,827 width=0) (actual time=2,419.704..2,419.704 rows=352,274 loops=1)

  • Index Cond: (fulltext_search_index @@ ''trade'' | ''bank'' | ''bank'' | ''financ'' | ''financ'' | ''transact'' | ''complianc'' | ''insur'' | ''currenc'' | ''currenc'' | ''credit'' <-> ''card'' | ''financi'' <-> ''servic'' | ''invoic'' | ''loan'' | ''leas'' | ''cryptocurr'' | ''risk'' <-> ''manag'' | ''stock'' <-> ''exchang'' | ''asset'' <-> ''manag'' | ''fintech'' | ''incub'' | ''bitcoin'' | ''lend'' | ''point'' <2> ''sale'' | ''cyber'' <-> ''secur'' | ''trade'' <-> ''platform'' | ''smart'' <-> ''contract'' | ''peer'' <2> ''peer'' | ''debit'' <-> ''card'' | ''ventur'' <-> ''capit'' | ''mortgag'' | ''p2p'' | ''wealth'' <-> ''manag'' | ''crowdfund'' | ''financi'' <-> ''plan'' | ''stock'' <-> ''market'' | ''life'' <-> ''insur'' | ''mobil'' <-> ''payment'' | ''health'' <-> ''insur'' | ''remitt'' | ''real'' <-> ''estat'' <-> ''invest'' | ''busi'' <-> ''financ'' | ''invest'' <-> ''servic'' | ''financi'' <-> ''technolog'' | ''pos'' <-> ''solut'' | ''transact'' <-> ''process'' | ''privat'' <-> ''bank'' | ''credit'' <-> ''score'' | ''hedg'' <-> ''fund'' | ''person'' <-> ''financ'' | ''retail'' <-> ''bank'' | ''claim'' <-> ''manag'' | ''fraud'' <-> ''detect'' | ''insurtech'' | ''virtual'' <-> ''currenc'' | ''angel'' <-> ''invest'' | ''crowd'' <-> ''fund'' | ''core'' <-> ''bank'' | ''digit'' <-> ''bank'' | ''fin'' <-> ''tech'' | ''consum'' <-> ''financ'' | ''impact'' <-> ''invest'' | ''p2p'' <-> ''lend'' | ''debt'' <-> ''collect'' | ''bank'' <-> ''platform'' | ''auto'' <-> ''insur'' | ''properti'' <-> ''insur'' | ''commerci'' <-> ''insur'' | ''predict'' <-> ''market'' | ''creditworthi'' | ''regtech'' | ''financi'' <-> ''exchang'' | ''consum'' <-> ''lend'' | ''credit'' <-> ''bureau'' | ''bank'' <-> ''api'' | ''authent'' <-> ''technolog'' | ''micro'' <-> ''lend'' | ''microloan'' | ''regulatori'' <-> ''tech'' | ''peer'' <2> ''peer'' <-> ''bank'' | ''commerci'' <-> ''lend'' | ''financi'' <-> ''manag'' <-> ''applic'' | ''microinvest'' | ''p2p'' <-> ''insur'' | ''reg'' <-> ''tech'' | ''bank'' <-> ''clearanc'' | ''crowd'' <-> ''financ'' | ''crowdfinnc'' | ''invest'' <-> ''manag'' <-> ''system'' | ''p2p'' <-> ''bank''::tsquery)
6. 1,162.482 1,162.482 ↓ 1.1 2,584,111 1

Bitmap Index Scan on my_company_url_status_2704ae13bae74399_uniq (cost=0.00..87,546.67 rows=2,432,299 width=0) (actual time=1,162.482..1,162.482 rows=2,584,111 loops=1)

  • Index Cond: (url_status = 1)
7.          

SubPlan (for Bitmap Heap Scan)

8. 23.497 1,671.069 ↑ 1.1 265,977 1

Gather (cost=2,143.66..404,980.05 rows=301,157 width=4) (actual time=36.819..1,671.069 rows=265,977 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 12.844 1,647.572 ↑ 1.4 88,659 3 / 3

Nested Loop (cost=1,143.66..373,864.35 rows=125,482 width=4) (actual time=137.208..1,647.572 rows=88,659 loops=3)

10. 419.493 1,189.980 ↑ 1.4 88,950 3 / 3

Hash Join (cost=1,143.23..315,793.12 rows=125,482 width=4) (actual time=137.126..1,189.980 rows=88,950 loops=3)

  • Hash Cond: (u1.campaign_id = u2.id)
11. 635.291 635.291 ↑ 1.2 3,857,165 3 / 3

Parallel Seq Scan on campaigns_processedurl u1 (cost=0.00..302,007.65 rows=4,815,065 width=8) (actual time=0.022..635.291 rows=3,857,165 loops=3)

12. 0.075 135.196 ↑ 1.0 518 3 / 3

Hash (cost=1,136.76..1,136.76 rows=518 width=4) (actual time=135.196..135.196 rows=518 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 27kB
13. 135.021 135.121 ↑ 1.0 518 3 / 3

Bitmap Heap Scan on campaigns_urlcampaign u2 (cost=16.30..1,136.76 rows=518 width=4) (actual time=133.979..135.121 rows=518 loops=3)

  • Recheck Cond: (project_id = 999)
  • Heap Blocks: exact=94
14. 0.100 0.100 ↑ 1.0 518 3 / 3

Bitmap Index Scan on campaigns_urlcampaign_b098ad43 (cost=0.00..16.17 rows=518 width=0) (actual time=0.100..0.100 rows=518 loops=3)

  • Index Cond: (project_id = 999)
15. 444.748 444.748 ↑ 1.0 1 266,849 / 3

Index Only Scan using my_company_pkey on my_company u0_1 (cost=0.43..0.46 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=266,849)

  • Index Cond: (id = u1.company_id)
  • Heap Fetches: 65,356
16. 53.388 597.009 ↓ 1.1 277,360 1

Hash (cost=8,315.25..8,315.25 rows=250,555 width=4) (actual time=597.008..597.009 rows=277,360 loops=1)

  • Buckets: 524,288 (originally 262144) Batches: 1 (originally 1) Memory Usage: 13,847kB
17. 543.621 543.621 ↓ 1.1 277,360 1

Index Only Scan using my_companysource_source_id_a8900f16_uniq on my_companysource u0 (cost=0.44..8,315.25 rows=250,555 width=4) (actual time=417.555..543.621 rows=277,360 loops=1)

  • Index Cond: (source_id = ANY ('{1,2,3,4,5,6}'::integer[]))
  • Heap Fetches: 208,358
Planning time : 6.181 ms
Execution time : 93,478.951 ms