explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A8Aa

Settings

Optimization(s) for this plan:

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

HashAggregate (cost=30,007.41..30,017.87 rows=322 width=100) (actual rows= loops=)

  • Group Key: content_comment.content_id
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=72.30..29,912.63 rows=3,791 width=100) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=71.88..72.88 rows=100 width=58) (actual rows= loops=)

  • Group Key: ("ANY_subquery".id)::text
4. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=0.00..71.63 rows=100 width=58) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..70.63 rows=100 width=58) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on content (cost=0.00..52,873.64 rows=74,858 width=58) (actual rows= loops=)

  • Filter: ((data_source_id)::text = 'UCNye-wNBqNL5ZzHSJj3l8Bg'::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using content_comment_data_source_and_content_id on content_comment (cost=0.42..298.02 rows=38 width=100) (actual rows= loops=)

  • Index Cond: (((data_source_id)::text = 'UCNye-wNBqNL5ZzHSJj3l8Bg'::text) AND ((content_id)::text = ("ANY_subquery".id)::text))
  • Filter: ((language)::text = ANY ('{en,ps,ur,ur-pk,en-pk,brh,pa,sd}'::text[]))