explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KqMf

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 594.745 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.88..22.94 rows=1 width=56) (actual time=594.745..594.745 rows=0 loops=1)

  • Join Filter: (me.meteringrecord = mp.meteringrecord)
2. 0.003 594.743 ↓ 0.0 0 1

Nested Loop (cost=0.72..14.75 rows=1 width=24) (actual time=594.742..594.743 rows=0 loops=1)

3. 594.740 594.740 ↓ 0.0 0 1

Index Scan using mp_fl_idx_rd_ms on metering_point mp (cost=0.58..6.58 rows=1 width=32) (actual time=594.740..594.740 rows=0 loops=1)

  • Index Cond: ((readdate >= '2020-02-07 00:00:00-05'::timestamp with time zone) AND (readdate < '2020-02-12 00:00:00'::timestamp without time zone) AND (meteringsource = 3099))
  • Filter: (meteringrecord = '2000000066967'::bigint)
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
5. 0.000 0.000 ↓ 0.0 0

Index Only Scan using meteringsource_pk on meter_exclusions me (cost=0.15..8.17 rows=1 width=8) (never executed)

  • Index Cond: (meteringrecord = '2000000066967'::bigint)
  • Heap Fetches: 0
Planning time : 0.618 ms