explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Te

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 200,533.546 ↓ 10.0 10 1

Limit (cost=16,002.31..16,002.32 rows=1 width=1,102) (actual time=200,533.540..200,533.546 rows=10 loops=1)

2.          

CTE album_select

3. 0.378 1.188 ↓ 1,000.0 1,000 1

Limit (cost=0.00..8,765.42 rows=1 width=702) (actual time=0.014..1.188 rows=1,000 loops=1)

4. 0.810 0.810 ↓ 1,000.0 1,000 1

Seq Scan on album (cost=0.00..8,765.42 rows=1 width=702) (actual time=0.013..0.810 rows=1,000 loops=1)

  • Filter: ((create_time >= '0001-01-01 00:00:00+00'::timestamp with time zone) AND (create_time < '2020-05-20 07:46:17.74833+00'::timestamp with time zone) AND (status = 0))
  • Rows Removed by Filter: 34
5. 4.557 200,533.540 ↓ 10.0 10 1

Sort (cost=7,236.89..7,236.90 rows=1 width=1,102) (actual time=200,533.538..200,533.540 rows=10 loops=1)

  • Sort Key: album_select.create_time DESC
  • Sort Method: top-N heapsort Memory: 41kB
6. 137.200 200,528.983 ↓ 991.0 991 1

Nested Loop Left Join (cost=7,198.33..7,236.88 rows=1 width=1,102) (actual time=5,216.976..200,528.983 rows=991 loops=1)

  • Join Filter: (album_select.album_id = album_select_13.album_id)
  • Rows Removed by Join Filter: 495906
7. 109.840 196,526.883 ↓ 991.0 991 1

Nested Loop Left Join (cost=5,881.93..5,920.27 rows=1 width=928) (actual time=5,208.407..196,526.883 rows=991 loops=1)

  • Join Filter: (album_select.album_id = album_select_12.album_id)
  • Rows Removed by Join Filter: 495906
8. 8.053 195,919.561 ↓ 991.0 991 1

Nested Loop (cost=3,207.51..3,245.81 rows=1 width=896) (actual time=5,199.220..195,919.561 rows=991 loops=1)

9. 120.392 195,893.508 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=3,207.10..3,237.37 rows=1 width=888) (actual time=5,199.185..195,893.508 rows=1,000 loops=1)

  • Join Filter: (album_select.album_id = album_select_8.album_id)
  • Rows Removed by Join Filter: 499500
10. 235.392 189,292.116 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=3,060.56..3,090.47 rows=1 width=856) (actual time=2,724.709..189,292.116 rows=1,000 loops=1)

  • Join Filter: (album_select.album_id = album_select_5.album_id)
  • Rows Removed by Join Filter: 999000
11. 9.840 321.724 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=2,914.32..2,944.09 rows=1 width=816) (actual time=210.908..321.724 rows=1,000 loops=1)

  • Join Filter: (album_select.album_id = admin_action_album.album_id)
  • Rows Removed by Join Filter: 8992
12. 5.851 303.884 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=2,914.32..2,922.53 rows=1 width=806) (actual time=210.884..303.884 rows=1,000 loops=1)

  • Join Filter: (album_select.album_id = album_select_4.album_id)
  • Rows Removed by Join Filter: 10934
13. 4.369 172.033 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=2,857.30..2,865.45 rows=1 width=742) (actual time=119.668..172.033 rows=1,000 loops=1)

  • Join Filter: (album_select.album_id = album_select_3.album_id)
  • Rows Removed by Join Filter: 1997
14. 3.718 130.664 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=2,789.43..2,797.55 rows=1 width=734) (actual time=87.723..130.664 rows=1,000 loops=1)

  • Join Filter: (album_select.album_id = album_select_2.album_id)
  • Rows Removed by Join Filter: 1997
15. 9.235 70.946 ↓ 1,000.0 1,000 1

Nested Loop Left Join (cost=2,734.51..2,742.58 rows=1 width=726) (actual time=36.799..70.946 rows=1,000 loops=1)

16. 3.396 41.711 ↓ 1,000.0 1,000 1

Merge Left Join (cost=2,734.09..2,734.14 rows=1 width=710) (actual time=36.779..41.711 rows=1,000 loops=1)

  • Merge Cond: (album_select.album_id = album_select_1.album_id)
17. 1.874 4.348 ↓ 1,000.0 1,000 1

Sort (cost=0.03..0.04 rows=1 width=702) (actual time=3.291..4.348 rows=1,000 loops=1)

  • Sort Key: album_select.album_id
  • Sort Method: quicksort Memory: 280kB
