explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pIDq

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

Nested Loop (cost=187.32..187.37 rows=1 width=64) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Aggregate (cost=87.99..88.00 rows=1 width=5) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transaction t (cost=54.11..87.98 rows=3 width=5) (actual rows= loops=)

  • Recheck Cond: (((acquirer_id)::text = 'PP'::text) AND ((merchant_id)::text = '054a109b-5976-42b6-ba28-06dfc2b9f750'::text))
  • Filter: (((tx_type_id)::text = '3'::text) AND ((tx_result_id)::text = '1'::text))
4. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=54.11..54.11 rows=9 width=0) (actual rows= loops=)

5. 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)
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)
7. 0.000 0.000 ↓ 0.0

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

8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transaction t_1 (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)
9. 0.000 0.000 ↓ 0.0

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

10. 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)
11. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((tx_type_id)::text = ANY ('{5,8}'::text[]))
12. 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)