explain.depesz.com

A tool for finding a real cause for slow queries.

Result: MuO

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

GroupAggregate (cost=969781455.62..1183030183.60 rows=4489446905 width=130) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Sort (cost=969781455.62..981005072.88 rows=4489446905 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=9134256.20..87819440.68 rows=4489446905 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=9117623.19..9177555.01 rows=23972728 width=132) (actual time=.. rows= loops=)

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

Hash Join (cost=1765988.17..5312975.85 rows=23972728 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..1285089.28 rows=23972728 width=125) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0
→

Hash (cost=1221891.74..1221891.74 rows=29635874 width=23) (actual time=.. rows= loops=)

8. 0.000 0.000 ↓ 0.0
→

Seq Scan on license_part_5818802 l (cost=0.00..1221891.74 rows=29635874 width=23) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0
→

Sort (cost=16633.01..16982.75 rows=139893 width=14) (actual time=.. rows= loops=)

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

Merge Join (cost=2568.22..4676.38 rows=139893 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=1953 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=1953 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=1952 width=14) (actual time=.. rows= loops=)

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

Sort (cost=2321.61..2357.42 rows=14326 width=16) (actual time=.. rows= loops=)

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

Append (cost=0.00..1332.66 rows=14326 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=1952 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=5193 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=3820 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=2323 width=16) (actual time=.. rows= loops=)