explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BtJB : Optimization for: plan #1YtQ

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.243 2.015 ↓ 0.0 208 1

Sort row IDs: users.locum DESC, concat(users.last_name,' ',users.first_name) (cost=57.60 rows=556) (cost=0..0 rows=0 width=0) (actual time=1.136..2.015 rows=208 loops=1)

2. 0.172 0.772 ↓ 0.0 208 1

Filter: ((users.tenant_id = 2) and (users.id in (422,130,134,431,438,60,21,457,461,222,180,414,102,101,473,106,446,118,439,413,444,404,418,104,420,133,410,419,111,85,137,402,426,474,412,79,25,405,475,143,75,42,51,80,427,97,43,472,407,430,56,148,149,124,141,432,434,84,433,94,142,33,55,448,440,69,22,411,28,147,93,125,96,131,408,123,98,61,62,19,68,145,120,103,297,424,417,400,425,140,401,29,443,441,16,35,74,476,26,20,31,15,406,83,36,466,196,212,467,261,209,195,257,81,201,197,246,462,153,213,210,263,248,251,265,245,458,208,256,200,253,121,243,478,194,452,454,234,464,64,198,189,451,459,224,233,259,218,479,65,9,58,456,193,183,186,468,273,217,320,255,175,463,178,214,187,262,95,89,99,82,429,24,403,445,204,450,252,465,428,330,415,237,528,311,460,18,421,78,34,70,442,241,226,470,13,11,325,229,53,136,192,409,27,341,135,447,254))) (cost=0..0 rows=0 width=0) (actual time=0.079..0.772 rows=208 loops=1)

3. 0.600 0.600 ↓ 0.0 607 1

Table scan on users (cost=0..0 rows=0 width=0) (actual time=0.069..0.600 rows=607 loops=1)