explain.depesz.com

PostgreSQL's explain analyze made readable

Result: udJO

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,762.295 ↑ 1.0 1 1

Unique (cost=208,917.06..208,917.07 rows=1 width=45) (actual time=1,762.292..1,762.295 rows=1 loops=1)

2. 0.062 1,762.293 ↓ 3.0 3 1

Sort (cost=208,917.06..208,917.07 rows=1 width=45) (actual time=1,762.291..1,762.293 rows=3 loops=1)

  • Sort Key: t0.ccnumber_hash
  • Sort Method: quicksort Memory: 25kB
3. 0.034 1,762.231 ↓ 3.0 3 1

Nested Loop (cost=0.86..208,917.05 rows=1 width=45) (actual time=76.133..1,762.231 rows=3 loops=1)

4. 1,761.588 1,761.588 ↓ 3.0 3 1

Index Scan using tx_st on transaction t1 (cost=0.43..208,908.60 rows=1 width=37) (actual time=75.548..1,761.588 rows=3 loops=1)

  • Index Cond: ((started >= '2019-08-10 05:02:57.897'::timestamp without time zone) AND (started <= '2019-09-09 15:02: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))
  • Rows Removed by Filter: 872180
5. 0.609 0.609 ↑ 1.0 1 3

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

  • Index Cond: ((id)::text = (t1.cc_id)::text)
Planning time : 3.804 ms
Execution time : 1,762.395 ms