explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9W83

Settings
# exclusive inclusive rows x rows loops node
1. 6.829 3,190.537 ↑ 4.0 62,345 1

Append (cost=13,704.07..54,161.68 rows=252,481 width=1,988) (actual time=0.165..3,190.537 rows=62,345 loops=1)

2.          

CTE lineitemvla

3. 6.405 6.405 ↑ 1.0 2,352 1

Seq Scan on audio_lineitem_core a (cost=0.00..1,847.67 rows=2,352 width=275) (actual time=0.007..6.405 rows=2,352 loops=1)

  • Filter: (active_flag AND (ml_audiofile_scores_json IS NOT NULL))
  • Rows Removed by Filter: 115
4.          

CTE msss

5. 0.000 0.072 ↓ 0.0 0 1

Unique (cost=857.81..857.99 rows=8 width=271) (actual time=0.072..0.072 rows=0 loops=1)

6. 0.038 0.072 ↓ 0.0 0 1

Sort (cost=857.81..857.83 rows=8 width=271) (actual time=0.071..0.072 rows=0 loops=1)

  • Sort Key: vw_ml_segment_scores_searchpack.audiofile_id, vw_ml_segment_scores_searchpack.bu_id, vw_ml_segment_scores_searchpack.target_type, vw_ml_segment_scores_searchpack.target_value, vw_ml_segment_scores_searchpack.model_id, vw_ml_segment_scores_searchpack.model_name, vw_ml_segment_scores_searchpack.version, vw_ml_segment_scores_searchpack.threshold_met_flag
  • Sort Method: quicksort Memory: 25kB
7. 0.001 0.034 ↓ 0.0 0 1

Subquery Scan on vw_ml_segment_scores_searchpack (cost=857.11..857.69 rows=8 width=271) (actual time=0.033..0.034 rows=0 loops=1)

8. 0.001 0.033 ↓ 0.0 0 1

GroupAggregate (cost=857.11..857.61 rows=8 width=552) (actual time=0.033..0.033 rows=0 loops=1)

  • Group Key: sr.file_id, ((af.duration / '1000'::double precision)), af.filename, hits.time_from, hits.time_to, hits.audiofile_id, cat.category
9. 0.014 0.032 ↓ 0.0 0 1

Sort (cost=857.11..857.13 rows=8 width=273) (actual time=0.032..0.032 rows=0 loops=1)

  • Sort Key: sr.file_id, ((af.duration / '1000'::double precision)), af.filename, hits.time_from, hits.time_to, hits.audiofile_id, cat.category
  • Sort Method: quicksort Memory: 25kB
10. 0.000 0.018 ↓ 0.0 0 1

Nested Loop Left Join (cost=30.50..856.99 rows=8 width=273) (actual time=0.018..0.018 rows=0 loops=1)

  • Join Filter: (CASE WHEN ((cat.category)::text = ANY ('{8-positive_emotion,3-joy}'::text[])) THEN 'happiness_emotion'::text ELSE (regexp_replace((cat.category)::text, '\d+-'::text, ''::text) || '_emotion'::text) END = (wmt.model_name)::text)
11. 0.001 0.018 ↓ 0.0 0 1

Nested Loop Left Join (cost=30.22..849.59 rows=8 width=292) (actual time=0.017..0.018 rows=0 loops=1)

12. 0.000 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=29.94..845.51 rows=8 width=218) (actual time=0.017..0.017 rows=0 loops=1)

13. 0.007 0.017 ↓ 0.0 0 1

Hash Join (cost=29.66..840.33 rows=8 width=174) (actual time=0.017..0.017 rows=0 loops=1)

  • Hash Cond: (sp_2.category_id = cat.id)
14. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=16.84..826.80 rows=260 width=32) (never executed)

  • Hash Cond: (hits.search_phrase_id = sp_2.id)
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on search_phrase_segment hits (cost=0.00..759.23 rows=18,223 width=32) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Hash (cost=16.82..16.82 rows=1 width=8) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on search_phrase sp_2 (cost=0.00..16.82 rows=1 width=8) (never executed)

  • Filter: ((handcrafted_phrase)::text <> ALL ('{see,kind,worries,ready,feel,afraid,honest,hopefully,stop,better,understand,care,family,sense,face,friend,feeling,wish,friends,understanding,trust,content,empty,honestly,empty,evidence,dark,serious,carefully,feels,pride,families,affect,facing,feelings,reasonably,respect,confident,uncertainty,reasons,seriously,freedom,scared,loss,genuine,assure,contents,kindly,faces,forgive,hopes,comfort,bonds,careful,alert,determine,overcome,faith,reject,alive,bond,gladly,wishing,anticipate,relief,rejected,confidence,assurance,wishes,losses}'::text[]))
