explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7TDo

Settings
# exclusive inclusive rows x rows loops node
1. 360.052 16,161.905 ↓ 1.4 14,214 1

Sort (cost=67,881.93..67,906.56 rows=9,855 width=82) (actual time=16,020.114..16,161.905 rows=14,214 loops=1)

  • Sort Key: product.name
  • Sort Method: quicksort Memory: 2749kB
2. 536.017 15,801.853 ↓ 1.4 14,214 1

Index Scan using product_exchang_28f5bc_idx on product (cost=0.29..67,228.21 rows=9,855 width=82) (actual time=0.962..15,801.853 rows=14,214 loops=1)

  • Index Cond: (exchange_id = ANY ('{1,2,3,4,5,6,8,9,10,11,12,7,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,64,55,56,57,58,59,60,61,62,63,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92}'::integer[]))
3.          

SubPlan (forIndex Scan)

4. 7,234.926 15,265.836 ↑ 1.0 1 14,214

Aggregate (cost=6.71..6.72 rows=1 width=8) (actual time=1.063..1.074 rows=1 loops=14,214)

5. 504.981 8,030.910 ↓ 0.0 0 14,214

Hash Join (cost=3.21..6.69 rows=7 width=4) (actual time=0.564..0.565 rows=0 loops=14,214)

  • Hash Cond: (u0.trade_id = u1.id)
6. 6.723 6.723 ↑ 1.5 76 9

Seq Scan on tradeexception u0 (cost=0.00..3.12 rows=112 width=4) (actual time=0.056..0.747 rows=76 loops=9)

7. 7,121.214 7,519.206 ↓ 0.0 0 14,214

Hash (cost=3.20..3.20 rows=1 width=8) (actual time=0.529..0.529 rows=0 loops=14,214)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
8. 397.992 397.992 ↓ 0.0 0 14,214

Seq Scan on trade u1 (cost=0.00..3.20 rows=1 width=8) (actual time=0.028..0.028 rows=0 loops=14,214)

  • Filter: (product_id = product.id)
  • Rows Removed by Filter: 16