explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a4bY : Optimization for: Optimization for: plan #cM8C; plan #V4rc

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.004 91.207 ↓ 32.0 32 1

Limit (cost=2,644.34..2,644.34 rows=1 width=481) (actual time=91.198..91.207 rows=32 loops=1)

2. 0.073 91.203 ↓ 32.0 32 1

Sort (cost=2,644.34..2,644.34 rows=1 width=481) (actual time=91.197..91.203 rows=32 loops=1)

  • Sort Key: evs.creation_date, evs.ev_id
  • Sort Method: quicksort Memory: 42kB
3. 0.059 91.130 ↓ 32.0 32 1

Nested Loop Left Join (cost=2.68..2,644.33 rows=1 width=481) (actual time=1.882..91.130 rows=32 loops=1)

4. 0.041 91.007 ↓ 32.0 32 1

Nested Loop Left Join (cost=2.41..2,644.03 rows=1 width=519) (actual time=1.871..91.007 rows=32 loops=1)

5. 0.372 90.806 ↓ 32.0 32 1

Nested Loop (cost=1.98..2,642.49 rows=1 width=395) (actual time=1.857..90.806 rows=32 loops=1)

6. 0.568 82.174 ↓ 1,652.0 1,652 1

Nested Loop (cost=1.42..2,637.60 rows=1 width=403) (actual time=0.095..82.174 rows=1,652 loops=1)

7. 0.693 76.650 ↓ 1,652.0 1,652 1

Nested Loop (cost=0.99..2,635.53 rows=1 width=16) (actual time=0.083..76.650 rows=1,652 loops=1)

8. 71.001 71.001 ↓ 24.3 1,652 1

Index Scan using comm_flds_name_left_xappprop_pidx1 on comm_flds cf_0 (cost=0.56..2,400.42 rows=68 width=16) (actual time=0.073..71.001 rows=1,652 loops=1)

  • Index Cond: ((name)::text = ANY ('{xappprop_group_name#en,xappextprop_group_name#en,xappprop_lang_group_name#en}'::text[]))
  • Filter: (when_created > (now() - '24:00:00'::interval))
  • Rows Removed by Filter: 53934
9. 4.956 4.956 ↑ 1.0 1 1,652

Index Scan using comm_pk on comm c_0 (cost=0.43..3.46 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1,652)

  • Index Cond: (comm_id = cf_0.comm_id)
  • Filter: (when_created > (now() - '24:00:00'::interval))
10. 4.956 4.956 ↑ 1.0 1 1,652

Index Scan using evs_pk on evs (cost=0.42..2.07 rows=1 width=395) (actual time=0.003..0.003 rows=1 loops=1,652)

  • Index Cond: (ev_id = c_0.comm_ev_id)
  • Filter: ((company_id = 1) AND (creation_date > (now() - '24:00:00'::interval)))
11. 8.260 8.260 ↓ 0.0 0 1,652

Index Scan using idx_comm_values1 on comm_values cv_0 (cost=0.56..4.88 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1,652)

  • Index Cond: (comm_fld_id = cf_0.comm_fld_id)
  • Filter: (lower((value)::text) ~~ '%search_devops%'::text)
  • Rows Removed by Filter: 1
12. 0.160 0.160 ↑ 1.0 1 32

Index Scan using evs_email_message_ev_id_uc on evs_email_message msg (cost=0.42..1.54 rows=1 width=132) (actual time=0.005..0.005 rows=1 loops=32)

  • Index Cond: (ev_id = evs.ev_id)
13. 0.064 0.064 ↑ 1.0 1 32

Index Scan using message_panel_pk on message_panel mp (cost=0.28..0.29 rows=1 width=61) (actual time=0.002..0.002 rows=1 loops=32)

  • Index Cond: (message_panel_id = evs.message_panel_id)
Planning time : 5.153 ms
Execution time : 91.357 ms