explain.depesz.com

A tool for finding a real cause for slow queries.

Result: MuO

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=969,781,455.62..1,183,030,183.60 rows=4,489,446,905 width=130) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=969,781,455.62..981,005,072.88 rows=4,489,446,905 width=130) (actual time=.. rows= loops=)

  • Sort Key: st.check_number, rd.source_song_id, rd.source_song_title, (regexp_replace((rd.composers)::text, ' '::text, ' '::text, 'g'::text)), rd.publisher_share, l.client_data_8, rd.play_type_id
3. 0.000 0.000 ↓ 0.0

Merge Join (cost=9,134,256.20..87,819,440.68 rows=4,489,446,905 width=130) (actual time=.. rows= loops=)

  • Merge Cond: (rd.report_summary_id = st2.report_summary_id)
4. 0.000 0.000 ↓ 0.0

Sort (cost=9,117,623.19..9,177,555.01 rows=23,972,728 width=132) (actual time=.. rows= loops=)

  • Sort Key: rd.report_summary_id
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,765,988.17..5,312,975.85 rows=23,972,728 width=132) (actual time=.. rows= loops=)

  • Hash Cond: (rd.license_row_id = l.row_id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on report_detail_2011 rd (cost=0.00..1,285,089.28 rows=23,972,728 width=125) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1,221,891.74..1,221,891.74 rows=29,635,874 width=23) (actual time=.. rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on license_part_5818802 l (cost=0.00..1,221,891.74 rows=29,635,874 width=23) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0

Sort (cost=16,633.01..16,982.75 rows=139,893 width=14) (actual time=.. rows= loops=)

  • Sort Key: st2.report_summary_id
10. 0.000 0.000 ↓ 0.0

Merge Join (cost=2,568.22..4,676.38 rows=139,893 width=14) (actual time=.. rows= loops=)

  • Merge Cond: (st.royalty_statement_id = st2.remitted_statement_id)
11. 0.000 0.000 ↓ 0.0

Sort (cost=246.62..251.50 rows=1,953 width=14) (actual time=.. rows= loops=)

  • Sort Key: st.royalty_statement_id
12. 0.000 0.000 ↓ 0.0

Append (cost=0.00..139.87 rows=1,953 width=14) (actual time=.. rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Scan using royalty_statement_admin_payee_co_client on royalty_statement st (cost=0.00..2.56 rows=1 width=40) (actual time=.. rows= loops=)

  • Index Cond: (client_id = 4481502)
14. 0.000 0.000 ↓ 0.0

Index Scan using royalty_statement_pkey on royalty_statement st (cost=0.00..137.31 rows=1,952 width=14) (actual time=.. rows= loops=)

  • Filter: (client_id = 4481502)
15. 0.000 0.000 ↓ 0.0

Sort (cost=2,321.61..2,357.42 rows=14,326 width=16) (actual time=.. rows= loops=)

  • Sort Key: st2.remitted_statement_id
16. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,332.66 rows=14,326 width=16) (actual time=.. rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on royalty_statement st2 (cost=0.00..11.20 rows=120 width=16) (actual time=.. rows= loops=)

18. 0.000 0.000 ↓ 0.0

Index Scan using royalty_statement_ukey on royalty_statement st2 (cost=0.00..132.43 rows=1,952 width=16) (actual time=.. rows= loops=)

19. 0.000 0.000 ↓ 0.0

Index Scan using royalty_statement_ukey on royalty_statement st2 (cost=0.00..439.36 rows=5,193 width=16) (actual time=.. rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Scan using royalty_statement_ukey on royalty_statement st2 (cost=0.00..89.26 rows=918 width=16) (actual time=.. rows= loops=)

21. 0.000 0.000 ↓ 0.0

Index Scan using royalty_statement_ukey on royalty_statement st2 (cost=0.00..418.51 rows=3,820 width=16) (actual time=.. rows= loops=)

22. 0.000 0.000 ↓ 0.0

Index Scan using royalty_statement_ukey on royalty_statement st2 (cost=0.00..241.90 rows=2,323 width=16) (actual time=.. rows= loops=)