explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h51V

Settings
# exclusive inclusive rows x rows loops node
1. 2,860.165 2,879.286 ↓ 6,314.7 18,944 1

Bitmap Heap Scan on transactions_new (cost=689.93..702.13 rows=3 width=317) (actual time=45.712..2,879.286 rows=18,944 loops=1)

  • Recheck Cond: (((client_id)::text = 'КТКЮ000183'::text) AND ((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. 3.906 19.121 ↓ 0.0 0 1

BitmapAnd (cost=689.93..689.93 rows=3 width=0) (actual time=19.121..19.121 rows=0 loops=1)

3. 8.098 8.098 ↓ 5.2 18,962 1

Bitmap Index Scan on transactions_new_client_id_transaction_date_idx (cost=0.00..99.70 rows=3,618 width=0) (actual time=8.098..8.098 rows=18,962 loops=1)

  • Index Cond: ((client_id)::text = 'КТКЮ000183'::text)
4. 7.117 7.117 ↑ 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=7.117..7.117 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.116 ms