explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tLt2

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.020 ↑ 1.0 1 1

Aggregate (cost=9.80..9.81 rows=1 width=8) (actual time=0.020..0.020 rows=1 loops=1)

2. 0.000 0.018 ↓ 0.0 0 1

Nested Loop (cost=1.15..9.80 rows=1 width=8) (actual time=0.018..0.018 rows=0 loops=1)

3. 0.001 0.018 ↓ 0.0 0 1

Nested Loop (cost=0.86..6.96 rows=1 width=16) (actual time=0.018..0.018 rows=0 loops=1)

4. 0.000 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.57..6.43 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=1)

5. 0.017 0.017 ↓ 0.0 0 1

Index Scan using evs_company_id_idx on evs (cost=0.29..3.13 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (company_id = '200505'::bigint)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using comm_comm_ev_id_uidx on comm c_0 (cost=0.29..3.30 rows=1 width=16) (never executed)

  • Index Cond: (comm_ev_id = evs.ev_id)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_comm_flds1 on comm_flds cf_0 (cost=0.29..0.52 rows=1 width=16) (never executed)

  • Index Cond: (comm_id = c_0.comm_id)
  • Filter: ((name)::text = ANY ('{xappprop_incident_number#en,xappextprop_incident_number#en,xappprop_lang_incident_number#en}'::text[]))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_comm_values1 on comm_values cv_0 (cost=0.29..2.83 rows=1 width=8) (never executed)

  • Index Cond: (comm_fld_id = cf_0.comm_fld_id)
  • Filter: (lower((value)::text) = 'in356645'::text)