explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fDMu

Settings
# exclusive inclusive rows x rows loops node
1. 0.130 7.976 ↑ 1.0 1 1

Aggregate (cost=30,308.96..30,308.97 rows=1 width=8) (actual time=7.976..7.976 rows=1 loops=1)

2. 0.000 7.846 ↓ 3.8 1,800 1

Nested Loop (cost=1,235.85..30,307.79 rows=471 width=0) (actual time=1.260..7.846 rows=1,800 loops=1)

3. 0.007 0.007 ↑ 1.0 1 1

Index Only Scan using tipoasse_codi_pk on tipoasse (cost=0.27..4.29 rows=1 width=4) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (h12_codigo = 350)
  • Heap Fetches: 0
4. 5.277 9.541 ↓ 3.8 1,800 1

Gather (cost=1,235.58..30,298.79 rows=471 width=4) (actual time=1.253..9.541 rows=1,800 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 2.012 4.264 ↓ 3.1 600 3

Nested Loop (cost=235.58..29,251.69 rows=196 width=4) (actual time=0.380..4.264 rows=600 loops=3)

6. 1.075 2.249 ↑ 3.4 602 3

Nested Loop (cost=235.15..18,930.86 rows=2,047 width=12) (actual time=0.348..2.249 rows=602 loops=3)

7. 0.404 1.173 ↑ 3.4 602 3

Parallel Bitmap Heap Scan on assenta (cost=234.86..18,008.03 rows=2,047 width=8) (actual time=0.322..1.173 rows=602 loops=3)

  • Recheck Cond: (h16_assent = 350)
  • Filter: (h16_dtconc >= '2016-11-01'::date)
  • Rows Removed by Filter: 3565
  • Heap Blocks: exact=488
8. 0.769 0.769 ↓ 1.0 12,501 1

Bitmap Index Scan on assenta_ass_reg_in (cost=0.00..233.63 rows=12,427 width=0) (actual time=0.769..0.769 rows=12,501 loops=1)

  • Index Cond: (h16_assent = 350)
9. 0.001 0.001 ↑ 1.0 1 1,806

Index Only Scan using rhpessoal_regi_pk on rhpessoal (cost=0.29..0.45 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1,806)

  • Index Cond: (rh01_regist = assenta.h16_regist)
  • Heap Fetches: 0
10. 0.003 0.003 ↑ 1.0 1 1,806

Index Scan using rhpessoalmov_ano_mes_reg_ind on rhpessoalmov (cost=0.43..5.03 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1,806)

  • Index Cond: ((rh02_anousu = 2019) AND (rh02_mesusu = 9) AND (rh02_regist = rhpessoal.rh01_regist))
  • Filter: (rh02_instit = 11)
  • Rows Removed by Filter: 0
Planning time : 0.602 ms
Execution time : 9.901 ms