explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x8qd

Settings
# exclusive inclusive rows x rows loops node
1. 3,813.694 3,813.694 ↓ 6,314.7 18,944 1

Index Scan using transactions_new_client_id_entity_number_idx on transactions_new (cost=0.62..231.25 rows=3 width=317) (actual time=12.954..3,813.694 rows=18,944 loops=1)

  • Index 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[])))
Planning time : 3.605 ms