explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yTyx : Optimization for: Optimization for: Optimization for: plan #yUoW; plan #DDBr; plan #Vs0g

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,765.522 1,803,784.317 ↓ 6.0 6 1

HashAggregate (cost=19,247.04..19,247.05 rows=1 width=15) (actual time=1,803,784.309..1,803,784.317 rows=6 loops=1)

  • Group Key: payment_method
2. 1,802,018.795 1,802,018.795 ↓ 141.3 946,434 1

Index Scan using orders_idx_2 on orders (cost=0.57..19,096.32 rows=6,699 width=15) (actual time=0.072..1,802,018.795 rows=946,434 loops=1)

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