explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ujBZ

Settings
# exclusive inclusive rows x rows loops node
1. 1,834.961 2,184,765.185 ↓ 6.0 6 1

HashAggregate (cost=72,198.03..72,198.04 rows=1 width=15) (actual time=2,184,765.184..2,184,765.185 rows=6 loops=1)

  • Group Key: payment_method
2. 2,182,930.224 2,182,930.224 ↓ 141.3 946,433 1

Index Scan using eqnx_orders_idx_tmp on orders (cost=0.57..72,047.32 rows=6,698 width=15) (actual time=33.735..2,182,930.224 rows=946,433 loops=1)

  • Index Cond: (created_at >= (('now'::cstring)::date - '180 days'::interval day))
  • Filter: ((state = ANY ('{7,8}'::integer[])) AND ((epay_flag)::text = ANY ('{1,2,4}'::text[])) AND ((created_at)::date < ('now'::cstring)::date))
  • Rows Removed by Filter: 1,135,870
Planning time : 1.006 ms