18. 2.474 2.474 ↓ 1,000.0 1,000 1

CTE Scan on album_select (cost=0.00..0.02 rows=1 width=702) (actual time=0.021..2.474 rows=1,000 loops=1)

19. 0.449 33.967 ↓ 44.0 44 1

GroupAggregate (cost=2,734.06..2,734.08 rows=1 width=24) (actual time=33.483..33.967 rows=44 loops=1)

  • Group Key: album_select_1.album_id
20. 0.846 33.518 ↓ 1,237.0 1,237 1

Sort (cost=2,734.06..2,734.07 rows=1 width=32) (actual time=33.223..33.518 rows=1,237 loops=1)

  • Sort Key: album_select_1.album_id
  • Sort Method: quicksort Memory: 145kB
21. 7.784 32.672 ↓ 1,237.0 1,237 1

Nested Loop (cost=134.23..2,734.05 rows=1 width=32) (actual time=0.047..32.672 rows=1,237 loops=1)

22. 5.100 14.456 ↓ 2,608.0 10,432 1

Nested Loop (cost=133.94..2,674.42 rows=4 width=32) (actual time=0.021..14.456 rows=10,432 loops=1)

23. 0.356 0.356 ↓ 1,000.0 1,000 1

CTE Scan on album_select album_select_1 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.356 rows=1,000 loops=1)

24. 6.000 9.000 ↓ 2.5 10 1,000

Bitmap Heap Scan on episode (cost=133.94..2,674.36 rows=4 width=32) (actual time=0.005..0.009 rows=10 loops=1,000)

  • Recheck Cond: (album_id = album_select_1.album_id)
  • Filter: (status = 0)
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=1362
25. 3.000 3.000 ↑ 73.6 10 1,000

Bitmap Index Scan on episode_album_id_index (cost=0.00..133.94 rows=736 width=0) (actual time=0.003..0.003 rows=10 loops=1,000)

  • Index Cond: (album_id = album_select_1.album_id)
26. 10.432 10.432 ↓ 0.0 0 10,432

Index Scan using play_episode_episode_id on play_episode (cost=0.29..14.89 rows=2 width=32) (actual time=0.001..0.001 rows=0 loops=10,432)

  • Index Cond: (episode_id = episode.id)
  • Filter: ((create_time >= '0001-01-01 00:00:00+00'::timestamp with time zone) AND (create_time < '2020-05-20 07:46:17.748337+00'::timestamp with time zone))
27. 20.000 20.000 ↑ 1.0 1 1,000

Index Scan using album_stat_pkey on album_stat album_stat_select (cost=0.42..8.44 rows=1 width=32) (actual time=0.020..0.020 rows=1 loops=1,000)

  • Index Cond: (album_id = album_select.album_id)
28. 4.000 56.000 ↓ 2.0 2 1,000

GroupAggregate (cost=54.92..54.94 rows=1 width=24) (actual time=0.055..0.056 rows=2 loops=1,000)

  • Group Key: album_select_2.album_id
29. 1.102 52.000 ↓ 2.0 2 1,000

Sort (cost=54.92..54.93 rows=1 width=32) (actual time=0.052..0.052 rows=2 loops=1,000)

  • Sort Key: album_select_2.album_id
  • Sort Method: quicksort Memory: 25kB
30. 24.005 50.898 ↓ 2.0 2 1

Nested Loop (cost=0.42..54.91 rows=1 width=32) (actual time=44.464..50.898 rows=2 loops=1)

  • Join Filter: (episode_1.album_id = album_select_2.album_id)
  • Rows Removed by Join Filter: 101998
31. 0.109 0.577 ↓ 102.0 102 1

Nested Loop (cost=0.42..54.88 rows=1 width=32) (actual time=0.024..0.577 rows=102 loops=1)

32. 0.060 0.060 ↓ 25.5 102 1

Seq Scan on guest_play_episode (cost=0.00..21.10 rows=4 width=32) (actual time=0.007..0.060 rows=102 loops=1)

  • Filter: ((create_time >= '0001-01-01 00:00:00+00'::timestamp with time zone) AND (create_time < '2020-05-20 07:46:17.748337+00'::timestamp with time zone))
33. 0.408 0.408 ↑ 1.0 1 102

Index Scan using episode_pkey on episode episode_1 (cost=0.42..8.44 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=102)

  • Index Cond: (id = guest_play_episode.episode_id)
  • Filter: (status = 0)
