explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aSEh

Settings
# exclusive inclusive rows x rows loops node
1. 75.665 332.244 ↑ 1.0 100 1

Hash Right Join (cost=442.82..795.91 rows=100 width=181) (actual time=328.089..332.244 rows=100 loops=1)

  • Hash Cond: (matches.id = orders.match_id)
  • Filter: ((orders.match_id IS NULL) OR ((matches.reconciliation_status)::text = 'unreconciled'::text))
  • Rows Removed by Filter: 10,203
2. 68.685 68.685 ↑ 1.0 10,303 1

Seq Scan on matches (cost=0.00..326.03 rows=10,303 width=73) (actual time=0.613..68.685 rows=10,303 loops=1)

3. 94.540 187.894 ↑ 1.0 10,303 1

Hash (cost=314.03..314.03 rows=10,303 width=108) (actual time=187.888..187.894 rows=10,303 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,577kB
4. 93.354 93.354 ↑ 1.0 10,303 1

Seq Scan on orders (cost=0.00..314.03 rows=10,303 width=108) (actual time=0.491..93.354 rows=10,303 loops=1)

Planning time : 4.566 ms
Execution time : 332.951 ms