explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XlVQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.318 ↑ 1.0 100 1

Limit (cost=0.43..32.71 rows=100 width=1,963) (actual time=0.021..0.318 rows=100 loops=1)

2. 0.305 0.305 ↑ 7.0 100 1

Index Scan using index_transactions_on_created_at on transactions (cost=0.43..228.00 rows=705 width=1,963) (actual time=0.020..0.305 rows=100 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 <> ALL ('{created,pending,processing}'::text[])))
Planning time : 0.573 ms
Execution time : 0.349 ms