explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1uOw

Settings
# exclusive inclusive rows x rows loops node
1. 23,376.917 96,877.638 ↓ 1.4 6,861,775 1

Sort (cost=5,151,854.52..5,164,175.09 rows=4,928,225 width=102) (actual time=89,302.572..96,877.638 rows=6,861,775 loops=1)

  • Sort Key: measurement.measurement_start_time
  • Sort Method: external merge Disk: 380,688kB
2. 15,587.156 73,500.721 ↓ 1.4 6,861,775 1

Hash Join (cost=635,236.59..4,296,001.34 rows=4,928,225 width=102) (actual time=21,934.864..73,500.721 rows=6,861,775 loops=1)

  • Hash Cond: (measurement.input_no = input.input_no)
3. 17,120.951 54,910.664 ↓ 1.4 7,151,241 1

Hash Join (cost=578,264.58..4,094,532.45 rows=5,053,726 width=21) (actual time=18,847.886..54,910.664 rows=7,151,241 loops=1)

  • Hash Cond: (measurement.report_no = report.report_no)
4. 19,055.973 19,055.973 ↓ 1.4 7,151,241 1

Index Scan using measurement_v2_measurement_start_time_idx on measurement (cost=0.57..3,294,299.45 rows=5,053,726 width=18) (actual time=1.076..19,055.973 rows=7,151,241 loops=1)

  • Index Cond: (measurement_start_time >= '2019-09-09 00:00:00'::timestamp without time zone)
5. 9,322.277 18,733.740 ↑ 1.0 8,745,922 1

Hash (cost=426,184.45..426,184.45 rows=8,748,845 width=11) (actual time=18,733.739..18,733.740 rows=8,745,922 loops=1)

  • Buckets: 131,072 Batches: 256 Memory Usage: 2,507kB
6. 9,411.463 9,411.463 ↑ 1.0 8,745,922 1

Seq Scan on report (cost=0.00..426,184.45 rows=8,748,845 width=11) (actual time=0.049..9,411.463 rows=8,745,922 loops=1)

7. 1,583.268 3,002.901 ↑ 1.0 1,567,097 1

Hash (cost=26,645.56..26,645.56 rows=1,568,356 width=25) (actual time=3,002.900..3,002.901 rows=1,567,097 loops=1)

  • Buckets: 65,536 Batches: 32 Memory Usage: 3,355kB
8. 1,419.633 1,419.633 ↑ 1.0 1,567,097 1

Seq Scan on input (cost=0.00..26,645.56 rows=1,568,356 width=25) (actual time=0.000..1,419.633 rows=1,567,097 loops=1)

Planning time : 4.851 ms
Execution time : 102,004.694 ms