explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lIKf

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 90.190 ↑ 1.0 3 1

Sort (cost=3,820.17..3,820.18 rows=3 width=119) (actual time=90.190..90.190 rows=3 loops=1)

  • Sort Key: v_agregat_pristrojov.pristroj_do DESC
  • Sort Method: quicksort Memory: 25kB
  • Planning time: 0.642 ms
  • Execution time: 90.284 ms
2. 1.061 90.181 ↑ 1.0 3 1

Subquery Scan on v_agregat_pristrojov (cost=2,576.60..3,820.15 rows=3 width=119) (actual time=90.034..90.181 rows=3 loops=1)

  • Filter: ((v_agregat_pristrojov.odberne_miesto_id = 61) AND (v_agregat_pristrojov.year_start = '2018-01-01'::date))
  • Rows Removed by Filter: 24868
3. 16.476 89.120 ↑ 1.0 24,871 1

WindowAgg (cost=2,576.60..3,447.08 rows=24,871 width=119) (actual time=70.818..89.120 rows=24,871 loops=1)

4. 61.111 72.644 ↑ 1.0 24,871 1

Sort (cost=2,576.60..2,638.77 rows=24,871 width=85) (actual time=70.801..72.644 rows=24,871 loops=1)

  • Sort Key: spotreba.serial_number
  • Sort Method: quicksort Memory: 4247kB
5. 7.323 11.533 ↑ 1.0 24,871 1

Hash Join (cost=109.66..760.74 rows=24,871 width=85) (actual time=1.830..11.533 rows=24,871 loops=1)

  • Hash Cond: (spotreba.pristroj_id = pristroj.id)
6. 2.404 2.404 ↑ 1.0 24,871 1

Seq Scan on mv_spotreba_celkovo spotreba (cost=0.00..585.71 rows=24,871 width=77) (actual time=0.011..2.404 rows=24,871 loops=1)

7. 0.889 1.806 ↑ 1.0 3,007 1

Hash (cost=72.07..72.07 rows=3,007 width=16) (actual time=1.806..1.806 rows=3,007 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 173kB
8. 0.917 0.917 ↑ 1.0 3,007 1

Seq Scan on pristroj (cost=0.00..72.07 rows=3,007 width=16) (actual time=0.008..0.917 rows=3,007 loops=1)