explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9lonF : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=456,951.91..456,951.92 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on waarneming (cost=3,036.85..456,546.65 rows=162,102 width=8) (actual rows= loops=)

  • Recheck Cond: (ind_diergroep = 1)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on waarneming_ind_diergroep (cost=0.00..2,996.33 rows=162,102 width=0) (actual rows= loops=)

  • Index Cond: (ind_diergroep = 1)