34. 26.316 26.316 ↓ 1,000.0 1,000 102

CTE Scan on album_select album_select_2 (cost=0.00..0.02 rows=1 width=16) (actual time=0.000..0.258 rows=1,000 loops=102)

35. 3.000 37.000 ↓ 2.0 2 1,000

GroupAggregate (cost=67.86..67.88 rows=1 width=24) (actual time=0.035..0.037 rows=2 loops=1,000)

  • Group Key: album_select_3.album_id
36. 2.099 34.000 ↓ 4.0 4 1,000

Sort (cost=67.86..67.87 rows=1 width=32) (actual time=0.033..0.034 rows=4 loops=1,000)

  • Sort Key: album_select_3.album_id
  • Sort Method: quicksort Memory: 25kB
37. 14.335 31.901 ↓ 4.0 4 1

Nested Loop (cost=0.42..67.85 rows=1 width=32) (actual time=2.425..31.901 rows=4 loops=1)

  • Join Filter: (episode_2.album_id = album_select_3.album_id)
  • Rows Removed by Join Filter: 60996
38. 0.131 1.706 ↓ 61.0 61 1

Nested Loop (cost=0.42..67.82 rows=1 width=32) (actual time=1.011..1.706 rows=61 loops=1)

39. 0.171 0.171 ↓ 93.6 468 1

Seq Scan on like_episode (cost=0.00..25.60 rows=5 width=16) (actual time=0.012..0.171 rows=468 loops=1)

  • Filter: ((create_time >= '0001-01-01 00:00:00+00'::timestamp with time zone) AND (create_time < '2020-05-20 07:46:17.748337+00'::timestamp with time zone))
40. 1.404 1.404 ↓ 0.0 0 468

Index Scan using episode_pkey on episode episode_2 (cost=0.42..8.44 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=468)

  • Index Cond: (id = like_episode.episode_id)
  • Filter: (status = 0)
  • Rows Removed by Filter: 0
41. 15.860 15.860 ↓ 1,000.0 1,000 61

CTE Scan on album_select album_select_3 (cost=0.00..0.02 rows=1 width=16) (actual time=0.000..0.260 rows=1,000 loops=61)

42. 24.000 126.000 ↓ 11.0 11 1,000

GroupAggregate (cost=57.02..57.05 rows=1 width=80) (actual time=0.110..0.126 rows=11 loops=1,000)

  • Group Key: album_select_4.album_id
43. 10.891 102.000 ↓ 47.0 47 1,000

Sort (cost=57.02..57.03 rows=1 width=32) (actual time=0.092..0.102 rows=47 loops=1,000)

  • Sort Key: album_select_4.album_id
  • Sort Method: quicksort Memory: 28kB
44. 41.294 91.109 ↓ 47.0 47 1

Nested Loop (cost=0.42..57.01 rows=1 width=32) (actual time=3.026..91.109 rows=47 loops=1)

  • Join Filter: (episode_3.album_id = album_select_4.album_id)
  • Rows Removed by Join Filter: 175953
45. 0.363 2.823 ↓ 176.0 176 1

Nested Loop (cost=0.42..56.98 rows=1 width=32) (actual time=1.299..2.823 rows=176 loops=1)

46. 0.297 0.297 ↓ 180.2 721 1

Seq Scan on admin_action_episode (cost=0.00..23.20 rows=4 width=32) (actual time=0.006..0.297 rows=721 loops=1)

  • Filter: ((update_time >= '0001-01-01 00:00:00+00'::timestamp with time zone) AND (update_time < '2020-05-20 07:46:17.748337+00'::timestamp with time zone))
47. 2.163 2.163 ↓ 0.0 0 721

Index Scan using episode_pkey on episode episode_3 (cost=0.42..8.44 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=721)

  • Index Cond: (id = admin_action_episode.episode_id)
  • Filter: (status = 0)
  • Rows Removed by Filter: 0
48. 46.992 46.992 ↓ 1,000.0 1,000 176

CTE Scan on album_select album_select_4 (cost=0.00..0.02 rows=1 width=16) (actual time=0.000..0.267 rows=1,000 loops=176)

49. 8.000 8.000 ↓ 1.8 9 1,000

Seq Scan on admin_action_album (cost=0.00..21.50 rows=5 width=26) (actual time=0.005..0.008 rows=9 loops=1,000)

  • Filter: (status = 0)
50. 35,998.000 188,735.000 ↓ 1,000.0 1,000 1,000

