explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pyAK

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 828.616 ↑ 1.0 20 1

Limit (cost=23,950.85..23,951.05 rows=20 width=627) (actual time=828.544..828.616 rows=20 loops=1)

2. 47.674 828.558 ↑ 788.8 20 1

HashAggregate (cost=23,950.85..24,108.61 rows=15,776 width=627) (actual time=828.542..828.558 rows=20 loops=1)

  • Group Key: coretitles0_.id, coretitles0_.phelix_id, coretitles0_.title, coretitles0_.original_title, coretitles0_.short_title, coretitles0_.product_type, coretitles0_.type, coretitles0_.eidr, coretitles0_.release_year, coretitles0_.parent_id, coretitles0_.updated_at, coretitles0_.created_at, coretitles0_.season_id, coretitles0_.season_name, coretitles0_.season_number, coretitles0_.series_id, coretitles0_.series_name, coretitles0_.title_name_secured, coretitles0_.season_name_secured, coretitles0_.series_name_secured, coretitles0_.order_column, coretitles0_.episode_number, coretitles0_.episode_sequence, coretitles0_.client_name, coretitles0_.client_id, coretitles0_.security_title, coretitles0_.security_short_title, coretitles0_.original_language, coretitles0_.sort_title, coretitles0_.version_number, coretitles0_.row_number
3. 17.805 780.884 ↑ 2.7 35,302 1

Result (cost=12,329.62..16,604.39 rows=94,793 width=627) (actual time=691.680..780.884 rows=35,302 loops=1)

  • One-Time Filter: (NULLIF(NULL::text, ''::text) IS NULL)
4. 59.538 763.079 ↑ 2.7 35,302 1

Merge Right Join (cost=12,329.62..16,604.39 rows=94,793 width=627) (actual time=691.679..763.079 rows=35,302 loops=1)

  • Merge Cond: (view.title_phelix_id = coretitles0_.phelix_id)
  • Filter: ((lower((coretitles0_.title)::text) ~~ '%a%'::text) OR (lower((coretitles0_.season_name)::text) ~~ '%a%'::text) OR (lower((coretitles0_.series_name)::text) ~~ '%a%'::text) OR (lower((coretitles0_.security_title)::text) ~~ '%a%'::text) OR (lower((coretitles0_.security_short_title)::text) ~~ '%a%'::text) OR (lower((view.title_name)::text) ~~ '%a%'::text))
  • Rows Removed by Filter: 5065
5. 8.904 13.856 ↑ 1.0 1,817 1

Sort (cost=223.39..227.93 rows=1,817 width=64) (actual time=13.349..13.856 rows=1,817 loops=1)

  • Sort Key: view.title_phelix_id
  • Sort Method: quicksort Memory: 166kB
6. 0.707 4.952 ↑ 1.0 1,817 1

Subquery Scan on view (cost=88.68..125.02 rows=1,817 width=64) (actual time=3.620..4.952 rows=1,817 loops=1)

7. 1.680 4.245 ↑ 1.0 1,817 1

HashAggregate (cost=88.68..106.85 rows=1,817 width=116) (actual time=3.619..4.245 rows=1,817 loops=1)

  • Group Key: tan.id, (concat('PXALTL-', tan.id)), (concat('PXTL-', tan.title_id)), tan.title_name, tan.updated_at, tan.created_at
8. 0.687 2.565 ↑ 1.0 1,817 1

Append (cost=0.00..61.42 rows=1,817 width=116) (actual time=0.010..2.565 rows=1,817 loops=1)

9. 1.634 1.634 ↑ 1.0 1,597 1

Seq Scan on titles_alternative_names tan (cost=0.00..36.95 rows=1,597 width=91) (actual time=0.010..1.634 rows=1,597 loops=1)

10. 0.092 0.092 ↑ 1.0 74 1

Seq Scan on tv_seasons_alternative_names snan (cost=0.00..2.11 rows=74 width=91) (actual time=0.007..0.092 rows=74 loops=1)

11. 0.152 0.152 ↑ 1.0 146 1

Seq Scan on tv_shows_alternative_names sran (cost=0.00..4.19 rows=146 width=91) (actual time=0.005..0.152 rows=146 loops=1)

12. 178.709 689.685 ↓ 3.9 40,367 1

