explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JCWU

Settings
# exclusive inclusive rows x rows loops node
1. 10,916.514 68,344.138 ↑ 1.5 4,371,689 1

Gather (cost=1,416,341.31..2,741,707.11 rows=6,679,060 width=1,289) (actual time=23,629.585..68,344.138 rows=4,371,689 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • JIT:
  • Functions: 65
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 13.960 ms, Inlining 234.427 ms, Optimization 1404.907 ms, Emission 820.256 ms, Total 2473.549 ms
2. 38,986.763 57,427.624 ↑ 1.9 874,338 5 / 5

Parallel Hash Left Join (cost=1,415,341.31..2,072,801.11 rows=1,669,765 width=1,289) (actual time=22,163.764..57,427.624 rows=874,338 loops=5)

  • Hash Cond: (positions.id = transactions.position_id)
  • Join Filter: (positions.date_stop >= CURRENT_DATE)
3. 13,748.708 13,748.708 ↑ 1.3 869,658 5 / 5

Parallel Seq Scan on positions (cost=0.00..338,767.97 rows=1,087,097 width=532) (actual time=0.153..13,748.708 rows=869,658 loops=5)

4. 1,930.178 4,692.153 ↑ 1.3 1,323,293 5 / 5

Parallel Hash (cost=1,233,036.25..1,233,036.25 rows=1,669,765 width=765) (actual time=4,692.153..4,692.153 rows=1,323,293 loops=5)

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

Parallel Seq Scan on transactions (cost=0.00..1,233,036.25 rows=1,669,765 width=765) (actual time=492.676..2,761.975 rows=1,323,293 loops=5)

  • Filter: (active AND action AND (date_stop >= CURRENT_DATE))
  • Rows Removed by Filter: 562,476
Planning time : 5.950 ms
Execution time : 70,143.994 ms