explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fnel

Settings
# exclusive inclusive rows x rows loops node
1. 280.476 1,342.885 ↓ 2.2 35,304 1

Aggregate (cost=184,858.56..185,214 rows=15,797 width=44) (actual time=1,291.167..1,342.885 rows=35,304 loops=1)

  • Buffers: shared hit=46839 read=115935
2. 114.357 1,062.409 ↓ 1.3 81,739 1

Gather (cost=176,999.56..183,594.8 rows=63,188 width=108) (actual time=985.796..1,062.409 rows=81,739 loops=1)

  • Buffers: shared hit=46839 read=115935
3. 313.176 948.052 ↓ 1.0 16,348 5

Aggregate (cost=175,999.56..176,276 rows=15,797 width=108) (actual time=908.271..948.052 rows=16,348 loops=5)

  • Buffers: shared hit=46839 read=115935
4. 177.811 634.876 ↓ 16.0 634,889 5

Hash Join (cost=2.11..175,503.49 rows=39,685 width=26) (actual time=34.943..634.876 rows=634,889 loops=5)

  • Buffers: shared hit=46839 read=115935
5. 456.989 456.989 ↑ 1.3 666,193 5

Seq Scan on fact_accrual fact_accrual (cost=0..171,102.92 rows=833,392 width=34) (actual time=34.589..456.989 rows=666,193 loops=5)

  • Buffers: shared hit=46834 read=115935
6. 0.008 0.076 ↑ 1.0 21 5

Hash (cost=1.79..1.79 rows=21 width=8) (actual time=0.075..0.076 rows=21 loops=5)

  • Buffers: shared hit=5
7. 0.024 0.068 ↑ 1.0 21 5

Aggregate (cost=1.38..1.58 rows=21 width=8) (actual time=0.065..0.068 rows=21 loops=5)

  • Buffers: shared hit=5
8. 0.044 0.044 ↑ 1.0 25 5

Seq Scan on dim_accrual_run dim_accrual_run (cost=0..1.25 rows=25 width=8) (actual time=0.041..0.044 rows=25 loops=5)

  • Buffers: shared hit=5
Planning time : 0.572 ms
Execution time : 1,359.862 ms