explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6tml

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

Seq Scan on movie m1 (cost=0.00..13,100,199,547.33 rows=2,762,284 width=4) (actual rows= loops=)

  • Filter: ((SubPlan 1) > 1)
2.          

SubPlan (forSeq Scan)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=1,580.76..1,580.77 rows=1 width=8) (actual rows= loops=)

  • -> Index Scan using idx_m_duration_date_deleted on movie m2 (cost=0.56..1580.76 rows=1 width
  • Index Cond: ((m1.duration = duration) AND (date_deleted IS NULL))
  • Filter: (((m1.title_url_ja)::text = (title_url_ja)::text) OR ((m1.title_url_en)::text =