explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tph8

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 73,514.106 ↑ 1.0 1 1

Limit (cost=0.00..711,974.12 rows=1 width=4) (actual time=73,507.999..73,514.106 rows=1 loops=1)

2. 73,514.104 73,514.104 ↑ 1.0 1 1

Seq Scan on transaction_entries (cost=0.00..711,974.12 rows=1 width=4) (actual time=73,507.998..73,514.104 rows=1 loops=1)

  • Filter: (((transaction_id)::text = '9J169642GD9795703'::text) AND ((status)::text = 'OK'::text) AND ((transaction_type)::text = 'CAPTURE'::text) AND ((gateway_adapter)
  • Rows Removed by Filter: 13574258