explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZmTN

Settings
# exclusive inclusive rows x rows loops node
1. 24.235 63.600 ↑ 1.0 20,200 1

Sort (cost=6,711.01..6,761.51 rows=20,200 width=497) (actual time=58.244..63.600 rows=20,200 loops=1)

  • Sort Key: (array_position('{130,70,65,118,121,8,147,82,160,182,176,129,157,188,84,144,153,104,5,58,192,142,125,85,132,57,163,191,146,150,88,71,40,21,122,183,33,34,152,197,164,195,196,83,76,139,100,32,106,119,72,12,60,24,63,193,162,179,43,171,140,181,186,66,105,126,158,56,123,168,107,116,96,166,81,1,161,77,114,165,170,148,154,13,173,90,28,124,68,184,120,178,133,16,128,59,187,36,20,17,145,101,138,102,47,149,75,159,200,62,115,91,50,7,69,30,141,185,52,2,198,175,167,86,53,10,74,113,35,9,137,87,18,190,44,98,194,45,31,174,89,97,46,110,151,156,54,92,25,42,169,22,94,61,143,134,14,49,199,3,15,38,112,109,117,180,78,4,103,136,26,131,27,23,67,189,6,29,172,51,11,177,93,135,19,155,39,48,73,55,80,37,111,41,79,127,95,99,108,64}'::integer[], client_id))
  • Sort Method: external merge Disk: 3,160kB
  • Buffers: shared hit=457, temp read=395 written=396
2. 39.365 39.365 ↑ 1.0 20,200 1

Seq Scan on devices d (cost=0.00..709.50 rows=20,200 width=497) (actual time=0.011..39.365 rows=20,200 loops=1)

  • Buffers: shared hit=457