explain.depesz.com

PostgreSQL's explain analyze made readable

Result: btw5

Settings
# exclusive inclusive rows x rows loops node
1. 73.884 298.073 ↑ 1.0 100 1

Hash Right Join (cost=442.82..795.91 rows=100 width=181) (actual time=294.114..298.073 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. 66.889 66.889 ↑ 1.0 10,303 1

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

3. 79.871 157.300 ↑ 1.0 10,303 1

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

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

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

Planning time : 4.218 ms
Execution time : 298.749 ms