explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XS0G

Settings
# exclusive inclusive rows x rows loops node
1. 12.351 12.440 ↑ 133.6 18 1

Gather (cost=6,064.51..335,868.48 rows=2,405 width=3,460) (actual time=0.965..12.440 rows=18 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
2. 0.047 0.089 ↑ 133.7 3 7 / 7

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

  • Recheck Cond: (meses_transcurridos_neg IS NOT NULL)
  • Filter: (estado = 'A'::bpchar)
  • Heap Blocks: exact=18
3. 0.042 0.042 ↑ 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.291..0.291 rows=18 loops=1)

  • Index Cond: (meses_transcurridos_neg IS NOT NULL)
Planning time : 0.340 ms
Execution time : 12.530 ms