explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vcic

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 85,665.200 ↓ 0.0 0 1

GroupAggregate (cost=4,779,183.39..4,779,217.53 rows=1,707 width=115) (actual time=85,665.200..85,665.200 rows=0 loops=1)

  • Group Key: f.customer_spk
2. 0.012 85,665.197 ↓ 0.0 0 1

Sort (cost=4,779,183.39..4,779,187.66 rows=1,707 width=108) (actual time=85,665.197..85,665.197 rows=0 loops=1)

  • Sort Key: f.customer_spk
  • Sort Method: quicksort Memory: 25kB
3. 1,191.625 85,665.185 ↓ 0.0 0 1

Hash Anti Join (cost=434,438.78..4,779,091.75 rows=1,707 width=108) (actual time=85,665.184..85,665.185 rows=0 loops=1)

  • Hash Cond: ((f.customer_spk)::text = (c.customer_spk)::text)
4. 81,332.351 81,332.351 ↑ 1.4 850,757 1

Seq Scan on consolidated_fact_order_details_full_calc f (cost=0.00..4,219,639.45 rows=1,163,571 width=108) (actual time=11,070.134..81,332.351 rows=850,757 loops=1)

  • Filter: ((source)::text = 'mx_beerhouse'::text)
  • Rows Removed by Filter: 26090182
5. 2,000.339 3,141.209 ↓ 1.0 6,826,248 1

Hash (cost=275,877.79..275,877.79 rows=6,822,079 width=62) (actual time=3,141.209..3,141.209 rows=6,826,248 loops=1)

  • Buckets: 4194304 Batches: 2 Memory Usage: 346728kB
6. 1,140.870 1,140.870 ↓ 1.0 6,826,249 1

Seq Scan on consolidated_dim_customer c (cost=0.00..275,877.79 rows=6,822,079 width=62) (actual time=0.005..1,140.870 rows=6,826,249 loops=1)

Planning time : 21.449 ms
Execution time : 85,686.843 ms