Sort (cost=12,106.23..12,132.31 rows=10,434 width=627) (actual time=678.308..689.685 rows=40,367 loops=1)

  • Sort Key: coretitles0_.phelix_id
  • Sort Method: quicksort Memory: 13019kB
13. 20.474 510.976 ↓ 3.8 39,838 1

Hash Right Join (cost=11,385.05..11,409.81 rows=10,434 width=627) (actual time=490.567..510.976 rows=39,838 loops=1)

  • Hash Cond: (assigneeal4_.alpha_id = alpha3_.id)
14. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on assignee_alpha_accesses assigneeal4_ (cost=0.00..18.40 rows=840 width=4) (actual time=0.003..0.003 rows=0 loops=1)

15. 27.030 490.499 ↓ 3.8 39,838 1

Hash (cost=11,254.63..11,254.63 rows=10,434 width=631) (actual time=490.499..490.499 rows=39,838 loops=1)

  • Buckets: 65536 (originally 16384) Batches: 1 (originally 1) Memory Usage: 8943kB
16. 26.629 463.469 ↓ 3.8 39,838 1

Merge Left Join (cost=8,404.75..11,254.63 rows=10,434 width=631) (actual time=401.024..463.469 rows=39,838 loops=1)

  • Merge Cond: (coretitles0_.id = alpha3_.title_id)
17. 14.723 420.304 ↓ 3.1 20,888 1

Merge Left Join (cost=8,404.47..8,458.01 rows=6,688 width=627) (actual time=401.001..420.304 rows=20,888 loops=1)

  • Merge Cond: ((coretitles0_.id = assigneeti2_.title_id) AND (coretitles0_.type = (assigneeti2_.title_type)::text))
18. 21.702 405.130 ↓ 3.0 20,372 1

Sort (cost=8,381.10..8,397.82 rows=6,688 width=627) (actual time=400.727..405.130 rows=20,372 loops=1)

  • Sort Key: coretitles0_.id, coretitles0_.type
  • Sort Method: quicksort Memory: 6775kB
19. 9.095 383.428 ↓ 3.0 20,372 1

Subquery Scan on coretitles0_ (cost=5,278.29..7,956.17 rows=6,688 width=627) (actual time=292.483..383.428 rows=20,372 loops=1)

  • Filter: (coretitles0_.version_number >= 0)
20. 22.274 374.333 ↓ 1.0 20,372 1

WindowAgg (cost=5,278.29..7,705.36 rows=20,065 width=627) (actual time=292.481..374.333 rows=20,372 loops=1)

21. 7.754 352.059 ↓ 1.0 20,372 1

Append (cost=5,278.29..7,203.73 rows=20,065 width=623) (actual time=292.470..352.059 rows=20,372 loops=1)

22. 11.779 323.330 ↓ 1.0 18,923 1

Subquery Scan on *SELECT* 1 (cost=5,278.29..6,772.77 rows=18,681 width=485) (actual time=292.469..323.330 rows=18,923 loops=1)

23. 13.494 311.551 ↓ 1.0 18,923 1

Unique (cost=5,278.29..6,585.96 rows=18,681 width=562) (actual time=292.465..311.551 rows=18,923 loops=1)

24. 34.852 298.057 ↓ 1.0 18,929 1

