explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LAUb

Settings
# exclusive inclusive rows x rows loops node
1. 129.760 104,572.073 ↑ 21,290.8 3,008 1

GroupAggregate (cost=109,766,883.42..114,089,769.04 rows=64,042,750 width=355) (actual time=104,435.502..104,572.073 rows=3,008 loops=1)

  • Group Key: messages.id, clients.id, pq.start_date, wk.id, cmp.id, message_metrics.id, fiscal_dates.week_legend, fiscal_dates.month_legend, fiscal_dates.quarter_legend, fiscal_dates.year_legend
2. 103.822 104,442.313 ↑ 789.9 81,080 1

Sort (cost=109,766,883.42..109,926,990.29 rows=64,042,750 width=359) (actual time=104,435.450..104,442.313 rows=81,080 loops=1)

  • Sort Key: messages.id, pq.start_date, wk.id, cmp.id, message_metrics.id, fiscal_dates.week_legend, fiscal_dates.month_legend, fiscal_dates.quarter_legend, fiscal_dates.year_legend
  • Sort Method: quicksort Memory: 24,875kB
3. 15.532 104,338.491 ↑ 789.9 81,080 1

Hash Left Join (cost=87,586,055.11..89,154,713.72 rows=64,042,750 width=359) (actual time=103,674.983..104,338.491 rows=81,080 loops=1)

  • Hash Cond: ((fir.id = fim.functional_insight_report_id) AND (functional_tags_gene_values.functional_tag_id = fim.taggable_id))
4. 17.234 104,319.264 ↑ 789.9 81,080 1

Merge Right Join (cost=87,585,888.60..88,674,216.19 rows=64,042,750 width=363) (actual time=103,671.274..104,319.264 rows=81,080 loops=1)

  • Merge Cond: (functional_tags_gene_values.gene_value_id = mgv.gene_value_id)
5. 7.157 7.157 ↑ 2.2 33,824 1

Index Scan using idx_25481_index_functional_tags_gene_values_on_gene_value_id on functional_tags_gene_values (cost=0.29..1,682.74 rows=72,930 width=16) (actual time=0.010..7.157 rows=33,824 loops=1)

6. 28.095 104,294.873 ↑ 2.2 81,080 1

Materialize (cost=87,585,888.31..87,712,148.94 rows=175,628 width=363) (actual time=103,668.558..104,294.873 rows=81,080 loops=1)

7. 0.000 104,266.778 ↑ 2.2 81,080 1

Nested Loop Left Join (cost=87,585,888.31..87,711,709.87 rows=175,628 width=363) (actual time=103,668.555..104,266.778 rows=81,080 loops=1)

8. 76.326 104,188.346 ↑ 2.2 81,080 1

Merge Left Join (cost=87,585,888.03..87,595,959.58 rows=175,628 width=367) (actual time=103,668.535..104,188.346 rows=81,080 loops=1)

  • Merge Cond: ((mgv.gene_value_id = dim_able.gene_value_id) AND (dim.taggable_id = dim_able.id) AND ((dim.taggable_type)::text = dim_able.tag_type))
9. 125.495 103,675.933 ↑ 2.2 81,080 1

Sort (cost=87,484,227.66..87,484,666.73 rows=175,628 width=363) (actual time=103,668.531..103,675.933 rows=81,080 loops=1)

  • Sort Key: mgv.gene_value_id, dim.taggable_id, dim.taggable_type
  • Sort Method: quicksort Memory: 27,400kB
10. 21.218 103,550.438 ↑ 2.2 81,080 1

Merge Left Join (cost=87,450,895.33..87,451,698.31 rows=175,628 width=363) (actual time=103,520.300..103,550.438 rows=81,080 loops=1)

  • Merge Cond: (an.id = dir.analysis_id)
11. 20.043 103,465.127 ↑ 1.3 20,568 1

Sort (cost=87,431,807.60..87,431,875.41 rows=27,123 width=323) (actual time=103,464.006..103,465.127 rows=20,568 loops=1)

  • Sort Key: an.id
  • Sort Method: quicksort Memory: 6,500kB
