explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iDsB : Optimization for: Optimization for: Optimization for: plan #5ORW; plan #KlIr; plan #fYi1

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.023 ↓ 0.0 0 1

GroupAggregate (cost=6.42..6.46 rows=1 width=52) (actual time=0.023..0.023 rows=0 loops=1)

  • Group Key: ((c.started)::date)
2. 0.011 0.022 ↓ 0.0 0 1

Sort (cost=6.42..6.42 rows=1 width=11) (actual time=0.022..0.022 rows=0 loops=1)

  • Sort Key: ((c.started)::date)
  • Sort Method: quicksort Memory: 25kB
3. 0.011 0.011 ↓ 0.0 0 1

Index Scan using tx_mid on transaction c (cost=0.28..6.41 rows=1 width=11) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((merchant_id)::text = '47970b47-a1ce-4230-bd02-1fabe6dc9398'::text)
  • Filter: ((started >= '2020-04-01 00:00:00'::timestamp without time zone) AND (started <= '2020-04-30 23:00:00'::timestamp without time zone) AND ((tx_result_id)::text = ANY ('{1,0}'::text[])) AND ((acquirer_id)::text = 'RM'::text) AND ((merchant_account_id)::text = '082d039c-f457-461f-9a08-dcc1f1c34419'::text) AND ((tx_type_id)::text = ANY ('{2,3,14}'::text[])))