explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l0hv

Settings
# exclusive inclusive rows x rows loops node
1. 3.579 12,654.480 ↓ 739.0 1,478 1

Sort (cost=11,622.51..11,622.52 rows=2 width=24) (actual time=12,654.207..12,654.480 rows=1,478 loops=1)

  • Sort Key: q.t
  • Sort Method: quicksort Memory: 164kB
2.          

Initplan (forSort)

3. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1)

4. 14.855 12,650.899 ↓ 739.0 1,478 1

Subquery Scan on q (cost=11,622.31..11,622.49 rows=2 width=24) (actual time=12,633.964..12,650.899 rows=1,478 loops=1)

5. 2,339.399 12,636.044 ↓ 739.0 1,478 1

HashAggregate (cost=11,622.31..11,622.44 rows=2 width=16) (actual time=12,633.910..12,636.044 rows=1,478 loops=1)

6.          

Initplan (forHashAggregate)

7. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1)

8. 9,855.782 10,296.643 ↓ 183.2 1,436,735 1

Bitmap Heap Scan on stromzaehler (cost=168.82..11,563.48 rows=7,843 width=16) (actual time=446.342..10,296.643 rows=1,436,735 loops=1)

  • Recheck Cond: ((zeit >= '2019-09-01 00:00:00'::timestamp without time zone) AND (zeit <= '2019-10-03 00:00:00'::timestamp without time zone))
9. 440.861 440.861 ↓ 183.2 1,436,735 1

Bitmap Index Scan on index_zeit (cost=0.00..166.86 rows=7,843 width=0) (actual time=440.861..440.861 rows=1,436,735 loops=1)

  • Index Cond: ((zeit >= '2019-09-01 00:00:00'::timestamp without time zone) AND (zeit <= '2019-10-03 00:00:00'::timestamp without time zone))