explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dqgN

Settings
# exclusive inclusive rows x rows loops node
1. 2,761.147 11,338.377 ↑ 1.5 4,371,722 1

Gather (cost=1,416,361.12..2,746,109.88 rows=6,679,155 width=1,289) (actual time=6,352.526..11,338.377 rows=4,371,722 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • JIT:
  • Functions: 70
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 19.521 ms, Inlining 192.270 ms, Optimization 1436.627 ms, Emission 813.480 ms, Total 2461.898 ms
2. 3,343.523 8,577.230 ↑ 1.9 874,344 5 / 5

Parallel Hash Left Join (cost=1,415,361.12..2,077,194.38 rows=1,669,789 width=1,289) (actual time=6,313.567..8,577.230 rows=874,344 loops=5)

  • Hash Cond: (positions.id = transactions.position_id)
3. 863.853 863.853 ↑ 1.3 869,664 5 / 5

Parallel Seq Scan on positions (cost=0.00..344,204.50 rows=1,087,100 width=532) (actual time=0.173..863.853 rows=869,664 loops=5)

  • Filter: (date_stop >= CURRENT_DATE)
4. 1,725.653 4,369.854 ↑ 1.3 1,323,312 5 / 5

Parallel Hash (cost=1,233,053.75..1,233,053.75 rows=1,669,789 width=765) (actual time=4,369.853..4,369.854 rows=1,323,312 loops=5)

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

Parallel Seq Scan on transactions (cost=0.00..1,233,053.75 rows=1,669,789 width=765) (actual time=489.143..2,644.201 rows=1,323,312 loops=5)

  • Filter: (active AND action AND (date_stop >= CURRENT_DATE))
  • Rows Removed by Filter: 562,479
Planning time : 1.649 ms
Execution time : 12,899.088 ms