explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LFDE

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 60.598 72.599 ↑ 2.9 2,806 1

Gather (cost=1,579.64..126,564.35 rows=8,095 width=73) (actual time=2.660..72.599 rows=2,806 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.793 12.001 ↑ 3.6 935 3 / 3

Nested Loop (cost=579.64..124,754.85 rows=3,373 width=73) (actual time=0.587..12.001 rows=935 loops=3)

3. 2.480 2.790 ↑ 3.6 935 3 / 3

Parallel Bitmap Heap Scan on ge_vertrag a (cost=579.07..95,937.65 rows=3,373 width=65) (actual time=0.559..2.790 rows=935 loops=3)

  • Recheck Cond: (ssb_lieferant_id = '46040890'::text)
  • Filter: (ssb_vertragsart_bezeichnung = 'GIROKONTO'::text)
  • Rows Removed by Filter: 1,129
  • Heap Blocks: exact=5,756
4. 0.310 0.310 ↑ 4.1 6,194 1 / 3

Bitmap Index Scan on ie_ssb_lieferant_id_idx (cost=0.00..577.05 rows=25,130 width=0) (actual time=0.930..0.930 rows=6,194 loops=1)

  • Index Cond: (ssb_lieferant_id = '46040890'::text)
5. 8.418 8.418 ↑ 1.0 1 2,806 / 3

Index Scan using ge_person_pkey on ge_person b (cost=0.57..8.54 rows=1 width=25) (actual time=0.009..0.009 rows=1 loops=2,806)

  • Index Cond: ((ge_id)::text = (a.ge_id_person)::text)
Planning time : 0.199 ms
Execution time : 72.776 ms