explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xnx3

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 21.355 ↑ 1.0 1 1

Aggregate (cost=10,962.79..10,962.80 rows=1 width=8) (actual time=21.354..21.355 rows=1 loops=1)

2. 0.044 21.351 ↓ 0.0 0 1

Nested Loop (cost=9.53..10,962.79 rows=1 width=8) (actual time=21.351..21.351 rows=0 loops=1)

3. 1.682 18.277 ↓ 6.7 303 1

Nested Loop (cost=9.09..10,440.42 rows=45 width=16) (actual time=0.321..18.277 rows=303 loops=1)

4. 0.434 6.320 ↑ 5.7 685 1

Nested Loop (cost=8.53..2,773.77 rows=3,936 width=16) (actual time=0.215..6.320 rows=685 loops=1)

5. 1.654 1.776 ↓ 1.1 685 1

Bitmap Heap Scan on evs (cost=8.10..861.01 rows=604 width=8) (actual time=0.195..1.776 rows=685 loops=1)

  • Recheck Cond: (company_id = '200505'::bigint)
  • Heap Blocks: exact=668
6. 0.122 0.122 ↓ 1.1 689 1

Bitmap Index Scan on evs_company_id_idx (cost=0.00..7.95 rows=604 width=0) (actual time=0.121..0.122 rows=689 loops=1)

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

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

  • Index Cond: (comm_ev_id = evs.ev_id)
8. 10.275 10.275 ↓ 0.0 0 685

Index Scan using idx_comm_fld_name on comm_flds cf_0 (cost=0.56..1.94 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=685)

  • 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. 3.030 3.030 ↓ 0.0 0 303

Index Scan using idx_comm_values1 on comm_values cv_0 (cost=0.44..11.60 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=303)

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