Nested Loop Left Join (cost=146.24..146.36 rows=1 width=56) (actual time=2.523..188.735 rows=1,000 loops=1,000)

  • Join Filter: (album_select_5.album_id = album_select_7.album_id)
  • Rows Removed by Join Filter: 165347
51. 452.000 737.000 ↓ 1,000.0 1,000 1,000

Merge Left Join (cost=20.74..20.79 rows=1 width=32) (actual time=0.025..0.737 rows=1,000 loops=1,000)

  • Merge Cond: (album_select_5.album_id = album_select_6.album_id)
52. 261.709 262.000 ↓ 1,000.0 1,000 1,000

Sort (cost=0.03..0.04 rows=1 width=16) (actual time=0.001..0.262 rows=1,000 loops=1,000)

  • Sort Key: album_select_5.album_id
  • Sort Method: quicksort Memory: 71kB
53. 0.291 0.291 ↓ 1,000.0 1,000 1

CTE Scan on album_select album_select_5 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.291 rows=1,000 loops=1)

54. 4.000 23.000 ↑ 1.0 1 1,000

GroupAggregate (cost=20.71..20.73 rows=1 width=32) (actual time=0.022..0.023 rows=1 loops=1,000)

  • Group Key: album_select_6.album_id
55. 1.186 19.000 ↓ 3.0 3 1,000

Sort (cost=20.71..20.71 rows=1 width=18) (actual time=0.018..0.019 rows=3 loops=1,000)

  • Sort Key: album_select_6.album_id
  • Sort Method: quicksort Memory: 25kB
56. 7.520 17.814 ↓ 3.0 3 1

Nested Loop (cost=0.00..20.70 rows=1 width=18) (actual time=0.654..17.814 rows=3 loops=1)

  • Join Filter: (album_select_6.album_id = device_album_score.album_id)
  • Rows Removed by Join Filter: 32997
57. 0.294 0.294 ↓ 1,000.0 1,000 1

CTE Scan on album_select album_select_6 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.294 rows=1,000 loops=1)

58. 10.000 10.000 ↓ 8.2 33 1,000

Seq Scan on device_album_score (cost=0.00..20.62 rows=4 width=18) (actual time=0.001..0.010 rows=33 loops=1,000)

  • Filter: (status = 0)
59. 114,000.000 152,000.000 ↓ 166.0 166 1,000,000

GroupAggregate (cost=125.50..125.53 rows=1 width=32) (actual time=0.004..0.152 rows=166 loops=1,000,000)

  • Group Key: album_select_7.album_id
60. 35,505.171 38,000.000 ↓ 172.0 172 1,000,000

Sort (cost=125.50..125.51 rows=1 width=18) (actual time=0.003..0.038 rows=172 loops=1,000,000)

  • Sort Key: album_select_7.album_id
  • Sort Method: quicksort Memory: 39kB
61. 1,116.091 2,494.829 ↓ 189.0 189 1

Nested Loop (cost=0.00..125.49 rows=1 width=18) (actual time=2.595..2,494.829 rows=189 loops=1)

  • Join Filter: (album_select_7.album_id = user_album_score.album_id)
  • Rows Removed by Join Filter: 5222811
62. 0.738 0.738 ↓ 1,000.0 1,000 1

CTE Scan on album_select album_select_7 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.738 rows=1,000 loops=1)

63. 1,378.000 1,378.000 ↓ 186.5 5,223 1,000

Seq Scan on user_album_score (cost=0.00..125.12 rows=28 width=18) (actual time=0.002..1.378 rows=5,223 loops=1,000)

  • Filter: (status = 0)
64. 1,893.000 6,481.000 ↓ 500.0 500 1,000

GroupAggregate (cost=146.54..146.88 rows=1 width=48) (actual time=2.501..6.481 rows=500 loops=1,000)

  • Group Key: album_select_8.album_id
65. 1,408.000 4,588.000 ↓ 500.6 2,503 1,000

Merge Left Join (cost=146.54..146.79 rows=5 width=28) (actual time=2.479..4.588 rows=2,503 loops=1,000)

  • Merge Cond: (album_select_8.album_id = album_select_9.album_id)
66. 132.697 133.000 ↓ 501.0 501 1,000

Sort (cost=0.03..0.04 rows=1 width=16) (actual time=0.001..0.133 rows=501 loops=1,000)

  • Sort Key: album_select_8.album_id
  • Sort Method: quicksort Memory: 71kB
67. 0.303 0.303 ↓ 1,000.0 1,000 1

