explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TvPt

Settings
# exclusive inclusive rows x rows loops node
1. 3,462.473 3,471.638 ↑ 1.3 18,944 1

Bitmap Heap Scan on transactions_new (cost=595.95..85,565.39 rows=23,874 width=317) (actual time=14.444..3,471.638 rows=18,944 loops=1)

  • Recheck Cond: ((entity_number)::text = ANY ('{0881433564,0881451369,0881464198,0881471098,0882287932,0882290338,2618480057,2618491497,2618502169,2618502761,2618504377,2618512633,3166173993,3166514281,3647260793,3647365977,3655132633,3655136889,3655146425,3655151033,3655160777,3655169785,3655184457,3655189593,3655193753,3655203433,3655204857,3655212985,3655216889,3655218249,3655219641,3655223817,3655226729,3655267385,3655279337,3655286681,3655365721,3655371257,3655430649,3655451145,3655455177,3655463049,3655468233,3655481241,3655487753,3655501449,3655512937,3655527065}'::text[]))
  • Heap Blocks: exact=16027
2. 9.165 9.165 ↑ 1.3 18,944 1

Bitmap Index Scan on transactions_new_entity_number_transaction_date_idx (cost=0.00..589.98 rows=23,874 width=0) (actual time=9.165..9.165 rows=18,944 loops=1)

  • Index Cond: ((entity_number)::text = ANY ('{0881433564,0881451369,0881464198,0881471098,0882287932,0882290338,2618480057,2618491497,2618502169,2618502761,2618504377,2618512633,3166173993,3166514281,3647260793,3647365977,3655132633,3655136889,3655146425,3655151033,3655160777,3655169785,3655184457,3655189593,3655193753,3655203433,3655204857,3655212985,3655216889,3655218249,3655219641,3655223817,3655226729,3655267385,3655279337,3655286681,3655365721,3655371257,3655430649,3655451145,3655455177,3655463049,3655468233,3655481241,3655487753,3655501449,3655512937,3655527065}'::text[]))
Planning time : 2.573 ms