explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U7yS

Settings
# exclusive inclusive rows x rows loops node
1. 105.178 249.734 ↓ 0.0 0 1

Update on t_post_ergebnis e (cost=331.66..443,212.51 rows=4,330 width=152) (actual time=249.734..249.734 rows=0 loops=1)

2. 31.859 144.556 ↑ 1.3 3,241 1

Nested Loop (cost=331.66..443,212.51 rows=4,330 width=152) (actual time=78.434..144.556 rows=3,241 loops=1)

3. 9.802 11.336 ↓ 1.0 7,797 1

Bitmap Heap Scan on t_post_ergebnis e (cost=331.66..21,638.93 rows=7,738 width=146) (actual time=2.103..11.336 rows=7,797 loops=1)

  • Recheck Cond: (planungsnummer = 995545)
4. 1.534 1.534 ↓ 2.4 18,829 1

Bitmap Index Scan on t_post_ergebnis_planungsnummer_idx (cost=0.00..329.73 rows=7,738 width=0) (actual time=1.534..1.534 rows=18,829 loops=1)

  • Index Cond: (planungsnummer = 995545)
5. 101.361 101.361 ↓ 0.0 0 7,797

Index Scan using t_post_personicx_idx on t_post_personicx px (cost=0.00..54.47 rows=1 width=14) (actual time=0.013..0.013 rows=0 loops=7,797)

  • Index Cond: ((abgabestelle_id)::text = (e.abgabestelle_id)::text)
  • Filter: ((b4p_column_02_011 >= 87::numeric) OR (b4p_column_02_010 >= 88::numeric))
  • Rows Removed by Filter: 1