explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cn3r

Settings
# exclusive inclusive rows x rows loops node
1. 5.004 789.484 ↑ 1.0 290 1

Sort (cost=36.72..37.45 rows=290 width=129) (actual time=787.572..789.484 rows=290 loops=1)

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

Hash Semi Join (cost=10.53..24.86 rows=290 width=129) (actual time=5.163..784.480 rows=290 loops=1)

  • Hash Cond: (store_profiles.sha256 = store_market.sha256)
3. 2.301 2.301 ↑ 1.0 290 1

Seq Scan on store_profiles (cost=0.00..8.90 rows=290 width=90) (actual time=0.018..2.301 rows=290 loops=1)

4. 2.515 4.950 ↑ 1.0 290 1

Hash (cost=6.90..6.90 rows=290 width=65) (actual time=4.944..4.950 rows=290 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
5. 2.435 2.435 ↑ 1.0 290 1

Seq Scan on store_market (cost=0.00..6.90 rows=290 width=65) (actual time=0.016..2.435 rows=290 loops=1)

Planning time : 0.458 ms
Execution time : 791.607 ms