explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qe7m

Settings
# exclusive inclusive rows x rows loops node
1. 0.187 6.417 ↓ 1.3 936 1

Hash Join (cost=77.20..1,305.48 rows=695 width=252) (actual time=0.569..6.417 rows=936 loops=1)

  • Hash Cond: (o.vendor_id = v.id)
2. 1.741 6.157 ↓ 1.3 936 1

Hash Join (cost=64.39..1,290.80 rows=695 width=208) (actual time=0.491..6.157 rows=936 loops=1)

  • Hash Cond: (o.id = om.order_id)
3. 3.937 3.937 ↑ 1.0 14,853 1

Seq Scan on t_order o (cost=0.00..1,089.50 rows=14,853 width=50) (actual time=0.006..3.937 rows=14,853 loops=1)

  • Filter: ((status)::text = ANY ('{CLOSED,PENDING_APPROVAL}'::text[]))
  • Rows Removed by Filter: 3,267
4. 0.191 0.479 ↓ 1.1 945 1

Hash (cost=53.79..53.79 rows=848 width=166) (actual time=0.478..0.479 rows=945 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 143kB
5. 0.288 0.288 ↓ 1.1 945 1

Seq Scan on t_ordermistake om (cost=0.00..53.79 rows=848 width=166) (actual time=0.004..0.288 rows=945 loops=1)

  • Filter: ((retired_date IS NULL) AND (cleared_date IS NULL) AND (created_date > '2015-01-01'::date) AND (created_date < '2020-01-01'::date))
  • Rows Removed by Filter: 441
6. 0.033 0.073 ↑ 1.0 214 1

Hash (cost=10.14..10.14 rows=214 width=28) (actual time=0.073..0.073 rows=214 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
7. 0.040 0.040 ↑ 1.0 214 1

Seq Scan on t_vendor v (cost=0.00..10.14 rows=214 width=28) (actual time=0.005..0.040 rows=214 loops=1)

Planning time : 0.353 ms
Execution time : 6.493 ms