explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qgG1

Settings
# exclusive inclusive rows x rows loops node
1. 13.161 13.313 ↑ 133.6 18 1

Gather (cost=6,064.93..336,559.67 rows=2,405 width=3,460) (actual time=1.261..13.313 rows=18 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
2. 0.005 0.152 ↑ 133.7 3 7 / 7

Nested Loop (cost=5,064.93..335,259.04 rows=401 width=3,240) (actual time=0.088..0.152 rows=3 loops=7)

3. 0.045 0.090 ↑ 133.7 3 7 / 7

Parallel Bitmap Heap Scan on docdeu (cost=5,064.51..334,567.86 rows=401 width=3,248) (actual time=0.076..0.090 rows=3 loops=7)

  • Recheck Cond: (meses_transcurridos_neg IS NOT NULL)
  • Filter: (estado = 'A'::bpchar)
  • Heap Blocks: exact=18
4. 0.045 0.045 ↑ 26,727.3 18 1 / 7

Bitmap Index Scan on meses_transcurridos_neg_idx (cost=0.00..5,063.91 rows=481,092 width=0) (actual time=0.313..0.313 rows=18 loops=1)

  • Index Cond: (meses_transcurridos_neg IS NOT NULL)
5. 0.057 0.057 ↑ 1.0 1 18 / 7

Index Only Scan using nits_nit on nits (cost=0.42..1.72 rows=1 width=8) (actual time=0.022..0.022 rows=1 loops=18)

  • Index Cond: (nit = docdeu.nit)
  • Heap Fetches: 18
Planning time : 0.600 ms
Execution time : 13.447 ms