12. 14.787 103,445.084 ↑ 1.3 20,568 1

Hash Left Join (cost=2,353.28..87,429,810.37 rows=27,123 width=323) (actual time=3,268.257..103,445.084 rows=20,568 loops=1)

  • Hash Cond: (ftgv.formatting_tag_id = ft.id)
  • Filter: ((ft.id IS NULL) OR ((118 = ANY ((concat('{', ft.ancestor_ids, '}'))::integer[])) AND (genes.name = ANY ('{symbol,CTA_symbol,cta_symbol}'::text[])) AND (NOT (SubPlan 1)) AND (NOT (SubPlan 3))))
  • Rows Removed by Filter: 728
13. 14.392 78,936.638 ↑ 253.8 21,296 1

Nested Loop Left Join (cost=2,335.18..159,586.93 rows=5,404,534 width=339) (actual time=3,268.224..78,936.638 rows=21,296 loops=1)

14. 16.137 78,900.950 ↓ 6.1 21,296 1

Nested Loop Left Join (cost=2,334.88..9,901.81 rows=3,465 width=331) (actual time=3,268.214..78,900.950 rows=21,296 loops=1)

15. 7.628 78,842.221 ↓ 21,296.0 21,296 1

Nested Loop Left Join (cost=2,319.42..9,781.84 rows=1 width=323) (actual time=3,268.166..78,842.221 rows=21,296 loops=1)

16. 14.316 78,802.721 ↓ 10,624.0 10,624 1

Nested Loop (cost=2,319.13..9,780.72 rows=1 width=323) (actual time=3,268.155..78,802.721 rows=10,624 loops=1)

17. 22,605.728 78,745.909 ↓ 10,624.0 10,624 1

Nested Loop (cost=2,318.85..9,778.84 rows=1 width=195) (actual time=3,268.141..78,745.909 rows=10,624 loops=1)

  • Join Filter: ((gra."primary" OR ((count(gra_1.response_action_id)) = 1)) AND (an.grammar_id = gra_1.grammar_id))
  • Rows Removed by Join Filter: 396,422,472
18. 12.173 4,624.341 ↓ 11,248.0 11,248 1

Nested Loop (cost=13.77..7,466.76 rows=1 width=228) (actual time=3,220.073..4,624.341 rows=11,248 loops=1)

19. 8.831 4,589.672 ↓ 11,248.0 11,248 1

Nested Loop (cost=13.34..7,466.31 rows=1 width=196) (actual time=3,220.063..4,589.672 rows=11,248 loops=1)

20. 7.320 4,547.097 ↓ 11,248.0 11,248 1

Nested Loop (cost=12.91..7,465.67 rows=1 width=148) (actual time=3,220.053..4,547.097 rows=11,248 loops=1)

21. 11.711 4,524.057 ↓ 3,144.0 3,144 1

Nested Loop (cost=12.48..7,263.86 rows=1 width=148) (actual time=3,220.040..4,524.057 rows=3,144 loops=1)

22. 13.505 4,500.090 ↓ 12,256.0 12,256 1

Nested Loop (cost=12.19..7,263.48 rows=1 width=148) (actual time=376.260..4,500.090 rows=12,256 loops=1)

23. 1.028 4,463.025 ↓ 23,560.0 23,560 1

Nested Loop (cost=11.92..7,263.18 rows=1 width=164) (actual time=376.064..4,463.025 rows=23,560 loops=1)

24. 7.210 4,414.877 ↓ 23,560.0 23,560 1

Nested Loop (cost=11.50..7,262.72 rows=1 width=147) (actual time=376.053..4,414.877 rows=23,560 loops=1)

  • Join Filter: (an.grammar_id = messages.grammar_id)
25. 5.893 4,356.979 ↓ 1,949.5 25,344 1

Nested Loop (cost=11.07..7,255.90 rows=13 width=99) (actual time=376.042..4,356.979 rows=25,344 loops=1)

