explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V8vB : Optimization for: plan #YmPG

Settings

Optimization path:

Optimization(s) for this plan:

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

Aggregate (cost=99.32..99.33 rows=1 width=5) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transaction t (cost=95.30..99.32 rows=1 width=5) (actual rows= loops=)

  • Recheck Cond: (((acquirer_id)::text = 'PP'::text) AND ((tx_type_id)::text = ANY ('{5,8}'::text[])) AND ((merchant_id)::text = '054a109b-5976-42b6-ba28-06dfc2b9f750'::text))
  • Filter: ((tx_result_id)::text = '1'::text)
3. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=95.30..95.30 rows=1 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tx_acqid (cost=0.00..9.41 rows=150 width=0) (actual rows= loops=)

  • Index Cond: ((acquirer_id)::text = 'PP'::text)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tx_typ (cost=0.00..40.94 rows=1,117 width=0) (actual rows= loops=)

  • Index Cond: ((tx_type_id)::text = ANY ('{5,8}'::text[]))
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tx_mid (cost=0.00..44.45 rows=555 width=0) (actual rows= loops=)

  • Index Cond: ((merchant_id)::text = '054a109b-5976-42b6-ba28-06dfc2b9f750'::text)