explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sBR0S

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.521 ↓ 0.0 0 1

Limit (cost=21.88..22.90 rows=1 width=1,963) (actual time=0.521..0.521 rows=0 loops=1)

2. 0.003 0.520 ↓ 0.0 0 1

Bitmap Heap Scan on transactions (cost=21.88..22.90 rows=1 width=1,963) (actual time=0.520..0.520 rows=0 loops=1)

  • Recheck Cond: (((payment_status)::text = ANY ('{created,pending,processing}'::text[])) AND (created_at > '2020-06-19 03:49:49.826264'::timestamp without time zone) AND (created_at <= '2020-06-26 03:49:49.827019'::timestamp without time zone))
  • Filter: ((expiry_time < '2020-07-03 03:49:49.827014'::timestamp without time zone) OR (expiry_time IS NULL))
3. 0.049 0.517 ↓ 0.0 0 1

BitmapAnd (cost=21.88..21.88 rows=1 width=0) (actual time=0.517..0.517 rows=0 loops=1)

4. 0.194 0.194 ↓ 1.6 956 1

Bitmap Index Scan on index_payment_status_on_transactions (cost=0.00..8.81 rows=602 width=0) (actual time=0.194..0.194 rows=956 loops=1)

  • Index Cond: ((payment_status)::text = ANY ('{created,pending,processing}'::text[]))
5. 0.274 0.274 ↓ 1.5 1,389 1

Bitmap Index Scan on index_transactions_on_created_at (cost=0.00..12.82 rows=939 width=0) (actual time=0.274..0.274 rows=1,389 loops=1)

  • Index Cond: ((created_at > '2020-06-19 03:49:49.826264'::timestamp without time zone) AND (created_at <= '2020-06-26 03:49:49.827019'::timestamp without time zone))
Planning time : 0.965 ms
Execution time : 0.586 ms