Sort (cost=5,278.29..5,324.99 rows=18,681 width=562) (actual time=292.463..298.057 rows=18,929 loops=1)

  • Sort Key: titles.id, (concat('PXTL-', titles.id)), (CASE WHEN (tc.embargo_release_date > CURRENT_TIMESTAMP) THEN tc.security_title WHEN (titles.title_type = 1) THEN titles.episode_name WHEN (titles.title_type = 0) THEN titles.title ELSE NULL::character varying END), (CASE WHEN (titles.title_type = 1) THEN titles.episode_name WHEN (titles.title_type = 0) THEN titles.title ELSE NULL::character varying END), (CASE WHEN (tc.embargo_release_date > CURRENT_TIMESTAMP) THEN tc.security_short_title WHEN (titles.title_type = 1) THEN titles.short_episode_title WHEN (titles.title_type = 0) THEN titles.short_title ELSE NULL::character varying END), (CASE WHEN (titles.title_type = 1) THEN 'Episode'::text WHEN (titles.title_type = 0) THEN 'Movie'::text ELSE NULL::text END), titles.eidr, titles.release_year, (CASE WHEN (titles.title_type = 1) THEN concat('PXSN-', titles.tv_season_id) WHEN (titles.title_type = 0) THEN NULL::text ELSE NULL::text END), titles.updated_at, titles.created_at, (CASE WHEN (tv_seasons_clients.embargo_release_date > CURRENT_TIMESTAMP) THEN tv_seasons_clients.security_title ELSE tv_seasons.name END), tv_seasons.season_number, (concat('PXSR-', tv_shows.id)), (CASE WHEN (tv_shows_clients.embargo_release_date > CURRENT_TIMESTAMP) THEN tv_shows_clients.security_title ELSE tv_shows.name END), ((tc.embargo_release_date > CURRENT_TIMESTAMP)), ((tv_seasons_clients.embargo_release_date > CURRENT_TIMESTAMP)), ((tv_shows_clients.embargo_release_date > CURRENT_TIMESTAMP)), titles.episode_number, titles.episode_sequence, cl.company, cl.id, tc.security_title, tc.security_short_title, languages.name, titles.sort_title, titles.version_number
  • Sort Method: quicksort Memory: 6433kB
25. 139.897 263.205 ↓ 1.0 18,929 1

HashAggregate (cost=2,365.05..3,952.94 rows=18,681 width=562) (actual time=231.628..263.205 rows=18,929 loops=1)

  • Group Key: titles.id, tc.embargo_release_date, tc.security_title, tc.security_short_title, tv_seasons_clients.embargo_release_date, tv_seasons_clients.security_title, tv_seasons.name, tv_seasons.season_number, tv_shows.id, tv_shows_clients.embargo_release_date, tv_shows_clients.security_title, cl.id, languages.name
26. 59.978 123.308 ↓ 8.5 159,644 1

Hash Left Join (cost=1,178.24..1,757.92 rows=18,681 width=288) (actual time=23.520..123.308 rows=159,644 loops=1)

  • Hash Cond: (titles.tv_season_id = tv_seasons.id)
27. 10.320 58.175 ↓ 1.0 18,699 1

Hash Join (cost=1,050.45..1,536.24 rows=18,566 width=198) (actual time=18.353..58.175 rows=18,699 loops=1)

  • Hash Cond: (tc.client_id = cl.id)
28. 10.406 47.810 ↓ 1.0 18,699 1

Hash Left Join (cost=1,048.23..1,481.46 rows=18,566 width=187) (actual time=18.299..47.810 rows=18,699 loops=1)

  • Hash Cond: (titles.original_language_id = languages.id)
29. 14.743 37.349 ↓ 1.0 18,699 1

Hash Join (cost=1,044.61..1,426.24 rows=18,566 width=178) (actual time=18.231..37.349 rows=18,699 loops=1)

  • Hash Cond: (tc.title_id = titles.id)
30. 4.495 4.495 ↓ 1.0 18,911 1

Seq Scan on titles_clients tc (cost=0.00..332.42 rows=18,742 width=47) (actual time=0.003..4.495 rows=18,911 loops=1)

31. 8.996 18.111 ↓ 1.0 18,817 1

