explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sMYZ

Settings
# exclusive inclusive rows x rows loops node
1. 11.779 810.346 ↑ 1.0 290 1

Sort (cost=22.21..22.94 rows=290 width=129) (actual time=804.559..810.346 rows=290 loops=1)

  • Sort Key: ((sp.info #>> '{title}'::text[])) DESC, ((sp.info #>> '{version}'::text[])) DESC
  • Sort Method: quicksort Memory: 97kB
2. 798.567 798.567 ↑ 1.0 290 1

Seq Scan on store_profiles sp (cost=0.00..10.35 rows=290 width=129) (actual time=0.233..798.567 rows=290 loops=1)

Planning time : 0.476 ms
Execution time : 814.159 ms