explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wBsF

Settings
# exclusive inclusive rows x rows loops node
1. 0.298 46.030 ↓ 28.0 56 1

Sort (cost=3,995.90..3,995.91 rows=2 width=1,578) (actual time=46.026..46.030 rows=56 loops=1)

  • Sort Key: (1), livestreamings.start_time
  • Sort Method: quicksort Memory: 137kB
2. 0.154 45.732 ↓ 28.0 56 1

Nested Loop Left Join (cost=65.63..3,995.89 rows=2 width=1,578) (actual time=0.601..45.732 rows=56 loops=1)

3. 0.009 0.890 ↓ 28.0 56 1

Append (cost=65.21..130.45 rows=2 width=1,546) (actual time=0.562..0.890 rows=56 loops=1)

4. 0.151 0.571 ↓ 34.0 34 1

Sort (cost=65.21..65.21 rows=1 width=1,546) (actual time=0.562..0.571 rows=34 loops=1)

  • Sort Key: livestreamings.start_time
  • Sort Method: quicksort Memory: 93kB
5. 0.100 0.420 ↓ 34.0 34 1

Hash Left Join (cost=14.78..65.20 rows=1 width=1,546) (actual time=0.192..0.420 rows=34 loops=1)

  • Hash Cond: (livestreamings.id = premium_contents.premiumable_id)
  • Filter: (premium_contents.id IS NULL)
  • Rows Removed by Filter: 22
6. 0.174 0.174 ↑ 1.6 56 1

Index Scan using index_livestreamings_tv_stream on livestreamings (cost=0.14..50.11 rows=89 width=1,542) (actual time=0.018..0.174 rows=56 loops=1)

7. 0.022 0.146 ↑ 1.1 58 1

Hash (cost=13.88..13.88 rows=61 width=12) (actual time=0.146..0.146 rows=58 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
8. 0.124 0.124 ↑ 1.1 58 1

Seq Scan on premium_contents (cost=0.00..13.88 rows=61 width=12) (actual time=0.009..0.124 rows=58 loops=1)

  • Filter: ((premiumable_type)::text = 'Livestreaming'::text)
  • Rows Removed by Filter: 482
9. 0.089 0.310 ↓ 22.0 22 1

Sort (cost=65.21..65.21 rows=1 width=1,546) (actual time=0.307..0.310 rows=22 loops=1)

  • Sort Key: livestreamings_1.start_time
  • Sort Method: quicksort Memory: 69kB
10. 0.053 0.221 ↓ 22.0 22 1

Hash Join (cost=14.78..65.20 rows=1 width=1,546) (actual time=0.161..0.221 rows=22 loops=1)

  • Hash Cond: (livestreamings_1.id = premium_contents_1.premiumable_id)
11. 0.068 0.068 ↑ 1.6 56 1

Index Scan using index_livestreamings_tv_stream on livestreamings livestreamings_1 (cost=0.14..50.11 rows=89 width=1,542) (actual time=0.027..0.068 rows=56 loops=1)

12. 0.012 0.100 ↑ 1.1 58 1

Hash (cost=13.88..13.88 rows=61 width=4) (actual time=0.100..0.100 rows=58 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
13. 0.088 0.088 ↑ 1.1 58 1

Seq Scan on premium_contents premium_contents_1 (cost=0.00..13.88 rows=61 width=4) (actual time=0.009..0.088 rows=58 loops=1)

  • Filter: ((id IS NOT NULL) AND ((premiumable_type)::text = 'Livestreaming'::text))
  • Rows Removed by Filter: 482
14. 44.688 44.688 ↓ 0.0 0 56

Index Scan using index_livestreaming_schedules_on_livestreaming_id on livestreaming_schedules (cost=0.42..1,932.71 rows=1 width=36) (actual time=0.659..0.798 rows=0 loops=56)

  • Index Cond: (livestreamings.id = livestreaming_id)
  • Filter: ((start_time <= '2020-02-03 05:56:54'::timestamp without time zone) AND ('2020-02-03 05:56:54'::timestamp without time zone <= end_time))
  • Rows Removed by Filter: 2042
Planning time : 3.091 ms
Execution time : 46.302 ms