explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YB7Y

Settings
# exclusive inclusive rows x rows loops node
1. 186.761 47,594.823 ↑ 13.4 2,528 1

Gather (cost=14,855.77..444,682.97 rows=33,886 width=7) (actual time=12,200.968..47,594.823 rows=2,528 loops=1)

  • Workers Planned: 6
  • Workers Launched: 4
2. 68.071 47,408.062 ↑ 11.2 506 5

Hash Join (cost=13,855.77..440,294.37 rows=5,648 width=7) (actual time=12,142.839..47,408.062 rows=506 loops=5)

  • Hash Cond: (document_base.ent_id = u0.id)
3. 3,164.419 47,324.298 ↓ 1.2 50,550 5

Hash Join (cost=12,346.53..438,620.39 rows=42,865 width=15) (actual time=3,081.261..47,324.298 rows=50,550 loops=5)

  • Hash Cond: (document_base.id = document_other_calcs.basedocumentmodel_ptr_id)
4. 41,093.412 41,093.412 ↓ 1.3 1,602,432 5

Parallel Seq Scan on document_base (cost=0.00..421,063.47 rows=1,275,131 width=19) (actual time=0.228..41,093.412 rows=1,602,432 loops=5)

  • Filter: ((document_storno_id IS NULL) AND (date_formatting >= '2018-01-01'::date) AND (date_formatting <= '2018-12-31'::date) AND (number ~ '[0-9]+'::text))
  • Rows Removed by Filter: 1150829
5. 1,391.006 3,066.467 ↓ 1.0 458,064 5

Hash (cost=6,882.90..6,882.90 rows=437,090 width=4) (actual time=3,066.467..3,066.467 rows=458,064 loops=5)

  • Buckets: 524288 Batches: 1 Memory Usage: 20200kB
6. 1,675.461 1,675.461 ↓ 1.0 458,064 5

Seq Scan on document_other_calcs (cost=0.00..6,882.90 rows=437,090 width=4) (actual time=0.029..1,675.461 rows=458,064 loops=5)

7. 0.023 15.693 ↑ 11.0 74 5

Hash (cost=1,499.03..1,499.03 rows=817 width=4) (actual time=15.693..15.693 rows=74 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
8. 15.618 15.670 ↑ 11.0 74 5

Bitmap Heap Scan on enterprise u0 (cost=22.79..1,499.03 rows=817 width=4) (actual time=0.089..15.670 rows=74 loops=5)

  • Recheck Cond: ((lft >= 1934) AND (lft <= 2081))
  • Filter: (tree_id = 8)
  • Heap Blocks: exact=76
9. 0.052 0.052 ↑ 10.6 77 5

Bitmap Index Scan on enterprise_lft (cost=0.00..22.59 rows=817 width=0) (actual time=0.052..0.052 rows=77 loops=5)

  • Index Cond: ((lft >= 1934) AND (lft <= 2081))
Planning time : 21.463 ms
Execution time : 47,595.274 ms