explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JXER

Settings
# exclusive inclusive rows x rows loops node
1. 0.236 7,906.776 ↑ 1.0 1 1

Aggregate (cost=810,616.70..810,616.71 rows=1 width=192) (actual time=7,906.776..7,906.776 rows=1 loops=1)

2. 7,906.540 7,906.540 ↓ 168.0 168 1

Index Scan using idx_dly_mailbox_domain_results_day_id_acc_slug_dom_name_action on report_daily_by_mailbox_domain_results (cost=0.69..810,616.67 rows=1 width=48) (actual time=0.999..7,906.540 rows=168 loops=1)

  • Index Cond: ((day_id >= 20191029) AND (day_id >= 20191231) AND (day_id <= 20200129) AND ((account_slug)::text = 'valimail'::text) AND ((mailbox_slug)::text = '113059415171801269747'::text))
Planning time : 5.249 ms
Execution time : 7,906.838 ms