explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O6ox

Settings
# exclusive inclusive rows x rows loops node
1. 0.066 0.650 ↑ 1.0 1 1

Aggregate (cost=8.72..8.73 rows=1 width=8) (actual time=0.650..0.650 rows=1 loops=1)

2. 0.584 0.584 ↓ 213.0 213 1

Index Only Scan using _trn_batch on transactions (cost=0.69..8.71 rows=1 width=0) (actual time=0.055..0.584 rows=213 loops=1)

  • Index Cond: ((trn_external_ter_id = '40605704'::text) AND (trn_hst_id = 23) AND (trn_external_mer_id_close = '40605704'::text) AND (trn_bat_number_external = 741))
  • Heap Fetches: 213
Planning time : 0.267 ms