explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZRCR

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

Sort (cost=39.90..39.91 rows=1 width=110) (actual rows= loops=)

  • Sort Key: v.lang_key
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..39.89 rows=1 width=110) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on iam_i18n_key k (cost=0.00..27.29 rows=1 width=63) (actual rows= loops=)

  • Filter: ((name)::text ~~ 'Templates.sms.validation.tel1.subject%'::text)
4. 0.000 0.000 ↓ 0.0

Index Scan using iam_i18n_value_id_i18n_key_lang_key_key on iam_i18n_value v (cost=0.28..12.59 rows=1 width=63) (actual rows= loops=)

  • Index Cond: (id_i18n_key = k.id_i18n_key)
  • Filter: (((lang_key)::text = 'en'::text) OR (((lang_key)::text = 'fr'::text) AND (NOT (alternatives: SubPlan 1 or hashed SubPlan 2))))
5.          

SubPlan (for Index Scan)

6. 0.000 0.000 ↓ 0.0

Index Only Scan using iam_i18n_value_id_i18n_key_lang_key_key on iam_i18n_value ven (cost=0.28..4.29 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((id_i18n_key = v.id_i18n_key) AND (lang_key = 'en'::text))
7. 0.000 0.000 ↓ 0.0

Seq Scan on iam_i18n_value ven_1 (cost=0.00..28.31 rows=2 width=8) (actual rows= loops=)

  • Filter: ((lang_key)::text = 'en'::text)