explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Il9C

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

Limit (cost=0.43..220.12 rows=1 width=1,776) (actual time=3.016..3.016 rows=0 loops=1)

2. 3.015 3.015 ↓ 0.0 0 1

Index Scan using index_transactions_on_created_at on transactions (cost=0.43..220.12 rows=1 width=1,776) (actual time=3.015..3.015 rows=0 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))
  • Filter: (((expiry_time < '2020-07-03 03:49:49.827014'::timestamp without time zone) OR (expiry_time IS NULL)) AND ((payment_status)::text = ANY ('{created,pending,processing}'::text[])))
  • Rows Removed by Filter: 1,389
Planning time : 1.053 ms
Execution time : 3.046 ms