26. 4.375 4,339.564 ↓ 1,646.0 1,646 1

Nested Loop (cost=10.64..7,253.95 rows=1 width=72) (actual time=376.028..4,339.564 rows=1,646 loops=1)

  • Join Filter: (wk.channel_id = ch.id)
  • Rows Removed by Join Filter: 11,548
27. 2,589.340 4,333.543 ↓ 1,646.0 1,646 1

Nested Loop (cost=10.64..7,237.87 rows=1 width=80) (actual time=376.015..4,333.543 rows=1,646 loops=1)

  • Join Filter: (gr.id = an.grammar_id)
  • Rows Removed by Join Filter: 36,168,085
28. 50.637 50.637 ↓ 1.8 40,323 1

Index Scan using idx_25088_primary on analyses an (cost=0.42..6,863.02 rows=22,490 width=32) (actual time=0.011..50.637 rows=40,323 loops=1)

  • Filter: (approved AND approved_for_reporting)
  • Rows Removed by Filter: 113,560
29. 1,584.387 1,693.566 ↓ 897.0 897 40,323

Materialize (cost=10.22..37.51 rows=1 width=48) (actual time=0.000..0.042 rows=897 loops=40,323)

30. 0.555 109.179 ↓ 897.0 897 1

Nested Loop (cost=10.22..37.50 rows=1 width=48) (actual time=5.790..109.179 rows=897 loops=1)

31. 0.020 104.516 ↓ 1,027.0 1,027 1

Nested Loop (cost=9.80..17.74 rows=1 width=48) (actual time=5.780..104.516 rows=1,027 loops=1)

32. 0.492 102.442 ↓ 1,027.0 1,027 1

Nested Loop (cost=9.51..15.23 rows=1 width=40) (actual time=5.771..102.442 rows=1,027 loops=1)

33. 9.760 100.923 ↓ 1,027.0 1,027 1

Nested Loop (cost=9.24..12.73 rows=1 width=32) (actual time=5.765..100.923 rows=1,027 loops=1)

34. 12.755 62.683 ↓ 28,480.0 28,480 1

Nested Loop (cost=8.94..12.27 rows=1 width=24) (actual time=5.326..62.683 rows=28,480 loops=1)

35. 16.505 21.448 ↓ 28,480.0 28,480 1

Bitmap Heap Scan on workspaces wk (cost=8.65..9.77 rows=1 width=24) (actual time=5.318..21.448 rows=28,480 loops=1)

  • Recheck Cond: ((phase_type = 'exploration'::text) AND (build_state = 'workable'::text))
  • Filter: (opt_in AND (NOT exclude_from_reporting))
  • Rows Removed by Filter: 52
  • Heap Blocks: exact=3,610
36. 0.120 4.943 ↓ 0.0 0 1

BitmapAnd (cost=8.65..8.65 rows=1 width=0) (actual time=4.943..4.943 rows=0 loops=1)

37. 1.792 1.792 ↓ 131.7 30,035 1

Bitmap Index Scan on idx_26018_index_workspaces_on_phase_type (cost=0.00..4.20 rows=228 width=0) (actual time=1.792..1.792 rows=30,035 loops=1)

  • Index Cond: (phase_type = 'exploration'::text)
38. 3.031 3.031 ↓ 240.7 54,877 1

Bitmap Index Scan on idx_26018_index_workspaces_on_build_state (cost=0.00..4.20 rows=228 width=0) (actual time=3.031..3.031 rows=54,877 loops=1)

  • Index Cond: (build_state = 'workable'::text)
39. 28.480 28.480 ↑ 1.0 1 28,480

Index Scan using index_sensei_experiments_on_id on sensei_experiments exp (cost=0.29..2.51 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=28,480)

  • Index Cond: (id = wk.experiment_id)
40. 28.480 28.480 ↓ 0.0 0 28,480

Index Scan using idx_25121_primary on campaigns cmp (cost=0.29..0.45 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=28,480)

  • Index Cond: (id = exp.campaign_id)
  • Filter: (client_id = 177)
  • Rows Removed by Filter: 1
