explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WtEv

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 3,296.639 ↓ 0.0 0 1

Limit (cost=303,913.54..303,913.55 rows=1 width=1,300) (actual time=3,296.639..3,296.639 rows=0 loops=1)

2.          

CTE system_emails_cte

3. 735.492 735.492 ↓ 1.0 1,683,233 1

Index Scan using idx_se_sent_on on system_emails (cost=0.58..197,991.55 rows=1,629,569 width=404) (actual time=0.023..735.492 rows=1,683,233 loops=1)

  • Index Cond: (sent_on > (now() - '3 days'::interval))
4. 0.004 3,296.638 ↓ 0.0 0 1

Sort (cost=105,921.99..105,922.00 rows=1 width=1,300) (actual time=3,296.638..3,296.638 rows=0 loops=1)

  • Sort Key: system_emails_cte.id DESC
  • Sort Method: quicksort Memory: 25kB
5. 3,296.634 3,296.634 ↓ 0.0 0 1

CTE Scan on system_emails_cte (cost=0.00..105,921.99 rows=1 width=1,300) (actual time=3,296.634..3,296.634 rows=0 loops=1)

  • Filter: ((to_email_address ~~* 'system@entrata.com'::text) AND ((subject)::text ~~* '%Your delivery was picked up!%'::text))
  • Rows Removed by Filter: 1683233