explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BK0h

Settings
# exclusive inclusive rows x rows loops node
1. 48,581.104 108,622.078 ↑ 1.6 4,367,207 1

Gather (cost=1,420,228.47..2,765,746.27 rows=6,810,093 width=1,289) (actual time=7,494.971..108,622.078 rows=4,367,207 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Functions: 70
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 19.567 ms, Inlining 240.994 ms, Optimization 1661.696 ms, Emission 922.089 ms, Total 2844.346 ms
2. 54,716.921 60,040.974 ↑ 1.9 873,441 5 / 5

Parallel Hash Left Join (cost=1,419,228.47..2,083,736.97 rows=1,702,523 width=1,289) (actual time=7,405.281..60,040.974 rows=873,441 loops=5)

  • Hash Cond: (positions.id = transactions.position_id)
3. 823.673 823.673 ↑ 1.3 868,761 5 / 5

Parallel Seq Scan on positions (cost=0.00..343,832.61 rows=1,085,974 width=532) (actual time=0.151..823.673 rows=868,761 loops=5)

  • Filter: (date_stop >= CURRENT_DATE)
4. 1,735.993 4,500.380 ↑ 1.3 1,323,003 5 / 5

Parallel Hash (cost=1,233,346.93..1,233,346.93 rows=1,702,523 width=765) (actual time=4,500.380..4,500.380 rows=1,323,003 loops=5)

  • Buckets: 131,072 Batches: 64 Memory Usage: 50,720kB
5. 2,764.387 2,764.387 ↑ 1.3 1,323,003 5 / 5

Parallel Seq Scan on transactions (cost=0.00..1,233,346.93 rows=1,702,523 width=765) (actual time=565.662..2,764.387 rows=1,323,003 loops=5)

  • Filter: (active AND action AND (date_stop >= CURRENT_DATE))
  • Rows Removed by Filter: 562,330
Execution time : 109,567.500 ms