explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wfh9

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 12,056.789 ↑ 1.0 1 1

Aggregate (cost=11,301.85..11,301.86 rows=1 width=8) (actual time=12,056.789..12,056.789 rows=1 loops=1)

2. 0.000 12,056.783 ↓ 0.0 0 1

Unique (cost=11,301.83..11,301.84 rows=1 width=8) (actual time=12,056.783..12,056.783 rows=0 loops=1)

3. 0.071 12,056.783 ↓ 0.0 0 1

Sort (cost=11,301.83..11,301.84 rows=1 width=8) (actual time=12,056.783..12,056.783 rows=0 loops=1)

  • Sort Key: evs.ev_id
  • Sort Method: quicksort Memory: 25kB
4. 0.849 12,056.712 ↓ 0.0 0 1

Nested Loop (cost=7.70..11,301.82 rows=1 width=8) (actual time=12,056.712..12,056.712 rows=0 loops=1)

5. 3.135 7,523.664 ↓ 8.9 321 1

Nested Loop (cost=7.27..11,016.13 rows=36 width=16) (actual time=13.470..7,523.664 rows=321 loops=1)

6. 3.672 5,714.279 ↑ 4.0 850 1

Nested Loop (cost=6.83..1,793.41 rows=3,432 width=16) (actual time=12.948..5,714.279 rows=850 loops=1)

7. 11.145 11.357 ↓ 2.2 850 1

Bitmap Heap Scan on evs (cost=6.41..554.51 rows=385 width=15) (actual time=0.309..11.357 rows=850 loops=1)

  • Recheck Cond: (company_id = '200505'::bigint)
  • Heap Blocks: exact=787
8. 0.212 0.212 ↓ 2.2 864 1

Bitmap Index Scan on evs_company_id_idx (cost=0.00..6.31 rows=385 width=0) (actual time=0.211..0.212 rows=864 loops=1)

  • Index Cond: (company_id = '200505'::bigint)
9. 5,699.250 5,699.250 ↑ 1.0 1 850

Index Scan using comm_comm_ev_id_uidx on comm c_0 (cost=0.42..3.22 rows=1 width=16) (actual time=6.705..6.705 rows=1 loops=850)

  • Index Cond: (comm_ev_id = evs.ev_id)
10. 1,806.250 1,806.250 ↓ 0.0 0 850

Index Scan using idx_comm_flds1 on comm_flds cf_0 (cost=0.44..2.68 rows=1 width=16) (actual time=2.104..2.125 rows=0 loops=850)

  • Index Cond: (comm_id = c_0.comm_id)
  • Filter: (((name)::text = 'xappprop_incident_number#en'::text) OR ((name)::text = 'xappextprop_incident_number#en'::text) OR ((name)::text = 'xappprop_lang_incident_number#en'::text))
  • Rows Removed by Filter: 9
11. 4,532.199 4,532.199 ↓ 0.0 0 321

Index Scan using idx_comm_values1 on comm_values cv_0 (cost=0.44..7.93 rows=1 width=8) (actual time=14.119..14.119 rows=0 loops=321)

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