18. 0.000 0.010 ↓ 0.0 0 1

Hash (cost=12.76..12.76 rows=5 width=150) (actual time=0.010..0.010 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
19. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on search_phrase_category cat (cost=0.00..12.76 rows=5 width=150) (actual time=0.009..0.010 rows=0 loops=1)

  • Filter: ((category)::text = ANY ('{8-positive_emotion,4-sadness,2-fear,3-joy,1-anger}'::text[]))
  • Rows Removed by Filter: 5
20. 0.000 0.000 ↓ 0.0 0

Index Scan using alembic_pk_audiofile on audiofile af (cost=0.28..0.65 rows=1 width=48) (never executed)

  • Index Cond: (hits.audiofile_id = id)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using alembic_uq_spdra_run_correlation_id on spdra_run sr (cost=0.28..0.51 rows=1 width=74) (never executed)

  • Index Cond: ((af.filename)::text = (correlation_id)::text)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using alembic_uq_workflow_model_thresholds_workflow_id on workflow_model_thresholds wmt (cost=0.27..0.58 rows=17 width=51) (never executed)

  • Index Cond: ((sr.workflow_id)::text = (workflow_id)::text)
23.          

CTE mscdata

24. 875.383 2,133.644 ↓ 18.9 3,778 1

HashAggregate (cost=10,982.11..10,985.11 rows=200 width=548) (actual time=1,965.143..2,133.644 rows=3,778 loops=1)

  • Group Key: msc.correlation_id
25.          

CTE msc

26. 605.433 1,075.545 ↓ 2.9 10,788 1

GroupAggregate (cost=9,544.43..10,774.26 rows=3,779 width=193) (actual time=436.072..1,075.545 rows=10,788 loops=1)

  • Group Key: mesc.correlation_id, (lower((mesc.identifier)::text)), mesc.name, mesc.category, mesc.description, mesc.total_score
27. 165.823 470.112 ↑ 1.0 39,101 1

Sort (cost=9,544.43..9,642.19 rows=39,105 width=210) (actual time=435.966..470.112 rows=39,101 loops=1)

  • Sort Key: mesc.correlation_id, (lower((mesc.identifier)::text)), mesc.name, mesc.category, mesc.description, mesc.total_score
  • Sort Method: external merge Disk: 14,152kB
28. 25.598 304.289 ↑ 1.0 39,101 1

Nested Loop (cost=441.08..2,550.68 rows=39,105 width=210) (actual time=5.550..304.289 rows=39,101 loops=1)

29. 17.481 44.085 ↑ 1.0 39,101 1

Hash Join (cost=441.08..1,670.82 rows=39,105 width=309) (actual time=5.515..44.085 rows=39,101 loops=1)

  • Hash Cond: (mesi.media_score_card_id = mesc.id)
30. 21.191 21.191 ↑ 1.0 39,101 1

Seq Scan on media_score_item mesi (cost=0.00..1,127.05 rows=39,105 width=165) (actual time=0.033..21.191 rows=39,101 loops=1)

31. 3.203 5.413 ↑ 1.0 11,334 1

Hash (cost=299.37..299.37 rows=11,337 width=152) (actual time=5.413..5.413 rows=11,334 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,520kB
32. 2.210 2.210 ↑ 1.0 11,334 1

Seq Scan on media_score_card mesc (cost=0.00..299.37 rows=11,337 width=152) (actual time=0.005..2.210 rows=11,334 loops=1)

33. 234.606 234.606 ↑ 1.0 1 39,101

Function Scan on row_to_json b (cost=0.00..0.01 rows=1 width=32) (actual time=0.005..0.006 rows=1 loops=39,101)

34. 10.516 1,258.261 ↓ 2.9 10,788 1

Nested Loop (cost=0.00..151.16 rows=3,779 width=580) (actual time=436.132..1,258.261 rows=10,788 loops=1)

35. 1,107.501 1,107.501 ↓ 2.9 10,788 1

CTE Scan on msc (cost=0.00..75.58 rows=3,779 width=1,120) (actual time=436.095..1,107.501 rows=10,788 loops=1)

36. 140.244 140.244 ↑ 1.0 1 10,788

Function Scan on row_to_json a_1 (cost=0.00..0.01 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=10,788)

37. 273.889 408.059 ↑ 8.6 27,220 1

Hash Left Join (cost=13.30..30,930.34 rows=235,200 width=1,988) (actual time=0.165..408.059 rows=27,220 loops=1)

  • Hash Cond: (((vla.bu_id)::text = (butvm.bu_id)::text) AND (((model_entry.value #> '{score_rank,1}'::text[]) ->> 'model_name'::text) = (butvm.model_name)::text) AND (((model_entry.value #> '{score_rank,1}'::text[]) ->> 'version'::text) = (butvm.version)::text) AND (((model_entry.value #> '{score_rank,1}'::text[]) ->> 'target_value'::text) = (butvm.target_value)::text))
38. 9.786 134.169 ↑ 8.6 27,220 1

Nested Loop (cost=0.00..4,751.04 rows=235,200 width=1,866) (actual time=0.133..134.169 rows=27,220 loops=1)

39. 11.487 11.487 ↑ 1.0 2,352 1

CTE Scan on lineitemvla vla (cost=0.00..47.04 rows=2,352 width=1,834) (actual time=0.010..11.487 rows=2,352 loops=1)

40. 112.896 112.896 ↑ 8.3 12 2,352

Function Scan on jsonb_each model_entry (cost=0.00..1.00 rows=100 width=64) (actual time=0.046..0.048 rows=12 loops=2,352)

41. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=11.10..11.10 rows=110 width=674) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
42. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on business_unit_target_value_mapping butvm (cost=0.00..11.10 rows=110 width=674) (actual time=0.001..0.001 rows=0 loops=1)

43. 0.000 0.086 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=13.08..70.56 rows=59 width=1,988) (actual time=0.086..0.086 rows=0 loops=1)

44. 0.008 0.086 ↓ 0.0 0 1

Hash Join (cost=13.08..69.83 rows=59 width=2,098) (actual time=0.086..0.086 rows=0 loops=1)

  • Hash Cond: (vla_1.id = msss.audiofile_id)
45. 0.000 0.000 ↑ 2,352.0 1 1

CTE Scan on lineitemvla vla_1 (cost=0.00..47.04 rows=2,352 width=1,712) (actual time=0.000..0.000 rows=1 loops=1)

46. 0.000 0.078 ↓ 0.0 0 1

Hash (cost=13.02..13.02 rows=5 width=500) (actual time=0.078..0.078 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
47. 0.005 0.078 ↓ 0.0 0 1

Hash Right Join (cost=0.26..13.02 rows=5 width=500) (actual time=0.078..0.078 rows=0 loops=1)

  • Hash Cond: (((butvm_1.bu_id)::text = (msss.bu_id)::text) AND ((butvm_1.model_name)::text = msss.model_name) AND ((butvm_1.version)::text = (msss.version)::text) AND ((butvm_1.target_value)::text = msss.target_value))
48. 0.000 0.000 ↓ 0.0 0

Seq Scan on business_unit_target_value_mapping butvm_1 (cost=0.00..11.10 rows=110 width=674) (never executed)

49. 0.001 0.073 ↓ 0.0 0 1

Hash (cost=0.16..0.16 rows=5 width=354) (actual time=0.073..0.073 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
50. 0.072 0.072 ↓ 0.0 0 1

CTE Scan on msss (cost=0.00..0.16 rows=5 width=354) (actual time=0.072..0.072 rows=0 loops=1)

  • Filter: ((threshold_type_flag AND threshold_met_flag) OR (NOT threshold_type_flag))
51. 1.504 1.889 ↑ 1.0 2,352 1

Hash Left Join (cost=9.54..92.29 rows=2,352 width=1,988) (actual time=0.027..1.889 rows=2,352 loops=1)

  • Hash Cond: ((vla_2.bu_id)::text = (butvm_2.bu_id)::text)
52. 0.379 0.379 ↑ 1.0 2,352 1

CTE Scan on lineitemvla vla_2 (cost=0.00..47.04 rows=2,352 width=1,810) (actual time=0.002..0.379 rows=2,352 loops=1)

53. 0.000 0.006 ↓ 0.0 0 1

Hash (cost=9.53..9.53 rows=1 width=236) (actual time=0.006..0.006 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
54. 0.006 0.006 ↓ 0.0 0 1

Index Scan using alembic_uq_business_unit_target_value_mapping_bu_id on business_unit_target_value_mapping butvm_2 (cost=0.14..9.53 rows=1 width=236) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (((model_name)::text = 'vw_agent_quality'::text) AND ((version)::text = '1'::text) AND ((target_value)::text = 'agent_quality'::text))
55. 1.192 1.510 ↑ 1.0 2,352 1

Hash Left Join (cost=9.54..68.77 rows=2,352 width=1,988) (actual time=0.029..1.510 rows=2,352 loops=1)

  • Hash Cond: ((vla_3.bu_id)::text = (butvm_3.bu_id)::text)
56. 0.309 0.309 ↑ 1.0 2,352 1

CTE Scan on lineitemvla vla_3 (cost=0.00..47.04 rows=2,352 width=1,810) (actual time=0.001..0.309 rows=2,352 loops=1)

57. 0.000 0.009 ↓ 0.0 0 1

Hash (cost=9.53..9.53 rows=1 width=236) (actual time=0.009..0.009 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
58. 0.009 0.009 ↓ 0.0 0 1

Index Scan using alembic_uq_business_unit_target_value_mapping_bu_id on business_unit_target_value_mapping butvm_3 (cost=0.14..9.53 rows=1 width=236) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (((model_name)::text = 'vw_customer_engagement'::text) AND ((version)::text = '1'::text) AND ((target_value)::text = 'customer_engagement'::text))
59. 0.944 2,426.405 ↑ 1.0 2,352 1

Subquery Scan on *SELECT* 5 (cost=16.04..281.07 rows=2,352 width=1,988) (actual time=2,178.514..2,426.405 rows=2,352 loops=1)

60. 222.627 2,425.461 ↑ 1.0 2,352 1

Hash Left Join (cost=16.04..251.67 rows=2,352 width=1,984) (actual time=2,178.512..2,425.461 rows=2,352 loops=1)

  • Hash Cond: ((vla_4.bu_id)::text = (butvm_4.bu_id)::text)
61. 24.011 2,202.823 ↑ 1.0 2,352 1

Hash Left Join (cost=6.50..141.74 rows=2,352 width=1,834) (actual time=2,178.484..2,202.823 rows=2,352 loops=1)

  • Hash Cond: ((vla_4.correlation_id)::text = (mscd.correlation_id)::text)
62. 0.384 0.384 ↑ 1.0 2,352 1

CTE Scan on lineitemvla vla_4 (cost=0.00..47.04 rows=2,352 width=2,318) (actual time=0.000..0.384 rows=2,352 loops=1)

63. 20.738 2,178.428 ↓ 18.9 3,778 1

Hash (cost=4.00..4.00 rows=200 width=548) (actual time=2,178.428..2,178.428 rows=3,778 loops=1)

  • Buckets: 1,024 (originally 1024) Batches: 8 (originally 1) Memory Usage: 4,092kB
64. 2,157.690 2,157.690 ↓ 18.9 3,778 1

CTE Scan on mscdata mscd (cost=0.00..4.00 rows=200 width=548) (actual time=1,965.151..2,157.690 rows=3,778 loops=1)

65. 0.000 0.011 ↓ 0.0 0 1

Hash (cost=9.53..9.53 rows=1 width=236) (actual time=0.011..0.011 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
66. 0.011 0.011 ↓ 0.0 0 1

Index Scan using alembic_uq_business_unit_target_value_mapping_bu_id on business_unit_target_value_mapping butvm_4 (cost=0.14..9.53 rows=1 width=236) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (((model_name)::text = 'vw_crosstalk_count'::text) AND ((version)::text = '1'::text) AND ((target_value)::text = 'crosstalk_count'::text))
67. 0.726 2.240 ↑ 1.0 2,352 1

Subquery Scan on *SELECT* 6 (cost=9.54..92.29 rows=2,352 width=1,988) (actual time=0.034..2.240 rows=2,352 loops=1)

68. 1.118 1.514 ↑ 1.0 2,352 1

Hash Left Join (cost=9.54..62.89 rows=2,352 width=1,984) (actual time=0.033..1.514 rows=2,352 loops=1)

  • Hash Cond: ((vla_5.bu_id)::text = (butvm_5.bu_id)::text)
69. 0.382 0.382 ↑ 1.0 2,352 1

CTE Scan on lineitemvla vla_5 (cost=0.00..47.04 rows=2,352 width=1,806) (actual time=0.002..0.382 rows=2,352 loops=1)

70. 0.001 0.014 ↓ 0.0 0 1

Hash (cost=9.53..9.53 rows=1 width=236) (actual time=0.013..0.014 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
71. 0.013 0.013 ↓ 0.0 0 1

Index Scan using alembic_uq_business_unit_target_value_mapping_bu_id on business_unit_target_value_mapping butvm_5 (cost=0.14..9.53 rows=1 width=236) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (((model_name)::text = 'vw_emotional_journey'::text) AND ((version)::text = '1'::text) AND ((target_value)::text = 'emotional_journey'::text))
72. 0.914 273.064 ↑ 1.0 2,352 1

Subquery Scan on *SELECT* 7 (cost=16.04..281.07 rows=2,352 width=1,988) (actual time=25.157..273.064 rows=2,352 loops=1)

73. 223.267 272.150 ↑ 1.0 2,352 1

Hash Left Join (cost=16.04..251.67 rows=2,352 width=1,984) (actual time=25.156..272.150 rows=2,352 loops=1)

  • Hash Cond: ((vla_6.bu_id)::text = (butvm_6.bu_id)::text)
74. 23.367 48.872 ↑ 1.0 2,352 1

Hash Left Join (cost=6.50..141.74 rows=2,352 width=1,834) (actual time=25.130..48.872 rows=2,352 loops=1)

  • Hash Cond: ((vla_6.correlation_id)::text = (mscd_1.correlation_id)::text)
75. 0.402 0.402 ↑ 1.0 2,352 1

CTE Scan on lineitemvla vla_6 (cost=0.00..47.04 rows=2,352 width=2,318) (actual time=0.001..0.402 rows=2,352 loops=1)

76. 20.031 25.103 ↓ 18.9 3,778 1

Hash (cost=4.00..4.00 rows=200 width=548) (actual time=25.103..25.103 rows=3,778 loops=1)

  • Buckets: 1,024 (originally 1024) Batches: 8 (originally 1) Memory Usage: 4,092kB
77. 5.072 5.072 ↓ 18.9 3,778 1

CTE Scan on mscdata mscd_1 (cost=0.00..4.00 rows=200 width=548) (actual time=0.040..5.072 rows=3,778 loops=1)

78. 0.000 0.011 ↓ 0.0 0 1

Hash (cost=9.53..9.53 rows=1 width=236) (actual time=0.011..0.011 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
79. 0.011 0.011 ↓ 0.0 0 1

Index Scan using alembic_uq_business_unit_target_value_mapping_bu_id on business_unit_target_value_mapping butvm_6 (cost=0.14..9.53 rows=1 width=236) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (((model_name)::text = 'vw_silent_segments'::text) AND ((version)::text = '1'::text) AND ((target_value)::text = 'silent_segments'::text))
80. 1.056 1.423 ↑ 1.0 2,352 1

Hash Left Join (cost=9.54..62.89 rows=2,352 width=1,988) (actual time=0.033..1.423 rows=2,352 loops=1)

  • Hash Cond: ((vla_7.bu_id)::text = (butvm_7.bu_id)::text)
81. 0.355 0.355 ↑ 1.0 2,352 1

CTE Scan on lineitemvla vla_7 (cost=0.00..47.04 rows=2,352 width=1,803) (actual time=0.002..0.355 rows=2,352 loops=1)

82. 0.000 0.012 ↓ 0.0 0 1

Hash (cost=9.53..9.53 rows=1 width=236) (actual time=0.012..0.012 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
83. 0.012 0.012 ↓ 0.0 0 1

Index Scan using alembic_uq_business_unit_target_value_mapping_bu_id on business_unit_target_value_mapping butvm_7 (cost=0.14..9.53 rows=1 width=236) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (((model_name)::text = 'vw_greeting'::text) AND ((version)::text = '1'::text) AND ((target_value)::text = 'greeting'::text))
84. 1.116 1.415 ↑ 1.0 2,352 1

Hash Left Join (cost=9.54..62.89 rows=2,352 width=1,988) (actual time=0.013..1.415 rows=2,352 loops=1)

  • Hash Cond: ((vla_8.bu_id)::text = (butvm_8.bu_id)::text)
85. 0.295 0.295 ↑ 1.0 2,352 1

CTE Scan on lineitemvla vla_8 (cost=0.00..47.04 rows=2,352 width=1,803) (actual time=0.000..0.295 rows=2,352 loops=1)

86. 0.001 0.004 ↓ 0.0 0 1

Hash (cost=9.53..9.53 rows=1 width=236) (actual time=0.004..0.004 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
87. 0.003 0.003 ↓ 0.0 0 1

Index Scan using alembic_uq_business_unit_target_value_mapping_bu_id on business_unit_target_value_mapping butvm_8 (cost=0.14..9.53 rows=1 width=236) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (((model_name)::text = 'vw_call_resolution'::text) AND ((version)::text = '1'::text) AND ((target_value)::text = 'call_resolution'::text))
88. 2.222 34.221 ↓ 27.2 10,351 1

Subquery Scan on *SELECT* 10 (cost=2,928.51..3,014.63 rows=380 width=1,988) (actual time=20.457..34.221 rows=10,351 loops=1)

89. 10.118 31.999 ↓ 27.2 10,351 1

Merge Join (cost=2,928.51..3,009.88 rows=380 width=1,984) (actual time=20.455..31.999 rows=10,351 loops=1)

  • Merge Cond: ((vla_9.id = vlwsr.audiofile_id) AND ((vla_9.bu_id)::text = (vlwsr.bu_id)::text))
90. 1.594 2.160 ↑ 1.0 2,352 1

Sort (cost=2,019.75..2,025.63 rows=2,352 width=1,802) (actual time=1.854..2.160 rows=2,352 loops=1)

  • Sort Key: vla_9.id, vla_9.bu_id
  • Sort Method: quicksort Memory: 723kB
91. 0.566 0.566 ↑ 1.0 2,352 1

CTE Scan on lineitemvla vla_9 (cost=0.00..47.04 rows=2,352 width=1,802) (actual time=0.001..0.566 rows=2,352 loops=1)

92. 5.887 19.721 ↓ 1.6 10,353 1

Sort (cost=908.76..924.94 rows=6,471 width=15) (actual time=18.587..19.721 rows=10,353 loops=1)

  • Sort Key: vlwsr.audiofile_id, vlwsr.bu_id
  • Sort Method: quicksort Memory: 870kB
93. 1.367 13.834 ↓ 1.6 10,353 1

Subquery Scan on vlwsr (cost=369.74..499.16 rows=6,471 width=15) (actual time=9.083..13.834 rows=10,353 loops=1)

94. 7.856 12.467 ↓ 1.6 10,353 1

HashAggregate (cost=369.74..434.45 rows=6,471 width=121) (actual time=9.082..12.467 rows=10,353 loops=1)

  • Group Key: sp.id, sp.search_pack_name, NULL::integer, NULL::character varying(36), sp.bu_id, maintbl.audiofile_id
95. 3.526 4.611 ↓ 1.6 10,353 1

Hash Join (cost=11.85..272.67 rows=6,471 width=121) (actual time=0.074..4.611 rows=10,353 loops=1)

  • Hash Cond: (maintbl.search_pack_id = sp.id)
96. 1.028 1.028 ↑ 1.0 10,353 1

Seq Scan on audiofile_search_pack_results maintbl (cost=0.00..232.53 rows=10,353 width=8) (actual time=0.009..1.028 rows=10,353 loops=1)

97. 0.016 0.057 ↑ 1.0 65 1

Hash (cost=11.04..11.04 rows=65 width=23) (actual time=0.057..0.057 rows=65 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
98. 0.041 0.041 ↑ 1.0 65 1

Seq Scan on search_pack sp (cost=0.00..11.04 rows=65 width=23) (actual time=0.004..0.041 rows=65 loops=1)

  • Filter: status
  • Rows Removed by Filter: 39
99. 1.836 33.396 ↓ 22.0 8,310 1

Subquery Scan on *SELECT* 11 (cost=2,982.28..3,068.03 rows=378 width=1,988) (actual time=22.519..33.396 rows=8,310 loops=1)

100. 7.944 31.560 ↓ 22.0 8,310 1

Merge Join (cost=2,982.28..3,063.31 rows=378 width=1,984) (actual time=22.517..31.560 rows=8,310 loops=1)

  • Merge Cond: ((vla_10.id = vlwsr_1.audiofile_id) AND ((vla_10.bu_id)::text = (vlwsr_1.bu_id)::text))
101. 2.059 2.919 ↑ 1.0 2,352 1

Sort (cost=2,019.75..2,025.63 rows=2,352 width=1,802) (actual time=2.632..2.919 rows=2,352 loops=1)

  • Sort Key: vla_10.id, vla_10.bu_id
  • Sort Method: quicksort Memory: 723kB
102. 0.860 0.860 ↑ 1.0 2,352 1

CTE Scan on lineitemvla vla_10 (cost=0.00..47.04 rows=2,352 width=1,802) (actual time=0.004..0.860 rows=2,352 loops=1)

103. 4.334 20.697 ↓ 1.3 8,310 1

Sort (cost=962.53..978.62 rows=6,436 width=15) (actual time=19.870..20.697 rows=8,310 loops=1)

  • Sort Key: vlwsr_1.audiofile_id, vlwsr_1.bu_id
  • Sort Method: quicksort Memory: 774kB
104. 1.094 16.363 ↓ 1.3 8,310 1

Subquery Scan on vlwsr_1 (cost=426.67..555.39 rows=6,436 width=15) (actual time=13.127..16.363 rows=8,310 loops=1)

105. 7.384 15.269 ↓ 1.3 8,310 1

HashAggregate (cost=426.67..491.03 rows=6,436 width=24) (actual time=13.126..15.269 rows=8,310 loops=1)

  • Group Key: sc.search_category_id, scat.search_category_name, scat.bu_id, maintbl_1.audiofile_id
106. 3.099 7.885 ↓ 1.5 9,372 1

Hash Join (cost=19.98..362.31 rows=6,436 width=24) (actual time=0.181..7.885 rows=9,372 loops=1)

  • Hash Cond: (sp_1.id = sc.search_pack_id)
107. 3.433 4.689 ↓ 1.6 10,353 1

Hash Join (cost=11.85..272.67 rows=6,471 width=12) (actual time=0.074..4.689 rows=10,353 loops=1)

  • Hash Cond: (maintbl_1.search_pack_id = sp_1.id)
108. 1.200 1.200 ↑ 1.0 10,353 1

Seq Scan on audiofile_search_pack_results maintbl_1 (cost=0.00..232.53 rows=10,353 width=8) (actual time=0.004..1.200 rows=10,353 loops=1)

109. 0.017 0.056 ↑ 1.0 65 1

Hash (cost=11.04..11.04 rows=65 width=4) (actual time=0.056..0.056 rows=65 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
110. 0.039 0.039 ↑ 1.0 65 1

Seq Scan on search_pack sp_1 (cost=0.00..11.04 rows=65 width=4) (actual time=0.005..0.039 rows=65 loops=1)

  • Filter: status
  • Rows Removed by Filter: 39
111. 0.016 0.097 ↓ 1.1 43 1

Hash (cost=7.63..7.63 rows=40 width=24) (actual time=0.097..0.097 rows=43 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
112. 0.019 0.081 ↓ 1.1 43 1

Hash Join (cost=6.05..7.63 rows=40 width=24) (actual time=0.065..0.081 rows=43 loops=1)

  • Hash Cond: (sc.search_category_id = scat.id)
113. 0.021 0.021 ↑ 1.0 45 1

Seq Scan on search_config sc (cost=0.00..1.45 rows=45 width=8) (actual time=0.017..0.021 rows=45 loops=1)

114. 0.015 0.041 ↑ 1.0 44 1

Hash (cost=5.50..5.50 rows=44 width=20) (actual time=0.041..0.041 rows=44 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
115. 0.026 0.026 ↑ 1.0 44 1

Seq Scan on search_category scat (cost=0.00..5.50 rows=44 width=20) (actual time=0.007..0.026 rows=44 loops=1)

  • Filter: status
  • Rows Removed by Filter: 6
Planning time : 6.158 ms
Execution time : 3,218.379 ms