explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DAJd

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

Update on _sales_potential_earnings x (cost=296.42..330,279.67 rows=1 width=293) (actual time=149.436..149.436 rows=0 loops=1)

  • Buffers: shared hit=239, local read=36621
2. 0.002 149.434 ↓ 0.0 0 1

Nested Loop (cost=296.42..330,279.67 rows=1 width=293) (actual time=149.434..149.434 rows=0 loops=1)

  • Buffers: shared hit=239, local read=36621
3. 0.030 149.432 ↓ 0.0 0 1

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

  • Buffers: shared hit=239, local read=36621
4. 148.075 148.075 ↑ 3,825,869.0 1 1

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

  • Buffers: local read=36621
5. 0.001 1.327 ↓ 0.0 0 1

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

  • Buffers: shared hit=239
6. 1.326 1.326 ↓ 0.0 0 1

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

  • Filter: (c.tax_type_id IS NOT NULL)
  • Buffers: shared hit=239
7. 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 : 1.242 ms
Execution time : 149.656 ms