explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pucq

Settings
# exclusive inclusive rows x rows loops node
1. 85.045 250.082 ↑ 1.5 43,094 1

Gather (cost=1,876.69..195,830.36 rows=64,696 width=1,289) (actual time=44.307..250.082 rows=43,094 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Functions: 55
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 14.546 ms, Inlining 0.000 ms, Optimization 8.282 ms, Emission 112.301 ms, Total 135.128 ms
2. 20.124 165.037 ↑ 1.9 8,619 5 / 5

Nested Loop Left Join (cost=876.69..188,360.76 rows=16,174 width=1,289) (actual time=28.203..165.037 rows=8,619 loops=5)

3. 66.004 68.289 ↑ 1.2 8,514 5 / 5

Parallel Bitmap Heap Scan on positions (cost=876.25..116,248.34 rows=10,317 width=532) (actual time=28.112..68.289 rows=8,514 loops=5)

  • Recheck Cond: ((soato_code)::text = '1726262'::text)
  • Filter: (date_stop >= CURRENT_DATE)
  • Heap Blocks: exact=10,904
4. 2.285 2.285 ↓ 1.0 42,569 1 / 5

Bitmap Index Scan on positions_soato_code_index (cost=0.00..865.94 rows=41,267 width=0) (actual time=11.424..11.424 rows=42,569 loops=1)

  • Index Cond: ((soato_code)::text = '1726262'::text)
5. 76.624 76.624 ↑ 1.0 1 42,569 / 5

Index Scan using transactions_position_id_date_stop_active_action_index on transactions (cost=0.44..6.98 rows=1 width=765) (actual time=0.009..0.009 rows=1 loops=42,569)

  • Index Cond: ((position_id = positions.id) AND (date_stop >= CURRENT_DATE) AND (active = true) AND (action = true))
Execution time : 267.202 ms