CTE Scan on album_select album_select_8 (cost=0.00..0.02 rows=1 width=16) (actual time=0.002..0.303 rows=1,000 loops=1)

68. 562.065 3,047.000 ↓ 500.6 2,503 1,000

Materialize (cost=146.51..146.69 rows=5 width=28) (actual time=2.475..3.047 rows=2,503 loops=1,000)

69. 5.131 2,484.935 ↓ 1,000.0 5,000 1

Merge Left Join (cost=146.51..146.68 rows=5 width=28) (actual time=2,473.645..2,484.935 rows=5,000 loops=1)

  • Merge Cond: ((album_select_9.album_id = album_select_11.album_id) AND ((((generate_series(1, 5)) * 20)) = user_album_score_1.score))
70. 3.359 31.823 ↓ 1,000.0 5,000 1

Merge Left Join (cost=21.00..21.09 rows=5 width=28) (actual time=26.349..31.823 rows=5,000 loops=1)

  • Merge Cond: ((album_select_9.album_id = album_select_10.album_id) AND ((((generate_series(1, 5)) * 20)) = device_album_score_1.score))
71. 4.813 11.849 ↓ 1,000.0 5,000 1

Sort (cost=0.30..0.31 rows=5 width=20) (actual time=9.731..11.849 rows=5,000 loops=1)

  • Sort Key: album_select_9.album_id, (((generate_series(1, 5)) * 20))
  • Sort Method: quicksort Memory: 583kB
72. 2.756 7.036 ↓ 1,000.0 5,000 1

Nested Loop Left Join (cost=0.00..0.24 rows=5 width=20) (actual time=0.009..7.036 rows=5,000 loops=1)

73. 0.280 0.280 ↓ 1,000.0 1,000 1

CTE Scan on album_select album_select_9 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.280 rows=1,000 loops=1)

74. 2.000 4.000 ↑ 1.0 5 1,000

Result (cost=0.00..0.12 rows=5 width=4) (actual time=0.001..0.004 rows=5 loops=1,000)

75. 2.000 2.000 ↑ 1.0 5 1,000

ProjectSet (cost=0.00..0.04 rows=5 width=4) (actual time=0.001..0.002 rows=5 loops=1,000)

76. 0.000 0.000 ↑ 1.0 1 1,000

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=1,000)

77. 0.011 16.615 ↑ 1.0 1 1

GroupAggregate (cost=20.71..20.73 rows=1 width=26) (actual time=16.614..16.615 rows=1 loops=1)

  • Group Key: album_select_10.album_id, device_album_score_1.score
78. 0.021 16.604 ↓ 3.0 3 1

Sort (cost=20.71..20.71 rows=1 width=18) (actual time=16.603..16.604 rows=3 loops=1)

  • Sort Key: album_select_10.album_id, device_album_score_1.score
  • Sort Method: quicksort Memory: 25kB
79. 7.309 16.583 ↓ 3.0 3 1

Nested Loop (cost=0.00..20.70 rows=1 width=18) (actual time=0.610..16.583 rows=3 loops=1)

  • Join Filter: (album_select_10.album_id = device_album_score_1.album_id)
  • Rows Removed by Join Filter: 32997
80. 0.274 0.274 ↓ 1,000.0 1,000 1

CTE Scan on album_select album_select_10 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.274 rows=1,000 loops=1)

81. 9.000 9.000 ↓ 8.2 33 1,000

Seq Scan on device_album_score device_album_score_1 (cost=0.00..20.62 rows=4 width=18) (actual time=0.001..0.009 rows=33 loops=1,000)

  • Filter: (status = 0)
82. 0.535 2,447.981 ↓ 185.0 185 1

GroupAggregate (cost=125.50..125.53 rows=1 width=26) (actual time=2,447.287..2,447.981 rows=185 loops=1)

  • Group Key: album_select_11.album_id, user_album_score_1.score
83. 0.516 2,447.446 ↓ 189.0 189 1

Sort (cost=125.50..125.51 rows=1 width=18) (actual time=2,447.275..2,447.446 rows=189 loops=1)

  • Sort Key: album_select_11.album_id, user_album_score_1.score
  • Sort Method: quicksort Memory: 39kB
84. 1,082.189 2,446.930 ↓ 189.0 189 1

Nested Loop (cost=0.00..125.49 rows=1 width=18) (actual time=2.405..2,446.930 rows=189 loops=1)

  • Join Filter: (album_select_11.album_id = user_album_score_1.album_id)
  • Rows Removed by Join Filter: 5222811
85. 0.741 0.741 ↓ 1,000.0 1,000 1

