explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MmaF : Optimization for: Optimization for: plan #cM8C; plan #Qz2c

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 87.851 ↓ 0.0 0 1

Limit (cost=4,272.60..4,272.60 rows=1 width=481) (actual time=87.851..87.851 rows=0 loops=1)

2.          

Initplan (for Limit)

3. 0.002 0.030 ↑ 1.0 1 1

Result (cost=22.22..22.23 rows=1 width=8) (actual time=0.030..0.030 rows=1 loops=1)

4.          

Initplan (for Result)

5. 0.001 0.028 ↑ 1.0 1 1

Limit (cost=0.42..22.22 rows=1 width=8) (actual time=0.028..0.028 rows=1 loops=1)

6. 0.027 0.027 ↑ 3,329.0 1 1

Index Scan Backward using idx_evs_cdate on evs evs_1 (cost=0.42..72,540.29 rows=3,329 width=8) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: (creation_date IS NOT NULL)
  • Filter: ((status)::text = 'ACTIVE'::text)
7. 0.017 87.850 ↓ 0.0 0 1

Sort (cost=4,250.37..4,250.38 rows=1 width=481) (actual time=87.850..87.850 rows=0 loops=1)

  • Sort Key: evs.creation_date DESC, evs.ev_id DESC
  • Sort Method: quicksort Memory: 25kB
8. 0.000 87.833 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.41..4,250.36 rows=1 width=481) (actual time=87.833..87.833 rows=0 loops=1)

  • Join Filter: (mp.message_panel_id = evs.message_panel_id)
9. 0.001 87.833 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.41..4,209.85 rows=1 width=519) (actual time=87.833..87.833 rows=0 loops=1)

10. 0.001 87.832 ↓ 0.0 0 1

Nested Loop (cost=1.98..4,206.90 rows=1 width=395) (actual time=87.832..87.832 rows=0 loops=1)

11. 0.000 87.831 ↓ 0.0 0 1

Nested Loop (cost=1.42..4,202.01 rows=1 width=403) (actual time=87.831..87.831 rows=0 loops=1)

12. 0.001 87.831 ↓ 0.0 0 1

Nested Loop (cost=0.99..4,199.83 rows=1 width=16) (actual time=87.831..87.831 rows=0 loops=1)

13. 87.830 87.830 ↓ 0.0 0 1

Index Scan using comm_flds_name_left_xappprop_pidx1 on comm_flds cf_0 (cost=0.56..2,394.10 rows=524 width=16) (actual time=87.830..87.830 rows=0 loops=1)

  • Index Cond: ((name)::text = ANY ('{xappprop_group_name#en,xappextprop_group_name#en,xappprop_lang_group_name#en}'::text[]))
  • Filter: (when_created >= $1)
  • Rows Removed by Filter: 55621
14. 0.000 0.000 ↓ 0.0 0

Index Scan using comm_pk on comm c_0 (cost=0.43..3.45 rows=1 width=16) (never executed)

  • Index Cond: (comm_id = cf_0.comm_id)
  • Filter: (when_created > (now() - '24:00:00'::interval))
15. 0.000 0.000 ↓ 0.0 0

Index Scan using evs_pk on evs (cost=0.42..2.18 rows=1 width=395) (never executed)

  • Index Cond: (ev_id = c_0.comm_ev_id)
  • Filter: ((company_id = 1) AND ((status)::text = 'ACTIVE'::text))
16. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (comm_fld_id = cf_0.comm_fld_id)
  • Filter: (lower((value)::text) ~~ '%search_devops%'::text)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using evs_email_message_ev_id_uc on evs_email_message msg (cost=0.42..2.95 rows=1 width=132) (never executed)

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

Seq Scan on message_panel mp (cost=0.00..32.45 rows=645 width=61) (never executed)

Planning time : 10.271 ms
Execution time : 88.042 ms