explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VHLv

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 283.736 ↓ 0.0 0 1

Update on _sales_potential_earnings (cost=330,279.68..678,731.4 rows=1 width=299) (actual time=283.736..283.736 rows=0 loops=1)

  • Buffers: shared hit=239, local hit=1 read=73241
2. 0.024 283.734 ↓ 0.0 0 1

Hash Join (cost=330,279.68..678,731.4 rows=1 width=299) (actual time=283.734..283.734 rows=0 loops=1)

  • Buffers: shared hit=239, local hit=1 read=73241
3. 159.375 159.375 ↑ 3,825,869.0 1 1

Seq Scan on _sales_potential_earnings _sales_potential_earnings (cost=0..319,757.69 rows=3,825,869 width=249) (actual time=159.375..159.375 rows=1 loops=1)

  • Buffers: local read=36621
4. 0.000 124.335 ↓ 0.0 0 1

Hash (cost=330,279.66..330,279.66 rows=1 width=114) (actual time=124.335..124.335 rows=0 loops=1)

  • Buffers: shared hit=239, local hit=1 read=36620
5. 0.003 124.335 ↓ 0.0 0 1

Nested Loop (cost=296.42..330,279.66 rows=1 width=114) (actual time=124.334..124.335 rows=0 loops=1)

  • Buffers: shared hit=239, local hit=1 read=36620
6. 0.022 124.332 ↓ 0.0 0 1

Hash Join (cost=296.28..330,104.31 rows=668 width=96) (actual time=124.332..124.332 rows=0 loops=1)

  • Buffers: shared hit=239, local hit=1 read=36620
7. 123.053 123.053 ↑ 3,825,869.0 1 1

Seq Scan on _sales_potential_earnings x (cost=0..319,757.69 rows=3,825,869 width=90) (actual time=123.053..123.053 rows=1 loops=1)

  • Buffers: local hit=1 read=36620
8. 0.001 1.257 ↓ 0.0 0 1

Hash (cost=296.27..296.27 rows=1 width=38) (actual time=1.257..1.257 rows=0 loops=1)

  • Buffers: shared hit=239
9. 1.256 1.256 ↓ 0.0 0 1

Seq Scan on company c (cost=0..296.27 rows=1 width=38) (actual time=1.256..1.256 rows=0 loops=1)

  • Filter: (c.tax_type_id IS NOT NULL)
  • Buffers: shared hit=239
10. 0.000 0.000 ↓ 0.0 0 0

Index Scan using tax_type_rate_excl on tax_type_rate ttr (cost=0.14..0.21 rows=4 width=86) (never executed)

  • Index Cond: (ttr.date_range @> x.sale_reporting_date)
Planning time : 3.412 ms
Execution time : 283.882 ms