explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vtWT

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 263.517 ↓ 0.0 0 1

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

  • Buffers: shared hit=18 read=237, local read=36621
2. 0.001 263.514 ↓ 0.0 0 1

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

  • Buffers: shared hit=18 read=237, local read=36621
3. 0.423 263.513 ↓ 0.0 0 1

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

  • Buffers: shared hit=18 read=237, local read=36621
4. 254.329 254.329 ↑ 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=254.329..254.329 rows=1 loops=1)

  • Buffers: local read=36621
5. 0.002 8.761 ↓ 0.0 0 1

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

  • Buffers: shared hit=2 read=237
6. 8.759 8.759 ↓ 0.0 0 1

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

  • Filter: (c.tax_type_id IS NOT NULL)
  • Buffers: shared hit=2 read=237
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 : 3.2 ms
Execution time : 263.672 ms