CTE Scan on album_select album_select_11 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.741 rows=1,000 loops=1)

86. 1,364.000 1,364.000 ↓ 186.5 5,223 1,000

Seq Scan on user_album_score user_album_score_1 (cost=0.00..125.12 rows=28 width=18) (actual time=0.002..1.364 rows=5,223 loops=1,000)

  • Filter: (status = 0)
87. 18.000 18.000 ↑ 1.0 1 1,000

Index Scan using fmuser_pkey on fmuser fmuser_select (cost=0.41..8.43 rows=1 width=24) (actual time=0.018..0.018 rows=1 loops=1,000)

  • Index Cond: (id = album_select.user_id)
88. 364.688 497.482 ↓ 501.0 501 991

GroupAggregate (cost=2,674.41..2,674.44 rows=1 width=48) (actual time=0.014..0.502 rows=501 loops=991)

  • Group Key: album_select_12.album_id
89. 124.243 132.794 ↓ 261.0 522 991

Sort (cost=2,674.41..2,674.42 rows=2 width=36) (actual time=0.010..0.134 rows=522 loops=991)

  • Sort Key: album_select_12.album_id
  • Sort Method: quicksort Memory: 100kB
90. 1.144 8.551 ↓ 523.5 1,047 1

Nested Loop Left Join (cost=133.94..2,674.40 rows=2 width=36) (actual time=0.034..8.551 rows=1,047 loops=1)

91. 0.407 0.407 ↓ 1,000.0 1,000 1

CTE Scan on album_select album_select_12 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.407 rows=1,000 loops=1)

92. 4.000 7.000 ↓ 0.0 0 1,000

Bitmap Heap Scan on episode episode_4 (cost=133.94..2,674.36 rows=2 width=36) (actual time=0.007..0.007 rows=0 loops=1,000)

  • Recheck Cond: (album_select_12.album_id = album_id)
  • Filter: ((NOT free) AND (status = 0))
  • Rows Removed by Filter: 10
  • Heap Blocks: exact=1362
93. 3.000 3.000 ↑ 73.6 10 1,000

Bitmap Index Scan on episode_album_id_index (cost=0.00..133.94 rows=736 width=0) (actual time=0.003..0.003 rows=10 loops=1,000)

  • Index Cond: (album_id = album_select_12.album_id)
94. 3,648.862 3,864.900 ↓ 501.0 501 991

GroupAggregate (cost=1,316.40..1,316.56 rows=1 width=112) (actual time=0.046..3.900 rows=501 loops=991)

  • Group Key: album_select_13.album_id
95. 208.487 216.038 ↓ 170.8 683 991

Sort (cost=1,316.40..1,316.41 rows=4 width=260) (actual time=0.009..0.218 rows=683 loops=991)

  • Sort Key: album_select_13.album_id
  • Sort Method: quicksort Memory: 180kB
96. 1.017 7.551 ↓ 346.0 1,384 1

Nested Loop Left Join (cost=34.41..1,316.36 rows=4 width=260) (actual time=0.038..7.551 rows=1,384 loops=1)

97. 0.829 5.150 ↓ 346.0 1,384 1

Nested Loop Left Join (cost=34.14..1,314.83 rows=4 width=34) (actual time=0.022..5.150 rows=1,384 loops=1)

98. 0.321 0.321 ↓ 1,000.0 1,000 1

CTE Scan on album_select album_select_13 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.321 rows=1,000 loops=1)

99. 2.000 4.000 ↑ 4.0 1 1,000

Bitmap Heap Scan on album_category (cost=34.14..1,314.77 rows=4 width=34) (actual time=0.003..0.004 rows=1 loops=1,000)

  • Recheck Cond: (album_select_13.album_id = album_id)
  • Filter: (status = 0)
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=627
100. 2.000 2.000 ↑ 763.0 1 1,000

Bitmap Index Scan on album_category_album_id_category_id_pk (cost=0.00..34.14 rows=763 width=0) (actual time=0.002..0.002 rows=1 loops=1,000)

  • Index Cond: (album_id = album_select_13.album_id)
101. 1.384 1.384 ↑ 1.0 1 1,384

Index Scan using category_pkey on category (cost=0.27..0.36 rows=1 width=242) (actual time=0.001..0.001 rows=1 loops=1,384)

  • Index Cond: (id = album_category.category_id)
  • Filter: (status = 0)
  • Rows Removed by Filter: 0
Planning time : 7.683 ms
Execution time : 200,535.117 ms