explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XAh8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=1,891,903.23..1,891,903.24 rows=1 width=36) (actual rows= loops=)

2.          

Initplan (forLimit)

3. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.03 rows=1 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.03 rows=1 width=0) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=1,891,903.17..1,891,903.17 rows=1 width=36) (actual rows= loops=)

  • Sort Key: (COALESCE(sum(count), 0::bigint))
6. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,891,903.15..1,891,903.16 rows=1 width=36) (actual rows= loops=)

  • Group Key: reason
7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on paymentaggregationdaily acquirer_response (cost=1,348,368.58..1,891,896.01 rows=1,427 width=36) (actual rows= loops=)

  • Recheck Cond: ((date >= $0) AND (date < $1))
  • Filter: (CASE WHEN (result = 0) THEN 'Unknown'::text WHEN (result = 1) THEN 'Approved'::text WHEN (result = 2) THEN 'Refused'::text WHEN (result = 4) THEN 'Error'::text ELSE NULL::text END = 'Refused'::text)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pad_txvariantid_date_idx (cost=0.00..1,348,368.23 rows=285,316 width=0) (actual rows= loops=)

  • Index Cond: ((date >= $0) AND (date < $1))