explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ojYs

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.202 ↑ 1.0 1 1

Aggregate (cost=9,129.60..9,129.61 rows=1 width=32) (actual time=0.202..0.202 rows=1 loops=1)

2. 0.029 0.192 ↑ 14.8 96 1

Hash Join (cost=4.88..9,126.04 rows=1,421 width=8) (actual time=0.067..0.192 rows=96 loops=1)

  • Hash Cond: (mp.qualitycode = qc.quality_code_id)
3. 0.009 0.133 ↑ 38.5 96 1

Append (cost=0.15..9,093.25 rows=3,694 width=16) (actual time=0.024..0.133 rows=96 loops=1)

  • Subplans Removed: 3688
4. 0.124 0.124 ↓ 16.0 96 1

Index Scan using metering_point_20200205_meteringsource_meteringrecord_readd_key on metering_point_20200205 mp (cost=0.42..7.65 rows=6 width=16) (actual time=0.024..0.124 rows=96 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::bigint) AND (readdate >= '2020-02-05 00:00:00'::timestamp without time zone) AND (readdate < '2020-02-06 00:00:00-06'::timestamp with time zone))
5. 0.010 0.030 ↑ 1.0 25 1

Hash (cost=4.42..4.42 rows=25 width=8) (actual time=0.030..0.030 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.020 0.020 ↑ 1.0 25 1

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

  • Filter: good_quality_code
  • Rows Removed by Filter: 40
Planning time : 29,950.070 ms