explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hO3m : Optimization for: plan #g8HS

Settings

Optimization path:

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

Limit (cost=48,208.40..48,208.90 rows=100 width=53) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=48,208.40..48,211.03 rows=526 width=53) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=48,208.40..48,209.71 rows=526 width=53) (actual rows= loops=)

  • Sort Key: contents.ref
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=44,610.19..48,184.63 rows=526 width=53) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=44,609.89..47,930.80 rows=608 width=57) (actual rows= loops=)

  • Hash Cond: (offers_contents_contents.target = contents.id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on offers_contents_contents (cost=0.00..1,785.87 rows=121,587 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=44,593.54..44,593.54 rows=1,308 width=57) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..44,593.54 rows=1,308 width=57) (actual rows= loops=)

  • Workers Planned: 2
9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on contents_extended contents (cost=0.00..43,462.74 rows=545 width=57) (actual rows= loops=)

  • Filter: ((categoryrefs IS NULL) OR (cardinality(categoryrefs) = 0))
10. 0.000 0.000 ↓ 0.0

Index Scan using offers_pkey on offers (cost=0.29..0.42 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = offers_contents_contents.source)
  • Filter: (type = 'ondemand'::text)