explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9ken

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 2.153 ↓ 100.0 100 1

Limit (cost=29.62..30.63 rows=1 width=1,963) (actual time=1.497..2.153 rows=100 loops=1)

2. 0.792 2.135 ↓ 100.0 100 1

Bitmap Heap Scan on transactions (cost=29.62..30.63 rows=1 width=1,963) (actual time=1.496..2.135 rows=100 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))
  • Heap Blocks: exact=100
3. 0.090 1.343 ↓ 0.0 0 1

BitmapAnd (cost=29.62..29.62 rows=1 width=0) (actual time=1.343..1.343 rows=0 loops=1)

4. 0.448 0.448 ↓ 1.8 1,074 1

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

  • Index Cond: ((payment_status)::text = ANY ('{created,pending,processing}'::text[]))
5. 0.805 0.805 ↓ 1.6 3,080 1

Bitmap Index Scan on index_transactions_on_created_at (cost=0.00..20.55 rows=1,883 width=0) (actual time=0.805..0.805 rows=3,080 loops=1)

  • Index Cond: (created_at > '2020-06-19 03:49:49.826264'::timestamp without time zone)
Planning time : 1.135 ms
Execution time : 2.249 ms