explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 700o

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 114.171 ↑ 1.0 1 1

Aggregate (cost=11,066.13..11,066.14 rows=1 width=8) (actual time=114.171..114.171 rows=1 loops=1)

2. 0.119 114.164 ↓ 0.0 0 1

Nested Loop (cost=9.52..11,066.13 rows=1 width=8) (actual time=114.163..114.164 rows=0 loops=1)

3. 2.395 86.052 ↓ 7.2 301 1

Nested Loop (cost=9.08..10,569.23 rows=42 width=16) (actual time=0.524..86.052 rows=301 loops=1)

4. 0.239 10.683 ↑ 5.8 682 1

Nested Loop (cost=8.52..2,768.91 rows=3,931 width=16) (actual time=0.272..10.683 rows=682 loops=1)

5. 2.095 2.260 ↓ 1.1 682 1

Bitmap Heap Scan on evs (cost=8.10..859.59 rows=603 width=8) (actual time=0.241..2.260 rows=682 loops=1)

  • Recheck Cond: (company_id = '200505'::bigint)
  • Heap Blocks: exact=665
6. 0.165 0.165 ↓ 1.1 684 1

Bitmap Index Scan on evs_company_id_idx (cost=0.00..7.95 rows=603 width=0) (actual time=0.147..0.165 rows=684 loops=1)

  • Index Cond: (company_id = '200505'::bigint)
7. 8.184 8.184 ↑ 1.0 1 682

Index Scan using comm_comm_ev_id_uidx on comm c_0 (cost=0.42..3.17 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=682)

  • Index Cond: (comm_ev_id = evs.ev_id)
8. 72.974 72.974 ↓ 0.0 0 682

Index Scan using idx_comm_fld_name on comm_flds cf_0 (cost=0.56..1.97 rows=1 width=16) (actual time=0.107..0.107 rows=0 loops=682)

  • Index Cond: ((comm_id = c_0.comm_id) AND ((name)::text = ANY ('{xappprop_incident_number#en,xappextprop_incident_number#en,xappprop_lang_incident_number#en}'::text[])))
9. 27.993 27.993 ↓ 0.0 0 301

Index Scan using idx_comm_values1 on comm_values cv_0 (cost=0.44..11.82 rows=1 width=8) (actual time=0.093..0.093 rows=0 loops=301)

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