explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oUHv

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

Unique (cost=205,638.16..205,638.17 rows=1 width=45) (actual time=912.651..912.655 rows=1 loops=1)

2. 0.018 912.653 ↓ 3.0 3 1

Sort (cost=205,638.16..205,638.16 rows=1 width=45) (actual time=912.650..912.653 rows=3 loops=1)

  • Sort Key: t0.ccnumber_hash
  • Sort Method: quicksort Memory: 25kB
3. 0.026 912.635 ↓ 3.0 3 1

Nested Loop (cost=0.86..205,638.15 rows=1 width=45) (actual time=38.470..912.635 rows=3 loops=1)

4. 912.564 912.564 ↓ 3.0 3 1

Index Scan using tx_st on transaction t1 (cost=0.43..205,629.69 rows=1 width=37) (actual time=38.448..912.564 rows=3 loops=1)

  • 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))
  • Rows Removed by Filter: 856425
5. 0.045 0.045 ↑ 1.0 1 3

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

  • Index Cond: ((id)::text = (t1.cc_id)::text)
Planning time : 0.557 ms
Execution time : 912.713 ms