explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b4iG

Settings
# exclusive inclusive rows x rows loops node
1. 14.555 12,722.261 ↓ 1,478.0 1,478 1

Subquery Scan on q (cost=11,622.86..11,622.95 rows=1 width=24) (actual time=12,705.407..12,722.261 rows=1,478 loops=1)

2.          

Initplan (forSubquery Scan)

3. 0.001 0.001 ↑ 1.0 1 1

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

4. 2,311.029 12,707.705 ↓ 1,478.0 1,478 1

HashAggregate (cost=11,622.85..11,622.91 rows=1 width=16) (actual time=12,705.354..12,707.705 rows=1,478 loops=1)

5.          

Initplan (forHashAggregate)

6. 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)

7. 9,953.498 10,396.674 ↓ 183.2 1,436,735 1

Bitmap Heap Scan on stromzaehler (cost=168.82..11,564.02 rows=7,843 width=16) (actual time=448.553..10,396.674 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))
8. 443.176 443.176 ↓ 183.2 1,436,735 1

Bitmap Index Scan on index_zeit (cost=0.00..166.86 rows=7,843 width=0) (actual time=443.176..443.176 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))