explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AlyT

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 24.021 ↑ 1.0 1 1

Aggregate (cost=45,009.49..45,009.50 rows=1 width=32) (actual time=24.020..24.021 rows=1 loops=1)

2. 0.002 24.013 ↓ 0.0 0 1

Nested Loop (cost=0.85..45,009.49 rows=1 width=8) (actual time=24.012..24.013 rows=0 loops=1)

3. 24.011 24.011 ↓ 0.0 0 1

Index Scan using mp_idx_mr_rd on metering_point mp (cost=0.71..45,001.32 rows=1 width=16) (actual time=24.011..24.011 rows=0 loops=1)

  • Index Cond: ((meteringrecord = '2000000136065'::bigint) AND (readdate >= '2020-01-06 00:00:00'::timestamp without time zone) AND (readdate < '2020-02-06 00:00:00'::timestamp without time zone))
  • Filter: ((meteringsource = 1015) AND ((readdate)::time without time zone = '00:00:00'::time without time zone) AND (date_part('dow'::text, readdate) = '3'::double precision))
  • Rows Removed by Filter: 17940
4. 0.000 0.000 ↓ 0.0 0

Index Scan using quality_codes_pkey on quality_codes qc (cost=0.14..8.16 rows=1 width=8) (never executed)

  • Index Cond: (quality_code_id = mp.qualitycode)
  • Filter: good_quality_code
Planning time : 0.872 ms