explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5glr : channels

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 3.425 ↓ 2.0 2 1

Unique (cost=664.17..664.18 rows=1 width=11) (actual time=3.423..3.425 rows=2 loops=1)

2. 0.013 3.423 ↓ 2.0 2 1

Sort (cost=664.17..664.17 rows=1 width=11) (actual time=3.422..3.423 rows=2 loops=1)

  • Sort Key: name
  • Sort Method: quicksort Memory: 25kB
3. 3.410 3.410 ↓ 2.0 2 1

Seq Scan on sentv_channel c (cost=0.00..664.16 rows=1 width=11) (actual time=3.097..3.410 rows=2 loops=1)

  • Filter: ((name ~* 'World'::text) AND (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: 1154