explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xAJc

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 1.102 ↓ 100.0 100 1

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

2. 0.291 1.091 ↓ 100.0 100 1

Bitmap Heap Scan on transactions (cost=29.62..30.63 rows=1 width=1,963) (actual time=0.915..1.091 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.077 0.800 ↓ 0.0 0 1

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

4. 0.228 0.228 ↓ 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.227..0.228 rows=1,074 loops=1)

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

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

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