explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S0n

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 1.988 ↑ 1.0 3 1

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

  • Sort Key: pristroj.date_to DESC, pristroj.serial_number
  • Sort Method: quicksort Memory: 25kB
  • Planning time: 0.473 ms
  • Execution time: 2.092 ms
2. 0.025 1.973 ↑ 1.0 3 1

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

3. 0.013 1.948 ↑ 1.0 3 1

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

  • Sort Key: spotreba.serial_number
  • Sort Method: quicksort Memory: 25kB
4. 0.006 1.935 ↑ 1.0 3 1

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

5. 1.917 1.917 ↑ 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.187..1.917 rows=3 loops=1)

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

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

  • Index Cond: (id = spotreba.pristroj_id)