Hash (cost=810.26..810.26 rows=18,748 width=135) (actual time=18.110..18.111 rows=18,817 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 2769kB
32. 9.115 9.115 ↓ 1.0 18,817 1

Seq Scan on titles (cost=0.00..810.26 rows=18,748 width=135) (actual time=0.004..9.115 rows=18,817 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 178
33. 0.029 0.055 ↑ 1.0 72 1

Hash (cost=2.72..2.72 rows=72 width=17) (actual time=0.055..0.055 rows=72 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
34. 0.026 0.026 ↑ 1.0 72 1

Seq Scan on languages (cost=0.00..2.72 rows=72 width=17) (actual time=0.003..0.026 rows=72 loops=1)

35. 0.025 0.045 ↑ 1.0 54 1

Hash (cost=1.54..1.54 rows=54 width=15) (actual time=0.044..0.045 rows=54 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
36. 0.020 0.020 ↑ 1.0 54 1

Seq Scan on clients cl (cost=0.00..1.54 rows=54 width=15) (actual time=0.004..0.020 rows=54 loops=1)

37. 1.358 5.155 ↓ 5.2 3,500 1

Hash (cost=119.41..119.41 rows=671 width=94) (actual time=5.155..5.155 rows=3,500 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 302kB
38. 1.388 3.797 ↓ 5.2 3,500 1

Hash Right Join (cost=93.49..119.41 rows=671 width=94) (actual time=2.239..3.797 rows=3,500 loops=1)

  • Hash Cond: (tv_shows_clients.tv_show_id = tv_shows.id)
39. 0.182 0.182 ↓ 1.0 819 1

Seq Scan on tv_shows_clients (cost=0.00..16.15 rows=815 width=30) (actual time=0.002..0.182 rows=819 loops=1)

40. 0.306 2.227 ↓ 1.1 744 1

Hash (cost=85.15..85.15 rows=667 width=68) (actual time=2.227..2.227 rows=744 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 62kB
41. 0.392 1.921 ↓ 1.1 744 1

Hash Left Join (cost=71.23..85.15 rows=667 width=68) (actual time=1.017..1.921 rows=744 loops=1)

  • Hash Cond: (tv_seasons.tv_show_id = tv_shows.id)
42. 0.402 1.010 ↓ 1.1 744 1

Hash Right Join (cost=31.01..43.16 rows=667 width=47) (actual time=0.489..1.010 rows=744 loops=1)

  • Hash Cond: (tv_seasons_clients.tv_season_id = tv_seasons.id)
43. 0.133 0.133 ↓ 1.0 570 1

Seq Scan on tv_seasons_clients (cost=0.00..10.66 rows=566 width=31) (actual time=0.003..0.133 rows=570 loops=1)

44. 0.233 0.475 ↓ 1.0 671 1

Hash (cost=22.67..22.67 rows=667 width=20) (actual time=0.474..0.475 rows=671 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
45. 0.242 0.242 ↓ 1.0 671 1

Seq Scan on tv_seasons (cost=0.00..22.67 rows=667 width=20) (actual time=0.004..0.242 rows=671 loops=1)

46. 0.273 0.519 ↓ 1.0 814 1

Hash (cost=30.10..30.10 rows=810 width=25) (actual time=0.518..0.519 rows=814 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 54kB
47. 0.246 0.246 ↓ 1.0 814 1

Seq Scan on tv_shows (cost=0.00..30.10 rows=810 width=25) (actual time=0.002..0.246 rows=814 loops=1)

48. 0.414 14.371 ↓ 1.1 630 1

Subquery Scan on *SELECT* 2 (cost=196.00..232.99 rows=569 width=490) (actual time=13.374..14.371 rows=630 loops=1)

49. 0.450 13.957 ↓ 1.1 630 1

Unique (cost=196.00..227.30 rows=569 width=545) (actual time=13.370..13.957 rows=630 loops=1)

50. 2.429 13.507 ↓ 1.1 634 1

Sort (cost=196.00..197.43 rows=569 width=545) (actual time=13.366..13.507 rows=634 loops=1)

  • Sort Key: tv_seasons_1.id, (concat('PXSN-', tv_seasons_1.id)), (CASE WHEN (tsec.embargo_release_date > CURRENT_TIMESTAMP) THEN tsec.security_title ELSE tv_seasons_1.name END), tv_seasons_1.name, (CASE WHEN (tsec.embargo_release_date > CURRENT_TIMESTAMP) THEN tsec.security_short_title ELSE tv_seasons_1.short_title END), tv_seasons_1.eidr, tv_seasons_1.release_year, (concat('PXSR-', tv_seasons_1.tv_show_id)), tv_seasons_1.updated_at, tv_seasons_1.created_at, tv_seasons_1.season_number, (CASE WHEN (tshc.embargo_release_date > CURRENT_TIMESTAMP) THEN tshc.security_title ELSE tv_shows_1.name END), ((tsec.embargo_release_date > CURRENT_TIMESTAMP)), ((tshc.embargo_release_date > CURRENT_TIMESTAMP)), cl_1.company, cl_1.id, tsec.security_title, tsec.security_short_title, languages_1.name, tv_seasons_1.sort_title, tv_seasons_1.version_number
  • Sort Method: quicksort Memory: 222kB
51. 3.300 11.078 ↓ 1.1 634 1

HashAggregate (cost=138.67..169.97 rows=569 width=545) (actual time=9.762..11.078 rows=634 loops=1)

  • Group Key: tsec.embargo_release_date, tv_seasons_1.id, tsec.security_title, tsec.security_short_title, tshc.embargo_release_date, tshc.security_title, tv_shows_1.name, cl_1.id, languages_1.name
52. 1.813 7.778 ↓ 5.8 3,325 1

Hash Left Join (cost=97.80..125.87 rows=569 width=196) (actual time=2.348..7.778 rows=3,325 loops=1)

  • Hash Cond: (tv_seasons_1.original_language_id = languages_1.id)
53. 1.817 5.915 ↓ 5.8 3,325 1

Hash Join (cost=94.18..120.69 rows=569 width=187) (actual time=2.292..5.915 rows=3,325 loops=1)

  • Hash Cond: (tsec.client_id = cl_1.id)
54. 1.636 4.049 ↓ 5.8 3,325 1

Hash Right Join (cost=91.96..116.86 rows=569 width=176) (actual time=2.233..4.049 rows=3,325 loops=1)

  • Hash Cond: (tshc.tv_show_id = tv_shows_1.id)
55. 0.191 0.191 ↓ 1.0 819 1

Seq Scan on tv_shows_clients tshc (cost=0.00..16.15 rows=815 width=30) (actual time=0.003..0.191 rows=819 loops=1)

56. 0.274 2.222 ↓ 1.0 570 1

Hash (cost=84.89..84.89 rows=566 width=154) (actual time=2.222..2.222 rows=570 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 84kB
57. 0.329 1.948 ↓ 1.0 570 1

Hash Left Join (cost=71.23..84.89 rows=566 width=154) (actual time=1.104..1.948 rows=570 loops=1)

  • Hash Cond: (tv_seasons_1.tv_show_id = tv_shows_1.id)
58. 0.396 1.110 ↓ 1.0 570 1

Hash Join (cost=31.01..43.16 rows=566 width=129) (actual time=0.588..1.110 rows=570 loops=1)

  • Hash Cond: (tsec.tv_season_id = tv_seasons_1.id)
59. 0.135 0.135 ↓ 1.0 570 1

Seq Scan on tv_seasons_clients tsec (cost=0.00..10.66 rows=566 width=51) (actual time=0.003..0.135 rows=570 loops=1)

60. 0.286 0.579 ↓ 1.0 671 1

Hash (cost=22.67..22.67 rows=667 width=82) (actual time=0.578..0.579 rows=671 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 73kB
61. 0.293 0.293 ↓ 1.0 671 1

Seq Scan on tv_seasons tv_seasons_1 (cost=0.00..22.67 rows=667 width=82) (actual time=0.004..0.293 rows=671 loops=1)

62. 0.258 0.509 ↓ 1.0 814 1

Hash (cost=30.10..30.10 rows=810 width=25) (actual time=0.509..0.509 rows=814 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 55kB
63. 0.251 0.251 ↓ 1.0 814 1

Seq Scan on tv_shows tv_shows_1 (cost=0.00..30.10 rows=810 width=25) (actual time=0.004..0.251 rows=814 loops=1)

64. 0.021 0.049 ↑ 1.0 54 1

Hash (cost=1.54..1.54 rows=54 width=15) (actual time=0.049..0.049 rows=54 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
65. 0.028 0.028 ↑ 1.0 54 1

Seq Scan on clients cl_1 (cost=0.00..1.54 rows=54 width=15) (actual time=0.011..0.028 rows=54 loops=1)

66. 0.023 0.050 ↑ 1.0 72 1

Hash (cost=2.72..2.72 rows=72 width=17) (actual time=0.050..0.050 rows=72 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
67. 0.027 0.027 ↑ 1.0 72 1

Seq Scan on languages languages_1 (cost=0.00..2.72 rows=72 width=17) (actual time=0.003..0.027 rows=72 loops=1)

68. 0.532 6.604 ↓ 1.0 819 1

Subquery Scan on *SELECT* 3 (cost=153.15..197.98 rows=815 width=507) (actual time=5.359..6.604 rows=819 loops=1)

69. 0.534 6.072 ↓ 1.0 819 1

Unique (cost=153.15..189.83 rows=815 width=515) (actual time=5.357..6.072 rows=819 loops=1)

70. 1.491 5.538 ↓ 1.0 819 1

Sort (cost=153.15..155.19 rows=815 width=515) (actual time=5.356..5.538 rows=819 loops=1)

  • Sort Key: tv_shows_2.id, (concat('PXSR-', tv_shows_2.id)), (CASE WHEN (tshc_1.embargo_release_date > CURRENT_TIMESTAMP) THEN tshc_1.security_title ELSE tv_shows_2.name END), tv_shows_2.name, (CASE WHEN (tshc_1.embargo_release_date > CURRENT_TIMESTAMP) THEN tshc_1.security_short_title ELSE tv_shows_2.short_title END), tv_shows_2.eidr, tv_shows_2.release_year, tv_shows_2.updated_at, tv_shows_2.created_at, ((tshc_1.embargo_release_date > CURRENT_TIMESTAMP)), cl_2.company, cl_2.id, tshc_1.security_title, tshc_1.security_short_title, languages_2.name, tv_shows_2.sort_title, tv_shows_2.version_number
  • Sort Method: quicksort Memory: 264kB
71. 1.631 4.047 ↓ 1.0 819 1

HashAggregate (cost=81.14..113.74 rows=815 width=515) (actual time=3.013..4.047 rows=819 loops=1)

  • Group Key: tshc_1.embargo_release_date, tv_shows_2.id, tshc_1.security_title, tshc_1.security_short_title, cl_2.id, languages_2.name
72. 0.454 2.416 ↓ 1.0 819 1

Hash Left Join (cost=46.06..68.92 rows=815 width=161) (actual time=0.826..2.416 rows=819 loops=1)

  • Hash Cond: (tv_shows_2.original_language_id = languages_2.id)
73. 0.429 1.905 ↓ 1.0 819 1

Hash Join (cost=42.44..63.05 rows=815 width=152) (actual time=0.757..1.905 rows=819 loops=1)

  • Hash Cond: (tshc_1.client_id = cl_2.id)
74. 0.557 1.433 ↓ 1.0 819 1

Hash Join (cost=40.23..58.53 rows=815 width=141) (actual time=0.703..1.433 rows=819 loops=1)

  • Hash Cond: (tshc_1.tv_show_id = tv_shows_2.id)
75. 0.191 0.191 ↓ 1.0 819 1

Seq Scan on tv_shows_clients tshc_1 (cost=0.00..16.15 rows=815 width=45) (actual time=0.002..0.191 rows=819 loops=1)

76. 0.369 0.685 ↓ 1.0 814 1

Hash (cost=30.10..30.10 rows=810 width=100) (actual time=0.684..0.685 rows=814 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 101kB
77. 0.316 0.316 ↓ 1.0 814 1

Seq Scan on tv_shows tv_shows_2 (cost=0.00..30.10 rows=810 width=100) (actual time=0.003..0.316 rows=814 loops=1)

78. 0.022 0.043 ↑ 1.0 54 1

Hash (cost=1.54..1.54 rows=54 width=15) (actual time=0.043..0.043 rows=54 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
79. 0.021 0.021 ↑ 1.0 54 1

Seq Scan on clients cl_2 (cost=0.00..1.54 rows=54 width=15) (actual time=0.005..0.021 rows=54 loops=1)

80. 0.029 0.057 ↑ 1.0 72 1

Hash (cost=2.72..2.72 rows=72 width=17) (actual time=0.057..0.057 rows=72 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
81. 0.028 0.028 ↑ 1.0 72 1

Seq Scan on languages languages_2 (cost=0.00..2.72 rows=72 width=17) (actual time=0.005..0.028 rows=72 loops=1)

82. 0.342 0.451 ↓ 2.3 852 1

Sort (cost=23.36..24.28 rows=368 width=10) (actual time=0.266..0.451 rows=852 loops=1)

  • Sort Key: assigneeti2_.title_id, assigneeti2_.title_type
  • Sort Method: quicksort Memory: 42kB
83. 0.109 0.109 ↓ 1.0 370 1

Seq Scan on assignee_title_accesses assigneeti2_ (cost=0.00..7.68 rows=368 width=10) (actual time=0.005..0.109 rows=370 loops=1)

84. 16.536 16.536 ↓ 1.4 37,761 1

Index Scan using index_alphas_on_title_id on alphas alpha3_ (cost=0.29..2,607.40 rows=27,263 width=8) (actual time=0.019..16.536 rows=37,761 loops=1)