explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qS6n

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.148 ↑ 1.0 1 1

Aggregate (cost=107.45..107.46 rows=1 width=32) (actual time=0.148..0.148 rows=1 loops=1)

2. 0.003 0.142 ↑ 16.0 1 1

Merge Join (cost=104.96..107.41 rows=16 width=8) (actual time=0.141..0.142 rows=1 loops=1)

  • Merge Cond: (mp.qualitycode = qc.quality_code_id)
3. 0.006 0.132 ↑ 41.0 1 1

Sort (cost=104.82..104.92 rows=41 width=16) (actual time=0.132..0.132 rows=1 loops=1)

  • Sort Key: mp.qualitycode
  • Sort Method: quicksort Memory: 25kB
4. 0.001 0.126 ↑ 41.0 1 1

Append (cost=0.42..103.72 rows=41 width=16) (actual time=0.027..0.126 rows=1 loops=1)

  • Subplans Removed: 40
5. 0.125 0.125 ↑ 1.0 1 1

Index Scan using metering_point_20200205_meteringsource_meteringrecord_readd_key on metering_point_20200205 mp (cost=0.42..7.71 rows=1 width=16) (actual time=0.027..0.125 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::bigint) AND (readdate >= '2020-02-05 00:00:00-06'::timestamp with time zone) AND (readdate < '2020-02-06 00:00:00'::timestamp without time zone))
  • Filter: (((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: 95
6. 0.007 0.007 ↑ 12.5 2 1

Index Scan using quality_codes_pkey on quality_codes qc (cost=0.14..4.42 rows=25 width=8) (actual time=0.007..0.007 rows=2 loops=1)

  • Filter: good_quality_code
  • Rows Removed by Filter: 1
Planning time : 4.426 ms