explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qEo0

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 2,290.491 ↓ 2.0 2 1

Unique (cost=48,521.92..48,521.93 rows=1 width=32) (actual time=2,290.488..2,290.491 rows=2 loops=1)

2. 0.042 2,290.488 ↓ 12.0 12 1

Sort (cost=48,521.92..48,521.93 rows=1 width=32) (actual time=2,290.488..2,290.488 rows=12 loops=1)

  • Sort Key: (upper("substring"((regexp_split_to_array(p.title, 'Worlds'::text))[2], 1, 1)))
  • Sort Method: quicksort Memory: 25kB
3. 7.864 2,290.446 ↓ 12.0 12 1

Nested Loop (cost=0.98..48,521.91 rows=1 width=32) (actual time=719.992..2,290.446 rows=12 loops=1)

4. 4.273 689.757 ↓ 1.0 10,985 1

Nested Loop (cost=0.56..13,106.81 rows=10,946 width=4) (actual time=20.561..689.757 rows=10,985 loops=1)

5. 212.956 212.956 ↓ 1.9 112 1

Seq Scan on sentv_channel c (cost=0.00..661.27 rows=60 width=4) (actual time=8.148..212.956 rows=112 loops=1)

  • Filter: ((cardinality(region_dma_codes) > 0) AND (('SUPER'::text = ANY ('{MACHINIMA,EXTENDED,EPIX,PREMIUM,HIYAH,BASIC}'::text[])) OR ('{MACHINIMA,EXTENDED,EPIX,PREMIUM,HIYAH,BASIC}'::text[] && ent_keywords)) AND (((channel_id)::text || '_RESTRICTED'::text) <> ALL ('{MACHINIMA,EXTENDED,EPIX,PREMIUM,HIYAH,BASIC}'::text[])) AND (('NAT'::text = ANY (region_dma_codes)) OR ('NAT-WE'::text = ANY (region_dma_codes)) OR (('807'::text = ANY (region_dma_codes)) AND (('807'::text <> ALL (sub_dmas)) OR ('94117'::text = ANY (sub_dma_zips)) OR (sub_dmas = '{}'::text[]) OR (sub_dma_zips = '{}'::text[])))))
  • Rows Removed by Filter: 1044
6. 472.528 472.528 ↑ 1.9 98 112

Index Only Scan using idx_sentv_airing_complex1 on sentv_airing a (cost=0.56..205.59 rows=184 width=8) (actual time=1.820..4.219 rows=98 loops=112)

  • Index Cond: ((channel_id = c.channel_id) AND (expiration_date >= now()))
  • Filter: (((age_rating || '_RESTRICTED'::text) <> ALL ('{MACHINIMA,EXTENDED,EPIX,PREMIUM,HIYAH,BASIC}'::text[])) AND ((type <> 'vod'::text) OR (((vod_ready_date IS NULL) OR (vod_ready_date <= now())) AND (expiration_date >= now()))))
  • Heap Fetches: 1113
7. 1,592.825 1,592.825 ↓ 0.0 0 10,985

Index Scan using sentv_program_pkey on sentv_program p (cost=0.42..3.23 rows=1 width=23) (actual time=0.145..0.145 rows=0 loops=10,985)

  • Index Cond: (program_id = a.program_id)
  • Filter: (title ~* 'Worlds'::text)
  • Rows Removed by Filter: 1