41. 1.027 1.027 ↑ 1.0 1 1,027

Index Scan using idx_25162_primary on clients (cost=0.28..2.50 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=1,027)

  • Index Cond: (id = 177)
42. 2.054 2.054 ↑ 1.0 1 1,027

Index Only Scan using idx_25874_index_segment_groups_on_workspace_id on segment_groups sg (cost=0.29..2.51 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,027)

  • Index Cond: (workspace_id = wk.id)
  • Heap Fetches: 1,026
43. 4.108 4.108 ↑ 5.0 1 1,027

Index Scan using idx_25557_index_grammars_on_workspace_id on grammars gr (cost=0.42..19.71 rows=5 width=16) (actual time=0.003..0.004 rows=1 loops=1,027)

  • Index Cond: (workspace_id = sg.workspace_id)
  • Filter: (state = 'analyzed'::text)
  • Rows Removed by Filter: 3
44. 1.646 1.646 ↑ 33.8 8 1,646

Seq Scan on channels ch (cost=0.00..12.70 rows=270 width=8) (actual time=0.001..0.001 rows=8 loops=1,646)

45. 11.522 11.522 ↓ 1.2 15 1,646

Index Scan using index_message_metrics_on_analysis_id on message_metrics (cost=0.43..1.82 rows=13 width=35) (actual time=0.003..0.007 rows=15 loops=1,646)

  • Index Cond: (analysis_id = an.id)
46. 50.688 50.688 ↑ 1.0 1 25,344

Index Scan using idx_25659_primary on messages (cost=0.43..0.51 rows=1 width=48) (actual time=0.002..0.002 rows=1 loops=25,344)

  • Index Cond: (id = message_metrics.message_id)
  • Filter: (message_grammar_type IS NULL)
  • Rows Removed by Filter: 0
47. 47.120 47.120 ↑ 8.0 1 23,560

Index Scan using idx_3241_grammar_id_response_action_id on grammar_response_actions gra (cost=0.42..0.67 rows=8 width=17) (actual time=0.002..0.002 rows=1 loops=23,560)

  • Index Cond: ((grammar_id = an.grammar_id) AND (response_action_id = an.response_action_id))
48. 23.560 23.560 ↑ 1.0 1 23,560

Index Scan using idx_25820_primary on response_actions ra (cost=0.28..0.30 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=23,560)

  • Index Cond: (id = an.response_action_id)
  • Filter: (kind = 'instant'::text)
  • Rows Removed by Filter: 0
49. 12.256 12.256 ↓ 0.0 0 12,256

