explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zQCm

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.816 ↑ 1.0 3 1

Subquery Scan on sub (cost=319.40..319.44 rows=3 width=119) (actual time=0.815..0.816 rows=3 loops=1)

2. 0.007 0.815 ↑ 1.0 3 1

Sort (cost=319.40..319.41 rows=3 width=138) (actual time=0.815..0.815 rows=3 loops=1)

  • Sort Key: pristroj.date_to DESC, pristroj.serial_number
  • Sort Method: quicksort Memory: 25kB
3. 0.012 0.808 ↑ 1.0 3 1

WindowAgg (cost=319.27..319.37 rows=3 width=138) (actual time=0.806..0.808 rows=3 loops=1)

4. 0.006 0.796 ↑ 1.0 3 1

Sort (cost=319.27..319.28 rows=3 width=104) (actual time=0.796..0.796 rows=3 loops=1)

  • Sort Key: spotreba.serial_number
  • Sort Method: quicksort Memory: 25kB
5. 0.002 0.790 ↑ 1.0 3 1

Nested Loop (cost=0.57..319.25 rows=3 width=104) (actual time=0.082..0.790 rows=3 loops=1)

6. 0.782 0.782 ↑ 1.0 3 1

Index Scan using mv_spotreba_celkovo_year_start_idx on mv_spotreba_celkovo spotreba (cost=0.29..294.35 rows=3 width=77) (actual time=0.078..0.782 rows=3 loops=1)

  • Index Cond: (year_start = '2018-01-01'::date)
  • Filter: (odberne_miesto_id = 61)
  • Rows Removed by Filter: 6400
7. 0.006 0.006 ↑ 1.0 1 3

Index Scan using pristroj_pkey on pristroj (cost=0.28..8.30 rows=1 width=35) (actual time=0.002..0.002 rows=1 loops=3)

  • Index Cond: (id = spotreba.pristroj_id)