explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BPGK

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.014 ↑ 5.0 6 1

Append (cost=8.43..38.24 rows=30 width=26) (actual time=0.009..0.014 rows=6 loops=1)

2. 0.003 0.009 ↑ 5.0 3 1

Bitmap Heap Scan on mfgladob_staro (cost=8.43..19.04 rows=15 width=26) (actual time=0.009..0.009 rows=3 loops=1)

  • Recheck Cond: ((leto = 2019) OR (leto = 2018))
  • Heap Blocks: exact=1
3. 0.001 0.006 ↓ 0.0 0 1

BitmapOr (cost=8.43..8.43 rows=15 width=0) (actual time=0.006..0.006 rows=0 loops=1)

4. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on mfgladob_staro_pkey (cost=0.00..4.21 rows=8 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (leto = 2019)
5. 0.001 0.001 ↑ 2.7 3 1

Bitmap Index Scan on mfgladob_staro_pkey (cost=0.00..4.21 rows=8 width=0) (actual time=0.001..0.001 rows=3 loops=1)

  • Index Cond: (leto = 2018)
6. 0.002 0.004 ↑ 5.0 3 1

Bitmap Heap Scan on mfgladob_novo (cost=8.43..19.04 rows=15 width=26) (actual time=0.003..0.004 rows=3 loops=1)

  • Recheck Cond: ((leto = 2019) OR (leto = 2018))
  • Heap Blocks: exact=1
7. 0.000 0.002 ↓ 0.0 0 1

BitmapOr (cost=8.43..8.43 rows=15 width=0) (actual time=0.002..0.002 rows=0 loops=1)

8. 0.002 0.002 ↑ 2.7 3 1

Bitmap Index Scan on mfgladob_novo_pkey (cost=0.00..4.21 rows=8 width=0) (actual time=0.002..0.002 rows=3 loops=1)

  • Index Cond: (leto = 2019)
9. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on mfgladob_novo_pkey (cost=0.00..4.21 rows=8 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (leto = 2018)
Planning time : 0.134 ms
Execution time : 0.049 ms