explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LMvd

Settings
# exclusive inclusive rows x rows loops node
1. 10.210 6,212.067 ↑ 31.3 3 1

HashAggregate (cost=111,952.61..111,953.55 rows=94 width=21) (actual time=6,212.067..6,212.067 rows=3 loops=1)

  • Group Key: tn_event_key
2. 6,064.470 6,201.857 ↑ 1.2 28,008 1

Bitmap Heap Scan on tn_event (cost=27,792.34..111,789.62 rows=32,597 width=13) (actual time=140.763..6,201.857 rows=28,008 loops=1)

  • Recheck Cond: (((tn_event_key)::text = ANY ('{FinancialPay,FinancialExpire,FinancialBrows}'::text[])) AND (date >= '2020-07-01'::date) AND (date <= '2020-08-02'::date))
  • Rows Removed by Index Recheck: 965
  • Heap Blocks: exact=19,358
3. 1.419 137.387 ↓ 0.0 0 1

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

4. 11.966 11.966 ↓ 1.0 55,926 1

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

  • Index Cond: ((tn_event_key)::text = ANY ('{FinancialPay,FinancialExpire,FinancialBrows}'::text[]))
5. 124.002 124.002 ↑ 1.0 1,258,291 1

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

  • Index Cond: ((date >= '2020-07-01'::date) AND (date <= '2020-08-02'::date))
Planning time : 0.185 ms
Execution time : 6,213.215 ms