explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KbqP

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=1,001.12..637,735.84 rows=4,443 width=161) (actual rows= loops=)

  • Workers Planned: 6
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.11..636,291.54 rows=740 width=161) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Parallel Index Scan using channel_estimates_pkey on channel_estimates e (cost=0.56..621,321.20 rows=6,046 width=762) (actual rows= loops=)

  • Filter: ((((((estimates -> 'views'::text) -> 'youtube_30d'::text) ->> 'median'::text))::integer > 1000) AND (((((estimates -> 'views'::text) -> 'youtube_30d'::text) ->> 'median'::text))::integer < 40000))
4. 0.000 0.000 ↓ 0.0

Index Scan using channels_pkey on channels c (cost=0.56..2.47 rows=1 width=157) (actual rows= loops=)

  • Index Cond: (id = e.youtube_channel_id)
  • Filter: ((topic_categories <> '{}'::text[]) AND (((country)::text = 'US'::text) OR (((estimated_country)::text = 'US'::text) AND (country IS NULL))))