explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rlb4

Settings
# exclusive inclusive rows x rows loops node
1. 226.179 229.133 ↑ 1.0 1 1

Gather (cost=10,538.24..10,538.35 rows=1 width=32) (actual time=221.410..229.133 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.004 2.954 ↑ 1.0 1 1 / 2

Aggregate (cost=9,538.24..9,538.25 rows=1 width=32) (actual time=5.908..5.908 rows=1 loops=1)

3. 0.059 2.950 ↑ 46.3 31 1 / 2

Hash Join (cost=4.88..9,534.65 rows=1,434 width=8) (actual time=0.233..5.900 rows=31 loops=1)

  • Hash Cond: (mp.qualitycode = qc.quality_code_id)
4. 0.005 2.872 ↑ 120.3 31 1 / 2

Append (cost=0.15..9,501.60 rows=3,728 width=16) (actual time=0.084..5.744 rows=31 loops=1)

  • Subplans Removed: 3697
5. 0.173 0.173 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200106_meteringsource_meteringrecord_readd_key on metering_point_20200106 mp (cost=0.42..35.21 rows=1 width=16) (actual time=0.084..0.347 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
6. 0.100 0.100 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200107_meteringsource_meteringrecord_readd_key on metering_point_20200107 mp_1 (cost=0.42..8.38 rows=1 width=16) (actual time=0.042..0.200 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
7. 0.089 0.089 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200108_meteringsource_meteringrecord_readd_key on metering_point_20200108 mp_2 (cost=0.42..8.38 rows=1 width=16) (actual time=0.039..0.179 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
8. 0.135 0.135 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200109_meteringsource_meteringrecord_readd_key on metering_point_20200109 mp_3 (cost=0.42..25.44 rows=1 width=16) (actual time=0.043..0.269 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
9. 0.095 0.095 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200110_meteringsource_meteringrecord_readd_key on metering_point_20200110 mp_4 (cost=0.42..29.40 rows=1 width=16) (actual time=0.035..0.189 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
10. 0.117 0.117 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200111_meteringsource_meteringrecord_readd_key on metering_point_20200111 mp_5 (cost=0.42..32.34 rows=1 width=16) (actual time=0.034..0.234 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
11. 0.094 0.094 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200112_meteringsource_meteringrecord_readd_key on metering_point_20200112 mp_6 (cost=0.42..8.36 rows=1 width=16) (actual time=0.034..0.188 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
12. 0.094 0.094 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200113_meteringsource_meteringrecord_readd_key on metering_point_20200113 mp_7 (cost=0.42..27.29 rows=1 width=16) (actual time=0.035..0.188 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
13. 0.089 0.089 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200114_meteringsource_meteringrecord_readd_key on metering_point_20200114 mp_8 (cost=0.42..8.37 rows=1 width=16) (actual time=0.030..0.178 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
14. 0.091 0.091 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200115_meteringsource_meteringrecord_readd_key on metering_point_20200115 mp_9 (cost=0.42..8.37 rows=1 width=16) (actual time=0.038..0.183 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
15. 0.093 0.093 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200116_meteringsource_meteringrecord_readd_key on metering_point_20200116 mp_10 (cost=0.42..8.36 rows=1 width=16) (actual time=0.037..0.186 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
16. 0.093 0.093 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200117_meteringsource_meteringrecord_readd_key on metering_point_20200117 mp_11 (cost=0.42..30.18 rows=1 width=16) (actual time=0.037..0.187 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
17. 0.092 0.092 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200118_meteringsource_meteringrecord_readd_key on metering_point_20200118 mp_12 (cost=0.42..8.36 rows=1 width=16) (actual time=0.029..0.184 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
18. 0.090 0.090 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200119_meteringsource_meteringrecord_readd_key on metering_point_20200119 mp_13 (cost=0.42..8.35 rows=1 width=16) (actual time=0.034..0.181 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
19. 0.090 0.090 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200120_meteringsource_meteringrecord_readd_key on metering_point_20200120 mp_14 (cost=0.42..8.64 rows=1 width=16) (actual time=0.032..0.181 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
20. 0.085 0.085 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200121_meteringsource_meteringrecord_readd_key on metering_point_20200121 mp_15 (cost=0.42..8.69 rows=1 width=16) (actual time=0.036..0.169 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
21. 0.100 0.100 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200122_meteringsource_meteringrecord_readd_key on metering_point_20200122 mp_16 (cost=0.42..8.67 rows=1 width=16) (actual time=0.040..0.199 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
22. 0.088 0.088 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200123_meteringsource_meteringrecord_readd_key on metering_point_20200123 mp_17 (cost=0.42..8.67 rows=1 width=16) (actual time=0.040..0.176 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
23. 0.079 0.079 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200124_meteringsource_meteringrecord_readd_key on metering_point_20200124 mp_18 (cost=0.42..8.66 rows=1 width=16) (actual time=0.036..0.157 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
24. 0.088 0.088 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200125_meteringsource_meteringrecord_readd_key on metering_point_20200125 mp_19 (cost=0.42..8.66 rows=1 width=16) (actual time=0.037..0.176 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
25. 0.084 0.084 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200126_meteringsource_meteringrecord_readd_key on metering_point_20200126 mp_20 (cost=0.42..8.64 rows=1 width=16) (actual time=0.034..0.168 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
26. 0.082 0.082 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200127_meteringsource_meteringrecord_readd_key on metering_point_20200127 mp_21 (cost=0.42..7.63 rows=1 width=16) (actual time=0.025..0.163 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
27. 0.078 0.078 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200128_meteringsource_meteringrecord_readd_key on metering_point_20200128 mp_22 (cost=0.42..7.64 rows=1 width=16) (actual time=0.025..0.156 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
28. 0.076 0.076 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200129_meteringsource_meteringrecord_readd_key on metering_point_20200129 mp_23 (cost=0.42..7.61 rows=1 width=16) (actual time=0.019..0.153 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
29. 0.075 0.075 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200130_meteringsource_meteringrecord_readd_key on metering_point_20200130 mp_24 (cost=0.42..7.63 rows=1 width=16) (actual time=0.018..0.150 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
30. 0.082 0.082 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200131_meteringsource_meteringrecord_readd_key on metering_point_20200131 mp_25 (cost=0.42..7.65 rows=1 width=16) (actual time=0.018..0.164 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
31. 0.079 0.079 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200201_meteringsource_meteringrecord_readd_key on metering_point_20200201 mp_26 (cost=0.42..7.60 rows=1 width=16) (actual time=0.023..0.158 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
32. 0.084 0.084 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200202_meteringsource_meteringrecord_readd_key on metering_point_20200202 mp_27 (cost=0.42..7.63 rows=1 width=16) (actual time=0.018..0.168 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
33. 0.075 0.075 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200203_meteringsource_meteringrecord_readd_key on metering_point_20200203 mp_28 (cost=0.42..7.62 rows=1 width=16) (actual time=0.020..0.150 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
34. 0.076 0.076 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200204_meteringsource_meteringrecord_readd_key on metering_point_20200204 mp_29 (cost=0.42..7.60 rows=1 width=16) (actual time=0.023..0.152 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
35. 0.100 0.100 ↑ 1.0 1 1 / 2

Index Scan using metering_point_20200205_meteringsource_meteringrecord_readd_key on metering_point_20200205 mp_30 (cost=0.42..7.68 rows=1 width=16) (actual time=0.025..0.200 rows=1 loops=1)

  • Index Cond: ((meteringsource = 1015) AND (meteringrecord = '2000000016861'::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: ((readdate)::time without time zone = '00:00:00'::time without time zone)
  • Rows Removed by Filter: 95
36. 0.005 0.019 ↑ 1.0 25 1 / 2

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
37. 0.014 0.014 ↑ 1.0 25 1 / 2

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

  • Filter: good_quality_code
  • Rows Removed by Filter: 40
Planning time : 31,885.731 ms