explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1HHN : Parallel

Settings
# exclusive inclusive rows x rows loops node
1. 397.117 3,834.953 ↓ 1.5 19,882 1

Gather (cost=149,452.83..173,808.59 rows=12,969 width=158) (actual time=2,765.322..3,834.953 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
  • Workers Planned: 2
  • Workers Launched: 2
  • JIT for worker 0:
  • Functions: 12
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 14.426 ms, Inlining 0.000 ms, Optimization 4.409 ms, Emission 35.676 ms, Total 54.511 ms
  • JIT for worker 1:
  • Functions: 12
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 5.182 ms, Inlining 0.000 ms, Optimization 4.117 ms, Emission 39.982 ms, Total 49.281 ms
  • Buffers: shared hit=60,272, temp read=47,731 written=48,132
  • Functions: 36
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 21.229 ms, Inlining 0.000 ms, Optimization 13.705 ms, Emission 92.500 ms, Total 127.434 ms
2. 871.120 3,437.836 ↓ 1.2 6,627 3 / 3

Parallel Hash Left Join (cost=148,452.83..171,511.69 rows=5,404 width=158) (actual time=2,679.117..3,437.836 rows=6,627 loops=3)

  • 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: (a.id = az.id)
  • Buffers: shared hit=60,272, temp read=47,731 written=48,132
  • Worker 0: actual time=2,677.313..3337.241 rows=5,611 loops=1
  • Buffers: shared hit=18,502, temp read=13,765 written=14,956
  • Worker 1: actual time=2,596.426..3339.934 rows=6,432 loops=1
  • Buffers: shared hit=17,927, temp read=14,395 written=14,372
3. 84.995 115.701 ↑ 1.6 1,347 3 / 3

Parallel Bitmap Heap Scan on reports.ui_cdc_s5_misto_cas_zdroj_aggregace a (cost=6,754.49..12,438.79 rows=2,101 width=134) (actual time=98.292..115.701 rows=1,347 loops=3)

  • 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: 33,763
  • Heap Blocks: lossy=1,086
  • Buffers: shared hit=2,042
  • Worker 0: actual time=98.244..115.757 rows=764 loops=1
  • Buffers: shared hit=409
  • Worker 1: actual time=98.367..115.731 rows=709 loops=1
  • Buffers: shared hit=547
4. 0.529 30.706 ↓ 0.0 0 1 / 3

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

  • Buffers: shared hit=156
  • Worker 1: actual time=92.117..92.117 rows=0 loops=1
  • Buffers: shared hit=156
5. 0.376 0.376 ↑ 4.3 284,160 1 / 3

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=1.127..1.127 rows=284,160 loops=1)

  • Index Cond: ((a.datum >= '2017-01-01'::date) AND (a.datum <= '2018-03-01'::date))
  • Buffers: shared hit=32
  • Worker 1: actual time=1.127..1.127 rows=284,160 loops=1
  • Buffers: shared hit=32
6. 2.817 2.817 ↑ 1.0 71,343 1 / 3

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

  • Index Cond: (a.bod_vykonu_kod = '5433355900'::bigint)
  • Buffers: shared hit=16
  • Worker 1: actual time=8.450..8.450 rows=71,343 loops=1
  • Buffers: shared hit=16
7. 26.984 26.984 ↑ 1.0 778,042 1 / 3

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

  • Index Cond: (a.kod_kzam = 83,121)
  • Buffers: shared hit=108
  • Worker 1: actual time=80.952..80.952 rows=778,042 loops=1
  • Buffers: shared hit=108
8. 1,511.104 2,451.015 ↓ 1.0 3,043,802 3 / 3

Parallel Hash (cost=87,618.15..87,618.15 rows=2,945,615 width=24) (actual time=2,451.014..2,451.015 rows=3,043,802 loops=3)

  • Output: az.id, az.zahranicni, az.pul_den, az.v_vytizeni
  • Buckets: 524,288 Batches: 32 Memory Usage: 19,872kB
  • Buffers: shared hit=58,162, temp written=47,748
  • Worker 0: actual time=2,425.611..2425.611 rows=2,835,236 loops=1
  • Buffers: shared hit=18,059, temp written=14,828
  • Worker 1: actual time=2,426.392..2426.392 rows=2,723,322 loops=1
  • Buffers: shared hit=17,346, temp written=14,244
9. 939.911 939.911 ↓ 1.0 3,043,802 3 / 3

Parallel Seq Scan on reports.ui_cdc_s5_misto_cas_zdroj_aggregace_zdrobneni az (cost=0.00..87,618.15 rows=2,945,615 width=24) (actual time=0.035..939.911 rows=3,043,802 loops=3)

  • Output: az.id, az.zahranicni, az.pul_den, az.v_vytizeni
  • Buffers: shared hit=58,162
  • Worker 0: actual time=0.027..1149.377 rows=2,835,236 loops=1
  • Buffers: shared hit=18,059
  • Worker 1: actual time=0.050..1191.181 rows=2,723,322 loops=1
  • Buffers: shared hit=17,346
Execution time : 3,838.067 ms