explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kyT5

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

Unique (cost=226,978.03..226,978.23 rows=40 width=8) (actual time=1,518.879..1,518.879 rows=0 loops=1)

2. 0.009 1,518.879 ↓ 0.0 0 1

Sort (cost=226,978.03..226,978.13 rows=40 width=8) (actual time=1,518.879..1,518.879 rows=0 loops=1)

  • Sort Key: zonfpverzi1_.id
  • Sort Method: quicksort Memory: 25kB
3. 0.000 1,518.870 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,001.43..226,976.96 rows=40 width=8) (actual time=1,518.870..1,518.870 rows=0 loops=1)

4. 0.000 1,518.870 ↓ 0.0 0 1

Nested Loop (cost=1,001.14..226,970.59 rows=16 width=8) (actual time=1,518.870..1,518.870 rows=0 loops=1)

5. 100.845 1,549.396 ↓ 0.0 0 1

Gather (cost=1,000.85..226,965.67 rows=16 width=8) (actual time=1,518.870..1,549.396 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 0.001 1,448.551 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.85..225,964.07 rows=7 width=8) (actual time=1,448.551..1,448.551 rows=0 loops=3)

7. 0.000 1,448.550 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.43..225,960.94 rows=7 width=8) (actual time=1,448.550..1,448.550 rows=0 loops=3)

8. 1,448.550 1,448.550 ↓ 0.0 0 3 / 3

Parallel Seq Scan on d_dokument dokument9_ (cost=0.00..225,881.29 rows=30 width=8) (actual time=1,448.550..1,448.550 rows=0 loops=3)

  • Filter: (nazov ~~ 'vypis'::text)
  • Rows Removed by Filter: 2602375
9. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using podmienkapomocidokumentzonfp_to_dokument_dokument_id_idx on podmienkapomocidokumentzonfp_to_dokument dokumenty8_ (cost=0.43..2.65 rows=1 width=16) (never executed)

  • Index Cond: (dokument_id = dokument9_.id)
10. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using d_podmienkapomocidokument_pkey on d_podmienkapomocidokumentzonfp podmienkyp7_ (cost=0.42..0.45 rows=1 width=16) (never executed)

  • Index Cond: (id = dokumenty8_.podmienkapomocidokumentzonfp_id)
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using d_zonfpverzia_pkey on d_zonfpverzia zonfpverzi1_ (cost=0.29..0.31 rows=1 width=8) (never executed)

  • Index Cond: (id = podmienkyp7_.zonfpverzia_id)
  • Heap Fetches: 0
12. 0.000 0.000 ↓ 0.0 0

Index Scan using zonfpverzia_to_dokument__zonfpverzia_id_idx on zonfpverzia_to_dokument dokumenty5_ (cost=0.29..0.37 rows=3 width=16) (never executed)

  • Index Cond: (zonfpverzi1_.id = zonfpverzia_id)