explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tE39

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

Unique (cost=208,822.37..208,822.38 rows=1 width=45) (actual time=997.885..997.887 rows=1 loops=1)

2. 0.019 997.885 ↓ 3.0 3 1

Sort (cost=208,822.37..208,822.38 rows=1 width=45) (actual time=997.883..997.885 rows=3 loops=1)

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

Nested Loop (cost=0.86..208,822.36 rows=1 width=45) (actual time=45.064..997.866 rows=3 loops=1)

4. 997.769 997.769 ↓ 3.0 3 1

Index Scan using tx_st on transaction t1 (cost=0.43..208,813.91 rows=1 width=37) (actual time=45.022..997.769 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.066 0.066 ↑ 1.0 1 3

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

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