explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5ORW

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.021 ↓ 0.0 0 1

GroupAggregate (cost=6.42..6.45 rows=1 width=52) (actual time=0.021..0.021 rows=0 loops=1)

  • Group Key: ((c.started)::date)
2. 0.012 0.021 ↓ 0.0 0 1

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

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

Index Scan using tx_mid on transaction c (cost=0.28..6.41 rows=1 width=11) (actual time=0.009..0.009 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 ((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[])))