explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cbyD

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

Hash Join (cost=89,847.00..37,111,449.44 rows=30,326,212 width=34) (actual rows= loops=)

  • Hash Cond: (f.uuid = p.uuid)
  • Join Filter: (((p.permalink)::text <> ((f.properties)::json ->> 'permalink'::text)) OR (NOT ((f.properties -> 'permalink_aliases'::text) ? (p.permalink)::text)))
2. 0.000 0.000 ↓ 0.0

Seq Scan on node_facets f (cost=0.00..9,736,861.10 rows=93,243,221 width=346) (actual rows= loops=)

  • Filter: ((facet_id)::text = 'default'::text)
3. 0.000 0.000 ↓ 0.0

Hash (cost=43,495.11..43,495.11 rows=2,281,911 width=34) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on permalinks p (cost=0.00..43,495.11 rows=2,281,911 width=34) (actual rows= loops=)