explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l88I

Settings
# exclusive inclusive rows x rows loops node
1. 80.106 4,690.895 ↓ 1.3 19 1

Merge Join (cost=1,249.61..76,886.23 rows=15 width=4) (actual time=247.722..4,690.895 rows=19 loops=1)

  • Merge Cond: (tucastnikdotaznik_vysledek.tucadot_pk = tucastnikdotaznik.tucadot_pk)
2. 0.000 4,179.553 ↓ 1.3 19 1

Gather Merge (cost=1,000.88..664,330.60 rows=15 width=4) (actual time=72.811..4,179.553 rows=19 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,193.751 12,848.742 ↑ 1.0 6 3

Nested Loop (cost=0.86..663,328.84 rows=6 width=4) (actual time=55.652..4,282.914 rows=6 loops=3)

4. 1,239.669 1,239.669 ↑ 1.2 578,629 3

Parallel Index Scan using tucastnikdotaznik_vysledek_tucadot_pk_idx on tucastnikdotaznik_vysledek (cost=0.43..87,497.19 rows=723,216 width=8) (actual time=0.055..413.223 rows=578,629 loops=3)

5. 10,415.322 10,415.322 ↓ 0.0 0 1,735,887

Index Scan using tucastnikdotaznik_vysledek_atribut_tucadotvys_pk_idx on tucastnikdotaznik_vysledek_atribut (cost=0.43..0.79 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1,735,887)

  • Index Cond: (tucadotvys_pk = tucastnikdotaznik_vysledek.tucadotvys_pk)
  • Filter: ((tucadotvysatr_key = 'pregenrovatJenPDF'::text) AND (tucadotvysatr_int = '1'::numeric))
  • Rows Removed by Filter: 2
6. 431.236 431.236 ↑ 1.1 810,802 1

Index Only Scan using tucastnikdotaznik_pkey on tucastnikdotaznik (cost=0.42..29,496.22 rows=866,853 width=4) (actual time=0.045..431.236 rows=810,802 loops=1)

  • Heap Fetches: 810802