explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GLvd

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

Unique (cost=205,633.33..205,633.34 rows=1 width=45) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=205,633.33..205,633.33 rows=1 width=45) (actual rows= loops=)

  • Sort Key: t0.ccnumber_hash
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..205,633.32 rows=1 width=45) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using tx_st on transaction t1 (cost=0.43..205,624.86 rows=1 width=37) (actual rows= loops=)

  • Index Cond: ((started >= '2019-08-10 13:11:57.897'::timestamp without time zone) AND (started <= '2019-09-09 13:11:57.897'::timestamp without time zone))
  • Filter: (((tx_type_id)::text = ANY ('{3,1}'::text[])) AND ((merchant_user_id)::text = '115866451'::text) AND ((merchant_id)::text = '66d9f1c9-576c-4912-b604-6dc476a7b985'::text) AND ((merchant_account_id)::text = '69c378a4-a4e7-4b94-81f2-367deda418b6'::text) AND ((tx_result_id)::text = '1'::text))
5. 0.000 0.000 ↓ 0.0

Index Scan using cc_pkey on cc t0 (cost=0.43..8.45 rows=1 width=82) (actual rows= loops=)

  • Index Cond: ((id)::text = (t1.cc_id)::text)