explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mq9Q

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,948.794 ↑ 1.0 1 1

Finalize Aggregate (cost=431,622.86..431,622.87 rows=1 width=8) (actual time=2,948.794..2,948.794 rows=1 loops=1)

2. 46.060 2,984.532 ↑ 1.5 4 1

Gather (cost=431,622.23..431,622.84 rows=6 width=8) (actual time=2,946.995..2,984.532 rows=4 loops=1)

  • Workers Planned: 6
  • Workers Launched: 3
3. 46.489 2,938.472 ↑ 1.0 1 4 / 4

Partial Aggregate (cost=430,622.23..430,622.24 rows=1 width=8) (actual time=2,938.471..2,938.472 rows=1 loops=4)

4. 2,822.784 2,891.983 ↓ 1.5 341,415 4 / 4

Parallel Bitmap Heap Scan on busca_avancada_ativas_sem_sp (cost=14,939.65..430,044.14 rows=231,239 width=0) (actual time=463.325..2,891.983 rows=341,415 loops=4)

  • Recheck Cond: ((estado)::text = 'RS'::text)
  • Heap Blocks: exact=108405
5. 69.200 69.200 ↑ 1.0 1,365,660 1 / 4

Bitmap Index Scan on ix_busca_avancada_ativas_sem_sp_estado (cost=0.00..14,592.79 rows=1,387,434 width=0) (actual time=276.798..276.798 rows=1,365,660 loops=1)

  • Index Cond: ((estado)::text = 'RS'::text)
Planning time : 0.117 ms
Execution time : 2,984.612 ms