explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5xjm : Non-parallel

Settings
# exclusive inclusive rows x rows loops node
1. 992.448 2,019.428 ↓ 1.5 19,882 1

Hash Right Join (cost=12,565.79..196,414.33 rows=12,969 width=158) (actual time=323.643..2,019.428 rows=19,882 loops=1)

  • Output: a.id, a.identifikator, a.bod_vykonu_kod, a.datum, a.kod_kzam, a.id_s5_kategorie_cinnosti, a.v_vytizeni, a.obsazeni, a.obsazeni_den, a.mczv_vytizeni, a.identifikator_o, a.pp_kod, a.pj_kod, a.id_vyhodnoceni, a.obsazeni_g, a.obsazeni_den_g, a.vytizeni_den, a.vytizeni_noc, a.obsazeni_noc, a.obsazeni_noc_g, az.id, az.zahranicni, az.pul_den, az.v_vytizeni
  • Hash Cond: (az.id = a.id)
  • Buffers: shared hit=60,174
  • Functions: 12
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 1.750 ms, Inlining 0.000 ms, Optimization 0.950 ms, Emission 10.775 ms, Total 13.475 ms
2. 898.211 898.211 ↑ 1.0 9,131,407 1

Seq Scan on reports.ui_cdc_s5_misto_cas_zdroj_aggregace_zdrobneni az (cost=0.00..149,476.07 rows=9,131,407 width=24) (actual time=0.022..898.211 rows=9,131,407 loops=1)

  • Output: az.id, az.zahranicni, az.pul_den, az.v_vytizeni
  • Buffers: shared hit=58,162
3. 0.858 128.769 ↑ 1.2 4,042 1

Hash (cost=12,502.76..12,502.76 rows=5,043 width=134) (actual time=128.768..128.769 rows=4,042 loops=1)

  • Output: a.id, a.identifikator, a.bod_vykonu_kod, a.datum, a.kod_kzam, a.id_s5_kategorie_cinnosti, a.v_vytizeni, a.obsazeni, a.obsazeni_den, a.mczv_vytizeni, a.identifikator_o, a.pp_kod, a.pj_kod, a.id_vyhodnoceni, a.obsazeni_g, a.obsazeni_den_g, a.vytizeni_den, a.vytizeni_noc, a.obsazeni_noc, a.obsazeni_noc_g
  • Buckets: 8,192 Batches: 1 Memory Usage: 695kB
  • Buffers: shared hit=2,012
4. 38.233 127.911 ↑ 1.2 4,042 1

Bitmap Heap Scan on reports.ui_cdc_s5_misto_cas_zdroj_aggregace a (cost=6,754.49..12,502.76 rows=5,043 width=134) (actual time=112.952..127.911 rows=4,042 loops=1)

  • Output: a.id, a.identifikator, a.bod_vykonu_kod, a.datum, a.kod_kzam, a.id_s5_kategorie_cinnosti, a.v_vytizeni, a.obsazeni, a.obsazeni_den, a.mczv_vytizeni, a.identifikator_o, a.pp_kod, a.pj_kod, a.id_vyhodnoceni, a.obsazeni_g, a.obsazeni_den_g, a.vytizeni_den, a.vytizeni_noc, a.obsazeni_noc, a.obsazeni_noc_g
  • Recheck Cond: ((a.datum >= '2017-01-01'::date) AND (a.datum <= '2018-03-01'::date) AND (a.bod_vykonu_kod = '5433355900'::bigint) AND (a.kod_kzam = 83,121))
  • Rows Removed by Index Recheck: 101,288
  • Heap Blocks: lossy=1,886
  • Buffers: shared hit=2,012
5. 1.819 89.678 ↓ 0.0 0 1

BitmapAnd (cost=6,754.49..6,754.49 rows=5,483 width=0) (actual time=89.678..89.678 rows=0 loops=1)

  • Buffers: shared hit=126
6. 0.523 0.523 ↑ 4.3 284,160 1

Bitmap Index Scan on index_nove_ui_ser_brin_256_date_2 (cost=0.00..8.95 rows=1,229,210 width=0) (actual time=0.523..0.523 rows=284,160 loops=1)

  • Index Cond: ((a.datum >= '2017-01-01'::date) AND (a.datum <= '2018-03-01'::date))
  • Buffers: shared hit=2
7. 12.918 12.918 ↑ 1.0 71,343 1

Bitmap Index Scan on index_nove_ui_ser_gin_bvk_2 (cost=0.00..572.34 rows=72,059 width=0) (actual time=12.918..12.918 rows=71,343 loops=1)

  • Index Cond: (a.bod_vykonu_kod = '5433355900'::bigint)
  • Buffers: shared hit=16
8. 74.418 74.418 ↑ 1.0 778,042 1

Bitmap Index Scan on index_nove_ui_ser_gin_kzam_2 (cost=0.00..6,168.92 rows=780,429 width=0) (actual time=74.418..74.418 rows=778,042 loops=1)

  • Index Cond: (a.kod_kzam = 83,121)
  • Buffers: shared hit=108
Execution time : 2,022.309 ms