explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2uTr

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

HashAggregate (cost=111,952.61..111,953.55 rows=94 width=21) (actual rows= loops=)

  • Group Key: tn_event_key
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on tn_event (cost=27,792.34..111,789.62 rows=32,597 width=13) (actual rows= loops=)

  • Recheck Cond: (((tn_event_key)::text = ANY ('{FinancialPay,FinancialExpire,FinancialBrows}'::text[])) AND (date >= '2020-07-01'::date) AND (date <= '2020-08-02'::date))
3. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=27,792.34..27,792.34 rows=32,597 width=0) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tn_event_key_index_1 (cost=0.00..1,288.99 rows=54,360 width=0) (actual rows= loops=)

  • Index Cond: ((tn_event_key)::text = ANY ('{FinancialPay,FinancialExpire,FinancialBrows}'::text[]))
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tn_event_date_index_0 (cost=0.00..26,486.80 rows=1,261,837 width=0) (actual rows= loops=)

  • Index Cond: ((date >= '2020-07-01'::date) AND (date <= '2020-08-02'::date))