explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xXKX

Settings
# exclusive inclusive rows x rows loops node
1. 192.118 198.399 ↓ 0.0 0 1

Update on transactions (cost=0.69..8.71 rows=1 width=1,347) (actual time=198.399..198.399 rows=0 loops=1)

2. 6.281 6.281 ↓ 213.0 213 1

Index Scan using _trn_batch on transactions (cost=0.69..8.71 rows=1 width=1,347) (actual time=0.178..6.281 rows=213 loops=1)

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