explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QSSH

Settings
# exclusive inclusive rows x rows loops node
1. 0.528 284,214.254 ↑ 1.0 1 1

Aggregate (cost=81,531.73..81,531.74 rows=1 width=8) (actual time=284,214.254..284,214.254 rows=1 loops=1)

2. 284,213.726 284,213.726 ↓ 446.0 892 1

Index Scan using idx_team_stats_message_count on menu_data (cost=0.57..81,531.72 rows=2 width=8) (actual time=3,544.012..284,213.726 rows=892 loops=1)

  • Index Cond: ((datatype = ANY ('{message,encounterEvent}'::menu_data_type[])) AND ((string04)::text = 'UNREAD'::text))
  • Filter: ((NOT deleted) AND (date(persisteddate) = '2019-06-02'::date) AND (((route)::character varying(255))::text = 'HL7_API'::text))
  • Rows Removed by Filter: 2390000