explain.depesz.com

A tool for finding a real cause for slow queries.

Result: sdW : dude

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.015 618.494 ↑ 150.0 4 1

Limit (cost=404292.36..404293.86 rows=600 width=197) (actual time=618.477..618.494 rows=4 loops=1)

2. 0.088 618.479 ↑ 718983.8 4 1

Sort (cost=404292.36..411482.20 rows=2875935 width=197) (actual time=618.473..618.479 rows=4 loops=1)

  • Sort Key: (upper(btrim(regexp_replace((COALESCE(w_lic.title, ''::character varying))::text, '\\s+'::text, ' '::text, 'g'::text)))), (upper(btrim(regexp_replace((COALESCE(w_lic.artist, ''::character varying))::text, '\\s+'::text, ' '::text, 'g'::text))))
  • Sort Method: quicksort Memory: 25kB
3. 0.433 618.391 ↑ 718983.8 4 1

Hash Join (cost=73864.42..228445.92 rows=2875935 width=124) (actual time=574.738..618.391 rows=4 loops=1)

  • Hash Cond: (w_lic.client_id = c.company_id)
4.          

CTE w_lic

5. 0.230 55.595 ↑ 718983.8 4 1

Nested Loop (cost=0.00..66836.02 rows=2875935 width=76) (actual time=12.047..55.595 rows=4 loops=1)

  • Join Filter: ((l.client_id = lss.client_id) AND (l.row_id = lss.license_row_id))
6. 0.150 2.385 ↑ 133.2 4 1

Append (cost=0.00..492.36 rows=533 width=12) (actual time=0.799..2.385 rows=4 loops=1)