Index Scan using idx_25722_primary on performance_queries pq (cost=0.29..0.38 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=12,256)

  • Index Cond: (id = an.performance_query_id)
  • Filter: ((start_date >= '2019-01-28 00:00:00'::timestamp without time zone) AND (start_date <= '2020-06-26 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1
50. 15.720 15.720 ↑ 1,779.8 4 3,144

Index Scan using idx_25668_index_message_gene_values_on_message_id on message_gene_values mgv (cost=0.43..130.62 rows=7,119 width=16) (actual time=0.004..0.005 rows=4 loops=3,144)

  • Index Cond: (message_id = messages.id)
51. 33.744 33.744 ↑ 1.0 1 11,248

Index Scan using idx_25507_primary on gene_values (cost=0.43..0.64 rows=1 width=48) (actual time=0.003..0.003 rows=1 loops=11,248)

  • Index Cond: (id = mgv.gene_value_id)
52. 22.496 22.496 ↑ 1.0 1 11,248

Index Scan using idx_25486_primary on genes (cost=0.42..0.44 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=11,248)

  • Index Cond: (id = gene_values.gene_id)
53. 51,493.012 51,515.840 ↓ 176.2 35,245 11,248

HashAggregate (cost=2,305.08..2,307.08 rows=200 width=16) (actual time=0.004..4.580 rows=35,245 loops=11,248)

  • Group Key: gra_1.grammar_id
54. 6.701 22.828 ↓ 41.7 68,779 1

Nested Loop (cost=20.70..2,296.83 rows=1,649 width=16) (actual time=0.116..22.828 rows=68,779 loops=1)

55. 0.016 0.027 ↓ 4.6 23 1

Bitmap Heap Scan on response_actions ra_1 (cost=1.41..6.78 rows=5 width=8) (actual time=0.016..0.027 rows=23 loops=1)

  • Recheck Cond: (kind = 'instant'::text)
  • Heap Blocks: exact=9
56. 0.011 0.011 ↓ 4.6 23 1

Bitmap Index Scan on idx_25820_index_response_actions_on_kind (cost=0.00..1.41 rows=5 width=0) (actual time=0.011..0.011 rows=23 loops=1)

  • Index Cond: (kind = 'instant'::text)
57. 13.110 16.100 ↓ 1.9 2,990 23

Bitmap Heap Scan on grammar_response_actions gra_1 (cost=19.29..442.18 rows=1,583 width=16) (actual time=0.149..0.700 rows=2,990 loops=23)

  • Recheck Cond: (response_action_id = ra_1.id)
  • Heap Blocks: exact=4,331
58. 2.990 2.990 ↓ 1.9 2,990 23

Bitmap Index Scan on index_grammar_response_actions_on_response_action_id (cost=0.00..18.89 rows=1,583 width=0) (actual time=0.130..0.130 rows=2,990 loops=23)

  • Index Cond: (response_action_id = ra_1.id)
59. 42.496 42.496 ↑ 1.0 1 10,624

Index Scan using index_fiscal_dates_on_actual_date_and_client_id on fiscal_dates (cost=0.29..1.86 rows=1 width=132) (actual time=0.004..0.004 rows=1 loops=10,624)

  • Index Cond: ((actual_date = pq.start_date) AND (client_id = 177))
60. 31.872 31.872 ↑ 13.5 2 10,624

Index Only Scan using idx_25143_index_campaign_tags_campaigns_on_campaign_id_and_camp on campaign_tags_campaigns (cost=0.28..0.85 rows=27 width=8) (actual time=0.002..0.003 rows=2 loops=10,624)

  • Index Cond: (campaign_id = cmp.id)
  • Heap Fetches: 21,296
61. 0.000 42.592 ↓ 0.0 0 21,296

Hash Left Join (cost=15.46..85.32 rows=3,465 width=16) (actual time=0.002..0.002 rows=0 loops=21,296)

  • Hash Cond: (etgv.emotional_tag_id = et.id)
62. 42.592 42.592 ↓ 0.0 0 21,296

Index Scan using idx_25323_index_emotional_tags_gene_values_on_gene_value_id on emotional_tags_gene_values etgv (cost=0.42..61.07 rows=3,465 width=16) (actual time=0.002..0.002 rows=0 loops=21,296)

  • Index Cond: (gene_value_id = mgv.gene_value_id)
63. 0.005 0.029 ↑ 6.0 26 1

Hash (cost=13.10..13.10 rows=155 width=8) (actual time=0.028..0.029 rows=26 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
64. 0.024 0.024 ↑ 6.0 26 1

Seq Scan on emotional_tags et (cost=0.00..13.10 rows=155 width=8) (actual time=0.007..0.024 rows=26 loops=1)

  • Filter: (NOT use_in_apollo_only)
  • Rows Removed by Filter: 67
65. 21.296 21.296 ↓ 0.0 0 21,296

Index Scan using idx_25464_index_formatting_tags_gene_values_on_gene_value_id on formatting_tags_gene_values ftgv (cost=0.30..27.60 rows=1,560 width=16) (actual time=0.001..0.001 rows=0 loops=21,296)

  • Index Cond: (gene_value_id = mgv.gene_value_id)
66. 0.010 0.027 ↑ 5.0 72 1

Hash (cost=13.60..13.60 rows=360 width=40) (actual time=0.027..0.027 rows=72 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
67. 0.017 0.017 ↑ 5.0 72 1

Seq Scan on formatting_tags ft (cost=0.00..13.60 rows=360 width=40) (actual time=0.003..0.017 rows=72 loops=1)

68.          

SubPlan (for Hash Left Join)

69. 0.704 24,454.656 ↓ 0.0 0 512

Nested Loop (cost=1.30..113,170.43 rows=1,543 width=0) (actual time=47.763..47.763 rows=0 loops=512)

70. 1.152 24,453.632 ↓ 0.0 0 512

Nested Loop (cost=0.88..113,148.50 rows=1,543 width=8) (actual time=47.761..47.761 rows=0 loops=512)

71. 2,314.240 24,449.024 ↑ 1,560.0 1 512

Merge Join (cost=0.73..112,856.10 rows=1,560 width=16) (actual time=40.403..47.752 rows=1 loops=512)

  • Merge Cond: (gv2.id = ftgv2.gene_value_id)
72. 14,599.168 14,599.168 ↑ 32,476.0 1 512

Index Only Scan using index_gene_values_on_id_and_gene_id_and_position on gene_values gv2 (cost=0.43..104,924.98 rows=32,476 width=16) (actual time=21.167..28.514 rows=1 loops=512)

  • Index Cond: (gene_id = genes.id)
  • Filter: (id <> gene_values.id)
  • Rows Removed by Filter: 1
  • Heap Fetches: 0
73. 7,535.616 7,535.616 ↑ 4.1 75,891 512

Index Scan using idx_25464_index_formatting_tags_gene_values_on_gene_value_id on formatting_tags_gene_values ftgv2 (cost=0.30..7,054.45 rows=311,950 width=16) (actual time=0.007..14.718 rows=75,891 loops=512)

74. 3.456 3.456 ↓ 0.0 0 576

Index Scan using idx_25452_primary on formatting_tags ft2 (cost=0.15..0.19 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=576)

  • Index Cond: (id = ftgv2.formatting_tag_id)
  • Filter: ((id <> ALL ('{130,578}'::bigint[])) AND (118 <> ALL ((concat('{', ancestor_ids, '}'))::integer[])))
  • Rows Removed by Filter: 1
75. 0.128 0.320 ↑ 1.0 1 64

Materialize (cost=0.42..2.65 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=64)

76. 0.192 0.192 ↑ 1.0 1 64

Index Only Scan using idx_25486_primary on genes g2 (cost=0.42..2.64 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=64)

  • Index Cond: (id = genes.id)
  • Heap Fetches: 0
77. 0.448 38.976 ↓ 0.0 0 448

Nested Loop (cost=5,735.23..40,198.04 rows=16,238 width=0) (actual time=0.087..0.087 rows=0 loops=448)

78. 27.558 38.528 ↓ 0.0 0 448

Index Scan using idx_25507_index_gene_values_on_gene_id on gene_values gv3 (cost=5,734.81..39,992.42 rows=16,238 width=8) (actual time=0.086..0.086 rows=0 loops=448)

  • Index Cond: (gene_id = genes.id)
  • Filter: ((id <> gene_values.id) AND (NOT (hashed SubPlan 2)))
  • Rows Removed by Filter: 2
79.          

SubPlan (for Index Scan)

80. 10.970 10.970 ↑ 3.1 101,754 1

Seq Scan on formatting_tags_gene_values (cost=0.00..4,954.50 rows=311,950 width=8) (actual time=0.011..10.970 rows=101,754 loops=1)

81. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.42..2.65 rows=1 width=8) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_25486_primary on genes g3 (cost=0.42..2.64 rows=1 width=8) (never executed)

  • Index Cond: (id = genes.id)
  • Heap Fetches: 0
83. 20.984 64.093 ↓ 1.5 124,142 1

Sort (cost=19,087.73..19,295.90 rows=83,265 width=44) (actual time=56.287..64.093 rows=124,142 loops=1)

  • Sort Key: dir.analysis_id
  • Sort Method: quicksort Memory: 5,439kB
84. 14.932 43.109 ↑ 1.7 50,045 1

Hash Right Join (cost=584.92..12,282.73 rows=83,265 width=44) (actual time=3.077..43.109 rows=50,045 loops=1)

  • Hash Cond: (dim.descriptive_insight_report_id = dir.id)
85. 25.132 25.132 ↑ 1.7 99,932 1

Seq Scan on descriptive_insight_metrics dim (cost=0.00..11,260.60 rows=166,530 width=44) (actual time=0.006..25.132 rows=99,932 loops=1)

  • Filter: include_in_report
  • Rows Removed by Filter: 10,407
86. 1.051 3.045 ↑ 1.4 9,461 1

Hash (cost=424.18..424.18 rows=12,859 width=8) (actual time=3.044..3.045 rows=9,461 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 498kB
87. 1.994 1.994 ↑ 1.4 9,461 1

Seq Scan on descriptive_insight_reports dir (cost=0.00..424.18 rows=12,859 width=8) (actual time=0.011..1.994 rows=9,461 loops=1)

  • Filter: approved_for_reporting
  • Rows Removed by Filter: 10,896
88. 39.246 436.087 ↑ 1.4 462,816 1

Materialize (cost=101,660.36..104,929.06 rows=653,740 width=48) (actual time=349.071..436.087 rows=462,816 loops=1)

89. 276.158 396.841 ↑ 1.4 454,512 1

Sort (cost=101,660.36..103,294.71 rows=653,740 width=48) (actual time=349.068..396.841 rows=454,512 loops=1)

  • Sort Key: dim_able.gene_value_id, dim_able.id, dim_able.tag_type
  • Sort Method: external merge Disk: 19,168kB
90. 39.507 120.683 ↑ 1.4 466,180 1

Subquery Scan on dim_able (cost=0.00..26,735.15 rows=653,740 width=48) (actual time=0.011..120.683 rows=466,180 loops=1)

91. 31.309 81.176 ↑ 1.4 466,180 1

Append (cost=0.00..20,197.75 rows=653,740 width=48) (actual time=0.010..81.176 rows=466,180 loops=1)

92. 49.602 49.602 ↑ 1.4 465,038 1

Seq Scan on descriptive_tags_gene_values dtgv (cost=0.00..10,359.90 rows=652,290 width=48) (actual time=0.009..49.602 rows=465,038 loops=1)

93. 0.116 0.265 ↑ 1.3 1,142 1

Subquery Scan on *SELECT* 2 (cost=0.00..46.25 rows=1,450 width=48) (actual time=0.012..0.265 rows=1,142 loops=1)

94. 0.149 0.149 ↑ 1.3 1,142 1

Seq Scan on custom_tags_gene_values ctgv (cost=0.00..24.50 rows=1,450 width=40) (actual time=0.010..0.149 rows=1,142 loops=1)

95. 81.080 81.080 ↓ 0.0 0 81,080

Index Scan using index_functional_insight_reports_on_analysis_id on functional_insight_reports fir (cost=0.28..0.58 rows=8 width=8) (actual time=0.001..0.001 rows=0 loops=81,080)

  • Index Cond: (analysis_id = an.id)
  • Filter: approved_for_reporting
  • Rows Removed by Filter: 0
96. 0.908 3.695 ↓ 619.5 6,815 1

Hash (cost=166.34..166.34 rows=11 width=12) (actual time=3.694..3.695 rows=6,815 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 357kB
97. 2.787 2.787 ↓ 619.5 6,815 1

Index Scan using index_functional_insight_metrics_on_taggable on functional_insight_metrics fim (cost=0.29..166.34 rows=11 width=12) (actual time=0.021..2.787 rows=6,815 loops=1)

  • Index Cond: ((taggable_type)::text = 'FunctionalTag'::text)
  • Filter: (include_in_report AND (NOT add_on))
  • Rows Removed by Filter: 326
Planning time : 40.715 ms
Execution time : 104,577.482 ms