explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LyQY

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 634.029 ↓ 0.0 0 1

Limit (cost=101,597.88..102,082.43 rows=100 width=2,408) (actual time=634.029..634.029 rows=0 loops=1)

2. 0.000 634.026 ↓ 0.0 0 1

Nested Loop Left Join (cost=101,597.88..844,554.01 rows=153,329 width=2,408) (actual time=634.026..634.026 rows=0 loops=1)

3. 0.001 634.026 ↓ 0.0 0 1

Nested Loop Left Join (cost=101,597.45..741,662.13 rows=153,329 width=2,382) (actual time=634.026..634.026 rows=0 loops=1)

4. 0.001 634.025 ↓ 0.0 0 1

Nested Loop Left Join (cost=101,597.03..554,657.66 rows=153,329 width=2,279) (actual time=634.025..634.025 rows=0 loops=1)

5. 0.001 634.024 ↓ 0.0 0 1

Nested Loop Left Join (cost=101,596.61..323,656.44 rows=153,329 width=349) (actual time=634.024..634.024 rows=0 loops=1)

  • Filter: ((runtimeeve0_.application_id IS NULL) OR (applicatio4_.application_id IS NULL) OR ((applicatio4_.name)::text <> ALL ('{""Voice Recording Notifications"",""Error Response Notifications"",""User Upload Onboarding Notifications"",""Data Upload Notifications""}'::text[])))
6. 480.018 634.023 ↓ 0.0 0 1

Index Scan Backward using idx_evs_cdate on evs runtimeeve0_ (cost=101,596.34..275,224.74 rows=158,587 width=349) (actual time=634.022..634.023 rows=0 loops=1)

  • Filter: ((dmn_name IS NOT NULL) AND ((status)::text <> 'SUPPRESSED'::text) AND ((system_message_type IS NULL) OR ((system_message_type)::text = 'SYSTEM_MESSAGE'::text)) AND (company_id = 1) AND ((hashed SubPlan 1) OR (hashed SubPlan 2)) AND ((status)::text = ANY ('{SUPPRESSED,TERMINATED_WITH_ERR,TERMINATED_EXTERNAL,SUSPENDED,TERMINATED,TERMINATED_BY_USER,TERMINATED_EXT_PASSFILL,TERMINATED_PASSFILL,CREATE,TERMINATED_EXT_FAILFILL,PURGED,ACTIVE,TERMINATED_FAILFILL}'::text[])))
  • Rows Removed by Filter: 365360
7.          

SubPlan (for Index Scan Backward)

8. 6.428 153.868 ↓ 0.0 0 1

Gather (cost=1,000.00..101,548.70 rows=1,307 width=8) (actual time=153.682..153.868 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
9. 147.440 147.440 ↓ 0.0 0 5

Parallel Seq Scan on evs runtimeeve5_ (cost=0.00..100,418.00 rows=327 width=8) (actual time=147.440..147.440 rows=0 loops=5)

  • Filter: ((dmn_name IS NOT NULL) AND ((status)::text <> 'SUPPRESSED'::text) AND (company_id = 1) AND (lower((sender)::text) = 'amunster'::text) AND ((status)::text = ANY ('{SUPPRESSED,TERMINATED_WITH_ERR,TERMINATED_EXTERNAL,SUSPENDED,TERMINATED,TERMINATED_BY_USER,TERMINATED_EXT_PASSFILL,TERMINATED_PASSFILL,CREATE,TERMINATED_EXT_FAILFILL,PURGED,ACTIVE,TERMINATED_FAILFILL}'::text[])))
  • Rows Removed by Filter: 73072
10. 0.137 0.137 ↓ 0.0 0 1

Index Only Scan using audit_evs_all_recip_id_ev_id_type_created_pidx on audit_evs_all runtimenot6_ (cost=0.43..43.50 rows=175 width=8) (actual time=0.137..0.137 rows=0 loops=1)

  • Index Cond: (recipient_id = 372691)
  • Heap Fetches: 0
11. 0.000 0.000 ↓ 0.0 0

Index Scan using application_pk on application applicatio4_ (cost=0.27..0.29 rows=1 width=26) (never executed)

  • Index Cond: (runtimeeve0_.application_id = application_id)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using ev_metadata_uc_ev_id on ev_metadata runtimeeve1_ (cost=0.42..1.51 rows=1 width=1,930) (never executed)

  • Index Cond: (runtimeeve0_.ev_id = ev_id)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using evs_email_message_ev_id_uc on evs_email_message runtimeeve2_ (cost=0.42..1.22 rows=1 width=103) (never executed)

  • Index Cond: (runtimeeve0_.ev_id = ev_id)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using comm_comm_ev_id_pidx on comm runtimeeve3_ (cost=0.42..0.67 rows=1 width=26) (never executed)

  • Index Cond: (runtimeeve0_.ev_id = comm_ev_id)
Planning time : 8.366 ms
Execution time : 634.560 ms