7. 0.074 0.074 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_source_song_id on license_source_song lss (cost=0.00..5.20 rows=1 width=12) (actual time=0.074..0.074 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
8. 0.024 0.024 ↓ 0.0 0 1

Seq Scan on license_source_song_part_1330102 lss (cost=0.00..1.18 rows=1 width=12) (actual time=0.024..0.024 rows=0 loops=1)

  • Filter: ((end_dt IS NULL) AND (source_song_id = 66294802))
9. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_200041_source_song_id on license_source_song_part_200041 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
10. 0.009 0.009 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_204005_source_song_id on license_source_song_part_204005 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
11. 0.021 0.021 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_21122_source_song_id on license_source_song_part_21122 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
12. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_2158202_source_song_id on license_source_song_part_2158202 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
13. 0.050 0.050 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_218959_source_song_id on license_source_song_part_218959 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.050..0.050 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
14. 0.022 0.022 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_219625_source_song_id on license_source_song_part_219625 lss (cost=0.00..2.39 rows=1 width=12) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
15. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_225389_source_song_id on license_source_song_part_225389 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
16. 0.046 0.046 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_225420_source_song_id on license_source_song_part_225420 lss (cost=0.00..27.10 rows=32 width=12) (actual time=0.046..0.046 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
17. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_225522_source_song_id on license_source_song_part_225522 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
18. 0.037 0.037 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_228151_source_song_id on license_source_song_part_228151 lss (cost=0.00..2.83 rows=3 width=12) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
19. 0.018 0.018 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_228989_source_song_id on license_source_song_part_228989 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
20. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_229151_source_song_id on license_source_song_part_229151 lss (cost=0.00..3.81 rows=3 width=12) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
21. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_229252_source_song_id on license_source_song_part_229252 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
22. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_229771_source_song_id on license_source_song_part_229771 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
23. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_230084_source_song_id on license_source_song_part_230084 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
24. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_231980_source_song_id on license_source_song_part_231980 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
25. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_233502_source_song_id on license_source_song_part_233502 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
26. 0.004 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on license_source_song_part_233777 lss (cost=2.18..2.89 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((end_dt IS NULL) AND (source_song_id IS NOT NULL) AND (source_song_id = 66294802))
27. 0.002 0.009 ↓ 0.0 0 1

BitmapAnd (cost=2.18..2.18 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=1)

28. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on idx_license_source_song_part_233777_end_dt_ssid (cost=0.00..0.96 rows=3 width=0) (actual time=0.007..0.007 rows=0 loops=1)

29. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix__license_source_song_part_233777_source_song_id (cost=0.00..0.97 rows=3 width=0) (actual time=.. rows= loops=0)

  • Index Cond: (source_song_id = 66294802)
30. 0.009 0.009 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_233802_source_song_id on license_source_song_part_233802 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
31. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_233888_source_song_id on license_source_song_part_233888 lss (cost=0.00..2.36 rows=2 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
32. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_2642002_source_song_id on license_source_song_part_2642002 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
33. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_264202_source_song_id on license_source_song_part_264202 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
34. 0.008 0.008 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_270702_source_song_id on license_source_song_part_270702 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
35. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_270712_source_song_id on license_source_song_part_270712 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
36. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_270722_source_song_id on license_source_song_part_270722 lss (cost=0.00..15.30 rows=19 width=12) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
37. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_270732_source_song_id on license_source_song_part_270732 lss (cost=0.00..3.00 rows=3 width=12) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
38. 0.040 0.040 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_272232_source_song_id on license_source_song_part_272232 lss (cost=0.00..7.38 rows=8 width=12) (actual time=0.040..0.040 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
39. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_272242_source_song_id on license_source_song_part_272242 lss (cost=0.00..2.38 rows=2 width=12) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
40. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_272252_source_song_id on license_source_song_part_272252 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
41. 0.009 0.009 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_272262_source_song_id on license_source_song_part_272262 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
42. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_2724302_source_song_id on license_source_song_part_2724302 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
43. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_273343_source_song_id on license_source_song_part_273343 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
44. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_274484_source_song_id on license_source_song_part_274484 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
45. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_274494_source_song_id on license_source_song_part_274494 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
46. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_274504_source_song_id on license_source_song_part_274504 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
47. 0.061 0.061 ↑ 13.0 1 1

Index Scan using ix__license_source_song_part_274604_source_song_id on license_source_song_part_274604 lss (cost=0.00..11.59 rows=13 width=12) (actual time=0.058..0.061 rows=1 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
48. 0.290 0.290 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_274704_source_song_id on license_source_song_part_274704 lss (cost=0.00..22.33 rows=27 width=12) (actual time=0.290..0.290 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
49. 0.022 0.022 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_275505_source_song_id on license_source_song_part_275505 lss (cost=0.00..2.39 rows=1 width=12) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
50. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_275804_source_song_id on license_source_song_part_275804 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
51. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_275808_source_song_id on license_source_song_part_275808 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
52. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_278558_source_song_id on license_source_song_part_278558 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
53. 0.037 0.037 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_278678_source_song_id on license_source_song_part_278678 lss (cost=0.00..2.39 rows=2 width=12) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
54. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_279989_source_song_id on license_source_song_part_279989 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
55. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_281999_source_song_id on license_source_song_part_281999 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
56. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_284024_source_song_id on license_source_song_part_284024 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
57. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_285845_source_song_id on license_source_song_part_285845 lss (cost=0.00..3.09 rows=3 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
58. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_286056_source_song_id on license_source_song_part_286056 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
59. 0.018 0.018 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_300110_source_song_id on license_source_song_part_300110 lss (cost=0.00..2.83 rows=3 width=12) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
60. 0.044 0.044 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_3133502_source_song_id on license_source_song_part_3133502 lss (cost=0.00..36.92 rows=47 width=12) (actual time=0.044..0.044 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
61. 0.027 0.027 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_319903_source_song_id on license_source_song_part_319903 lss (cost=0.00..2.39 rows=1 width=12) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
62. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_320003_source_song_id on license_source_song_part_320003 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
63. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_320103_source_song_id on license_source_song_part_320103 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
64. 0.038 0.038 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_320703_source_song_id on license_source_song_part_320703 lss (cost=0.00..14.63 rows=19 width=12) (actual time=0.038..0.038 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
65. 0.061 0.061 ↑ 28.0 1 1

Index Scan using ix__license_source_song_part_3607502_source_song_id on license_source_song_part_3607502 lss (cost=0.00..23.04 rows=28 width=12) (actual time=0.059..0.061 rows=1 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
66. 0.033 0.033 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_3618602_source_song_id on license_source_song_part_3618602 lss (cost=0.00..4.54 rows=5 width=12) (actual time=0.033..0.033 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
67. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_3621902_source_song_id on license_source_song_part_3621902 lss (cost=0.00..3.07 rows=2 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
68. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_3658702_source_song_id on license_source_song_part_3658702 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
69. 0.022 0.022 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_3713702_source_song_id on license_source_song_part_3713702 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
70. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_3748902_source_song_id on license_source_song_part_3748902 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
71. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_4120102_source_song_id on license_source_song_part_4120102 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
72. 0.062 0.062 ↑ 66.0 1 1

Index Scan using ix__license_source_song_part_4169602_source_song_id on license_source_song_part_4169602 lss (cost=0.00..49.94 rows=66 width=12) (actual time=0.061..0.062 rows=1 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
73. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_4368302_source_song_id on license_source_song_part_4368302 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
74. 0.046 0.046 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_4481502_source_song_id on license_source_song_part_4481502 lss (cost=0.00..10.18 rows=13 width=12) (actual time=0.046..0.046 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
75. 0.035 0.035 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_4503702_source_song_id on license_source_song_part_4503702 lss (cost=0.00..16.03 rows=20 width=12) (actual time=0.035..0.035 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
76. 0.022 0.022 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_4549102_source_song_id on license_source_song_part_4549102 lss (cost=0.00..10.97 rows=13 width=12) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
77. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_4670602_source_song_id on license_source_song_part_4670602 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
78. 0.056 0.056 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_4699702_source_song_id on license_source_song_part_4699702 lss (cost=0.00..6.64 rows=8 width=12) (actual time=0.056..0.056 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
79. 0.038 0.038 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_4990202_source_song_id on license_source_song_part_4990202 lss (cost=0.00..18.95 rows=25 width=12) (actual time=0.038..0.038 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
80. 0.024 0.024 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_5079502_source_song_id on license_source_song_part_5079502 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.024..0.024 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
81. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_5151_source_song_id on license_source_song_part_5151 lss (cost=0.00..2.38 rows=1 width=12) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
82. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_5151802_source_song_id on license_source_song_part_5151802 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
83. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_5213702_source_song_id on license_source_song_part_5213702 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
84. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_800630_source_song_id on license_source_song_part_800630 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
85. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_5756602_source_song_id on license_source_song_part_5756602 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
86. 0.030 0.030 ↓ 0.0 0 1

Seq Scan on license_source_song_part_5749702 lss (cost=0.00..1.05 rows=1 width=12) (actual time=0.030..0.030 rows=0 loops=1)

  • Filter: ((end_dt IS NULL) AND (source_song_id = 66294802))
87. 0.040 0.040 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_200060_source_song_id on license_source_song_part_200060 lss (cost=0.00..2.28 rows=2 width=12) (actual time=0.040..0.040 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
88. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_5355202_source_song_id on license_source_song_part_5355202 lss (cost=0.00..3.12 rows=4 width=12) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
89. 0.018 0.018 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_5428702_source_song_id on license_source_song_part_5428702 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
90. 0.036 0.036 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_273101_source_song_id on license_source_song_part_273101 lss (cost=0.00..9.48 rows=8 width=12) (actual time=0.036..0.036 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
91. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_223719_source_song_id on license_source_song_part_223719 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
92. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_272343_source_song_id on license_source_song_part_272343 lss (cost=0.00..1.67 rows=1 width=12) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
93. 0.063 0.063 ↑ 44.0 1 1

Index Scan using ix__license_source_song_part_5818802_source_song_id on license_source_song_part_5818802 lss (cost=0.00..33.27 rows=44 width=12) (actual time=0.061..0.063 rows=1 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
94. 0.044 0.044 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_5999802_source_song_id on license_source_song_part_5999802 lss (cost=0.00..14.53 rows=17 width=12) (actual time=0.044..0.044 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
95. 0.042 0.042 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_5981602_source_song_id on license_source_song_part_5981602 lss (cost=0.00..24.66 rows=32 width=12) (actual time=0.042..0.042 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
96. 0.023 0.023 ↓ 0.0 0 1

Index Scan using ix__license_source_song_part_6072302_source_song_id on license_source_song_part_6072302 lss (cost=0.00..3.83 rows=4 width=12) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: (source_song_id = 66294802)
  • Filter: (end_dt IS NULL)
97. 0.528 52.980 ↑ 87.0 1 4

Append (cost=0.00..123.17 rows=87 width=72) (actual time=5.181..13.245 rows=1 loops=4)

98. 0.088 0.088 ↓ 0.0 0 4

Index Scan using license_part_pkey on license l (cost=0.00..2.84 rows=1 width=57) (actual time=0.022..0.022 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
99. 0.064 0.064 ↓ 0.0 0 4

Index Scan using license_part_1330102_pkey on license_part_1330102 l (cost=0.00..0.62 rows=1 width=71) (actual time=0.016..0.016 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
100. 0.080 0.080 ↓ 0.0 0 4

Index Scan using license_part_200041_pkey on license_part_200041 l (cost=0.00..1.06 rows=1 width=75) (actual time=0.020..0.020 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
101. 0.080 0.080 ↓ 0.0 0 4

Index Scan using license_part_204005_pkey on license_part_204005 l (cost=0.00..1.09 rows=1 width=54) (actual time=0.020..0.020 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
102. 0.656 0.656 ↓ 0.0 0 4

Index Scan using license_part_21122_pkey on license_part_21122 l (cost=0.00..1.29 rows=1 width=74) (actual time=0.164..0.164 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
103. 0.436 0.436 ↓ 0.0 0 4

Index Scan using license_part_2158202_pkey on license_part_2158202 l (cost=0.00..1.13 rows=1 width=70) (actual time=0.109..0.109 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
104. 0.808 0.808 ↓ 0.0 0 4

Index Scan using license_part_218959_pkey on license_part_218959 l (cost=0.00..1.50 rows=1 width=80) (actual time=0.202..0.202 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
105. 0.112 0.112 ↓ 0.0 0 4

Index Scan using license_part_219625_pkey on license_part_219625 l (cost=0.00..1.47 rows=1 width=70) (actual time=0.028..0.028 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
106. 0.088 0.088 ↓ 0.0 0 4

Index Scan using license_part_225389_pkey on license_part_225389 l (cost=0.00..1.25 rows=1 width=72) (actual time=0.022..0.022 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
107. 0.208 0.208 ↓ 0.0 0 4

Index Scan using license_part_225420_pkey on license_part_225420 l (cost=0.00..1.95 rows=1 width=76) (actual time=0.052..0.052 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
108. 0.624 0.624 ↓ 0.0 0 4

Index Scan using license_part_225522_pkey on license_part_225522 l (cost=0.00..1.35 rows=1 width=76) (actual time=0.156..0.156 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
109. 0.776 0.776 ↓ 0.0 0 4

Index Scan using license_part_228151_pkey on license_part_228151 l (cost=0.00..1.57 rows=1 width=66) (actual time=0.194..0.194 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
110. 0.104 0.104 ↓ 0.0 0 4

Index Scan using license_part_228989_pkey on license_part_228989 l (cost=0.00..1.26 rows=1 width=74) (actual time=0.026..0.026 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
111. 0.164 0.164 ↓ 0.0 0 4

Index Scan using license_part_229151_pkey on license_part_229151 l (cost=0.00..1.60 rows=1 width=65) (actual time=0.041..0.041 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
112. 0.088 0.088 ↓ 0.0 0 4

Index Scan using license_part_229252_pkey on license_part_229252 l (cost=0.00..1.21 rows=1 width=71) (actual time=0.022..0.022 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
113. 1.372 1.372 ↓ 0.0 0 4

Index Scan using license_part_229771_pkey on license_part_229771 l (cost=0.00..1.48 rows=1 width=61) (actual time=0.343..0.343 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
114. 0.084 0.084 ↓ 0.0 0 4

Index Scan using license_part_230084_pkey on license_part_230084 l (cost=0.00..1.22 rows=1 width=70) (actual time=0.021..0.021 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
115. 0.092 0.092 ↓ 0.0 0 4

Index Scan using license_part_231980_pkey on license_part_231980 l (cost=0.00..1.24 rows=1 width=65) (actual time=0.023..0.023 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
116. 0.096 0.096 ↓ 0.0 0 4

Index Scan using license_part_233502_pkey on license_part_233502 l (cost=0.00..1.29 rows=1 width=75) (actual time=0.024..0.024 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
117. 0.064 0.064 ↓ 0.0 0 4

Index Scan using license_part_233777_pkey on license_part_233777 l (cost=0.00..0.62 rows=1 width=79) (actual time=0.016..0.016 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
118. 0.072 0.072 ↓ 0.0 0 4

Index Scan using license_part_233802_pkey on license_part_233802 l (cost=0.00..0.97 rows=1 width=72) (actual time=0.018..0.018 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
119. 0.600 0.600 ↓ 0.0 0 4

Index Scan using license_part_233888_pkey on license_part_233888 l (cost=0.00..1.34 rows=1 width=75) (actual time=0.150..0.150 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
120. 0.452 0.452 ↓ 0.0 0 4

Index Scan using license_part_2642002_pkey on license_part_2642002 l (cost=0.00..1.12 rows=1 width=79) (actual time=0.113..0.113 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
121. 0.064 0.064 ↓ 0.0 0 4

Index Scan using license_part_264202_pkey on license_part_264202 l (cost=0.00..0.97 rows=1 width=77) (actual time=0.016..0.016 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
122. 0.092 0.092 ↓ 0.0 0 4

Index Scan using license_part_270702_pkey on license_part_270702 l (cost=0.00..1.29 rows=1 width=74) (actual time=0.023..0.023 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
123. 0.096 0.096 ↓ 0.0 0 4

Index Scan using license_part_270712_pkey on license_part_270712 l (cost=0.00..1.29 rows=1 width=72) (actual time=0.024..0.024 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
124. 0.648 0.648 ↓ 0.0 0 4

Index Scan using license_part_270722_pkey on license_part_270722 l (cost=0.00..1.44 rows=1 width=62) (actual time=0.162..0.162 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
125. 1.340 1.340 ↓ 0.0 0 4

Index Scan using license_part_270732_pkey on license_part_270732 l (cost=0.00..1.49 rows=1 width=65) (actual time=0.335..0.335 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
126. 1.196 1.196 ↓ 0.0 0 4

Index Scan using license_part_272232_pkey on license_part_272232 l (cost=0.00..1.72 rows=1 width=65) (actual time=0.299..0.299 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
127. 0.744 0.744 ↓ 0.0 0 4

Index Scan using license_part_272242_pkey on license_part_272242 l (cost=0.00..1.44 rows=1 width=64) (actual time=0.186..0.186 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
128. 0.088 0.088 ↓ 0.0 0 4

Index Scan using license_part_272252_pkey on license_part_272252 l (cost=0.00..1.25 rows=1 width=70) (actual time=0.022..0.022 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
129. 0.084 0.084 ↓ 0.0 0 4

Index Scan using license_part_272262_pkey on license_part_272262 l (cost=0.00..1.09 rows=1 width=60) (actual time=0.021..0.021 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
130. 0.072 0.072 ↓ 0.0 0 4

Index Scan using license_part_2724302_pkey on license_part_2724302 l (cost=0.00..1.04 rows=1 width=83) (actual time=0.018..0.018 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
131. 0.888 0.888 ↓ 0.0 0 4

Index Scan using license_part_273101_pkey on license_part_273101 l (cost=0.00..1.64 rows=1 width=80) (actual time=0.222..0.222 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
132. 0.664 0.664 ↓ 0.0 0 4

Index Scan using license_part_273343_pkey on license_part_273343 l (cost=0.00..1.35 rows=1 width=60) (actual time=0.166..0.166 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
133. 0.084 0.084 ↓ 0.0 0 4

Index Scan using license_part_274484_pkey on license_part_274484 l (cost=0.00..1.25 rows=1 width=116) (actual time=0.021..0.021 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
134. 0.080 0.080 ↓ 0.0 0 4

Index Scan using license_part_274494_pkey on license_part_274494 l (cost=0.00..1.29 rows=1 width=101) (actual time=0.020..0.020 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
135. 0.084 0.084 ↓ 0.0 0 4

Index Scan using license_part_274504_pkey on license_part_274504 l (cost=0.00..1.30 rows=1 width=76) (actual time=0.021..0.021 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
136. 0.236 0.236 ↓ 0.0 0 4

Index Scan using license_part_274604_pkey on license_part_274604 l (cost=0.00..1.86 rows=1 width=75) (actual time=0.058..0.059 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
137. 3.252 3.252 ↓ 0.0 0 4

Index Scan using license_part_274704_pkey on license_part_274704 l (cost=0.00..1.98 rows=1 width=77) (actual time=0.813..0.813 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
138. 0.096 0.096 ↓ 0.0 0 4

Index Scan using license_part_275505_pkey on license_part_275505 l (cost=0.00..1.34 rows=1 width=70) (actual time=0.024..0.024 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
139. 0.088 0.088 ↓ 0.0 0 4

Index Scan using license_part_275804_pkey on license_part_275804 l (cost=0.00..1.30 rows=1 width=74) (actual time=0.022..0.022 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
140. 0.724 0.724 ↓ 0.0 0 4

Index Scan using license_part_275808_pkey on license_part_275808 l (cost=0.00..1.36 rows=1 width=72) (actual time=0.181..0.181 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
141. 0.080 0.080 ↓ 0.0 0 4

Index Scan using license_part_278558_pkey on license_part_278558 l (cost=0.00..1.11 rows=1 width=76) (actual time=0.020..0.020 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
142. 0.740 0.740 ↓ 0.0 0 4

Index Scan using license_part_278678_pkey on license_part_278678 l (cost=0.00..1.56 rows=1 width=66) (actual time=0.185..0.185 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
143. 0.600 0.600 ↓ 0.0 0 4

Index Scan using license_part_279989_pkey on license_part_279989 l (cost=0.00..1.29 rows=1 width=78) (actual time=0.150..0.150 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
144. 0.756 0.756 ↓ 0.0 0 4

Index Scan using license_part_281999_pkey on license_part_281999 l (cost=0.00..1.28 rows=1 width=68) (actual time=0.189..0.189 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
145. 0.072 0.072 ↓ 0.0 0 4

Index Scan using license_part_284024_pkey on license_part_284024 l (cost=0.00..1.12 rows=1 width=72) (actual time=0.018..0.018 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
146. 0.652 0.652 ↓ 0.0 0 4

Index Scan using license_part_285845_pkey on license_part_285845 l (cost=0.00..1.50 rows=1 width=62) (actual time=0.163..0.163 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
147. 0.896 0.896 ↓ 0.0 0 4

Index Scan using license_part_286056_pkey on license_part_286056 l (cost=0.00..1.31 rows=1 width=55) (actual time=0.224..0.224 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
148. 0.780 0.780 ↓ 0.0 0 4

Index Scan using license_part_300110_pkey on license_part_300110 l (cost=0.00..1.60 rows=1 width=61) (actual time=0.195..0.195 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
149. 0.724 0.724 ↓ 0.0 0 4

Index Scan using license_part_3133502_pkey on license_part_3133502 l (cost=0.00..2.02 rows=1 width=80) (actual time=0.181..0.181 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
150. 0.560 0.560 ↓ 0.0 0 4

Index Scan using license_part_319903_pkey on license_part_319903 l (cost=0.00..1.22 rows=1 width=73) (actual time=0.140..0.140 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
151. 0.464 0.464 ↓ 0.0 0 4

Index Scan using license_part_320003_pkey on license_part_320003 l (cost=0.00..1.17 rows=1 width=75) (actual time=0.116..0.116 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
152. 0.364 0.364 ↓ 0.0 0 4

Index Scan using license_part_320103_pkey on license_part_320103 l (cost=0.00..1.17 rows=1 width=70) (actual time=0.091..0.091 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
153. 1.236 1.236 ↓ 0.0 0 4

Index Scan using license_part_320703_pkey on license_part_320703 l (cost=0.00..1.74 rows=1 width=62) (actual time=0.309..0.309 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
154. 3.584 3.584 ↓ 0.0 0 4

Index Scan using license_part_3607502_pkey on license_part_3607502 l (cost=0.00..2.14 rows=1 width=76) (actual time=0.895..0.896 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
155. 0.760 0.760 ↓ 0.0 0 4

Index Scan using license_part_3618602_pkey on license_part_3618602 l (cost=0.00..1.56 rows=1 width=65) (actual time=0.190..0.190 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
156. 0.604 0.604 ↓ 0.0 0 4

Index Scan using license_part_3621902_pkey on license_part_3621902 l (cost=0.00..1.41 rows=1 width=60) (actual time=0.151..0.151 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
157. 0.656 0.656 ↓ 0.0 0 4

Index Scan using license_part_3658702_pkey on license_part_3658702 l (cost=0.00..1.50 rows=1 width=116) (actual time=0.164..0.164 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
158. 0.648 0.648 ↓ 0.0 0 4

Index Scan using license_part_3713702_pkey on license_part_3713702 l (cost=0.00..1.39 rows=1 width=76) (actual time=0.162..0.162 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
159. 0.764 0.764 ↓ 0.0 0 4

Index Scan using license_part_3748902_pkey on license_part_3748902 l (cost=0.00..1.33 rows=1 width=73) (actual time=0.191..0.191 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
160. 0.480 0.480 ↓ 0.0 0 4

Index Scan using license_part_4120102_pkey on license_part_4120102 l (cost=0.00..1.20 rows=1 width=73) (actual time=0.120..0.120 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
161. 8.268 8.268 ↓ 0.0 0 4

Index Scan using license_part_4169602_pkey on license_part_4169602 l (cost=0.00..2.63 rows=1 width=77) (actual time=2.066..2.067 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
162. 0.444 0.444 ↓ 0.0 0 4

Index Scan using license_part_4368302_pkey on license_part_4368302 l (cost=0.00..1.11 rows=1 width=62) (actual time=0.111..0.111 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
163. 0.704 0.704 ↓ 0.0 0 4

Index Scan using license_part_4481502_pkey on license_part_4481502 l (cost=0.00..1.79 rows=1 width=81) (actual time=0.176..0.176 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
164. 0.716 0.716 ↓ 0.0 0 4

Index Scan using license_part_4503702_pkey on license_part_4503702 l (cost=0.00..1.90 rows=1 width=81) (actual time=0.179..0.179 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
165. 0.612 0.612 ↓ 0.0 0 4

Index Scan using license_part_4549102_pkey on license_part_4549102 l (cost=0.00..1.62 rows=1 width=66) (actual time=0.153..0.153 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
166. 0.428 0.428 ↓ 0.0 0 4

Index Scan using license_part_4670602_pkey on license_part_4670602 l (cost=0.00..1.18 rows=1 width=45) (actual time=0.107..0.107 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
167. 1.804 1.804 ↓ 0.0 0 4

Index Scan using license_part_4699702_pkey on license_part_4699702 l (cost=0.00..1.68 rows=1 width=85) (actual time=0.451..0.451 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
168. 0.648 0.648 ↓ 0.0 0 4

Index Scan using license_part_4990202_pkey on license_part_4990202 l (cost=0.00..1.84 rows=1 width=68) (actual time=0.162..0.162 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
169. 0.660 0.660 ↓ 0.0 0 4

Index Scan using license_part_5079502_pkey on license_part_5079502 l (cost=0.00..1.39 rows=1 width=68) (actual time=0.165..0.165 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
170. 0.516 0.516 ↓ 0.0 0 4

Index Scan using license_part_5151_pkey on license_part_5151 l (cost=0.00..1.21 rows=1 width=64) (actual time=0.129..0.129 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
171. 0.440 0.440 ↓ 0.0 0 4

Index Scan using license_part_5151802_pkey on license_part_5151802 l (cost=0.00..1.11 rows=1 width=75) (actual time=0.110..0.110 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
172. 0.632 0.632 ↓ 0.0 0 4

Index Scan using license_part_5213702_pkey on license_part_5213702 l (cost=0.00..1.29 rows=1 width=75) (actual time=0.158..0.158 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
173. 0.716 0.716 ↓ 0.0 0 4

Index Scan using license_part_800630_pkey on license_part_800630 l (cost=0.00..1.48 rows=1 width=71) (actual time=0.179..0.179 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
174. 0.408 0.408 ↓ 0.0 0 4

Index Scan using license_part_5355202_pkey on license_part_5355202 l (cost=0.00..1.12 rows=1 width=44) (actual time=0.102..0.102 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
175. 0.500 0.500 ↓ 0.0 0 4

Index Scan using license_part_272343_pkey on license_part_272343 l (cost=0.00..1.29 rows=1 width=64) (actual time=0.125..0.125 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
176. 0.804 0.804 ↓ 0.0 0 4

Index Scan using license_part_5428702_pkey on license_part_5428702 l (cost=0.00..1.49 rows=1 width=58) (actual time=0.201..0.201 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
177. 0.152 0.152 ↓ 0.0 0 4

Index Scan using license_part_5818802_pkey on license_part_5818802 l (cost=0.00..2.25 rows=1 width=79) (actual time=0.038..0.038 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
178. 0.096 0.096 ↓ 0.0 0 4

Index Scan using license_part_5756602_pkey on license_part_5756602 l (cost=0.00..1.27 rows=1 width=62) (actual time=0.024..0.024 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
179. 0.048 0.048 ↓ 0.0 0 4

Index Scan using license_part_5749702_pkey on license_part_5749702 l (cost=0.00..0.62 rows=1 width=67) (actual time=0.012..0.012 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
180. 0.088 0.088 ↓ 0.0 0 4

Index Scan using license_part_223719_pkey on license_part_223719 l (cost=0.00..1.27 rows=1 width=76) (actual time=0.022..0.022 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
181. 0.136 0.136 ↓ 0.0 0 4

Index Scan using license_part_200060_pkey on license_part_200060 l (cost=0.00..1.56 rows=1 width=75) (actual time=0.034..0.034 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
182. 0.132 0.132 ↓ 0.0 0 4

Index Scan using license_part_5999802_pkey on license_part_5999802 l (cost=0.00..1.93 rows=1 width=71) (actual time=0.033..0.033 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
183. 0.136 0.136 ↓ 0.0 0 4

Index Scan using license_part_5981602_pkey on license_part_5981602 l (cost=0.00..1.83 rows=1 width=88) (actual time=0.034..0.034 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
184. 0.116 0.116 ↓ 0.0 0 4

Index Scan using license_part_6072302_pkey on license_part_6072302 l (cost=0.00..1.53 rows=1 width=73) (actual time=0.029..0.029 rows=0 loops=4)

  • Index Cond: (l.row_id = lss.license_row_id)
185. 55.626 55.626 ↑ 718983.8 4 1

CTE Scan on w_lic (cost=0.00..57518.70 rows=2875935 width=108) (actual time=12.055..55.626 rows=4 loops=1)

186. 155.782 562.332 ↓ 1.1 90774 1

Hash (cost=5952.62..5952.62 rows=86062 width=24) (actual time=562.332..562.332 rows=90774 loops=1)

187. 406.550 406.550 ↓ 1.1 90774 1

Seq Scan on company c (cost=0.00..5952.62 rows=86062 width=24) (actual time=0.030..406.550 rows=90774 loops=1)