explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NjBx

Settings
# exclusive inclusive rows x rows loops node
1. 17,292.510 64,103.279 ↓ 1.4 6,861,775 1

Sort (cost=7,207,222.63..7,219,543.20 rows=4,928,225 width=102) (actual time=58,037.013..64,103.279 rows=6,861,775 loops=1)

  • Sort Key: measurement.measurement_start_time
  • Sort Method: external merge Disk: 380,688kB
2. 11,660.474 46,810.769 ↓ 1.4 6,861,775 1

Hash Join (cost=733,150.97..6,120,357.45 rows=4,928,225 width=102) (actual time=16,905.308..46,810.769 rows=6,861,775 loops=1)

  • Hash Cond: (measurement.input_no = input.input_no)
3. 12,448.023 32,732.986 ↓ 1.4 7,151,241 1

Hash Join (cost=676,178.96..5,918,888.56 rows=5,053,726 width=21) (actual time=14,406.975..32,732.986 rows=7,151,241 loops=1)

  • Hash Cond: (measurement.report_no = report.report_no)
4. 5,895.224 6,655.440 ↓ 1.4 7,151,241 1

Bitmap Heap Scan on measurement (cost=97,914.95..5,118,655.56 rows=5,053,726 width=18) (actual time=767.368..6,655.440 rows=7,151,241 loops=1)

  • Recheck Cond: (measurement_start_time >= '2019-09-09 00:00:00'::timestamp without time zone)
  • Rows Removed by Index Recheck: 3,467
  • Heap Blocks: exact=30,720 lossy=79,131
5. 760.216 760.216 ↓ 1.4 7,151,241 1

Bitmap Index Scan on measurement_v2_measurement_start_time_idx (cost=0.00..96,651.52 rows=5,053,726 width=0) (actual time=760.216..760.216 rows=7,151,241 loops=1)

  • Index Cond: (measurement_start_time >= '2019-09-09 00:00:00'::timestamp without time zone)
6. 6,398.468 13,629.523 ↑ 1.0 8,745,922 1

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

  • Buckets: 131,072 Batches: 256 Memory Usage: 2,507kB
7. 7,231.055 7,231.055 ↑ 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..7,231.055 rows=8,745,922 loops=1)

8. 1,283.269 2,417.309 ↑ 1.0 1,567,097 1

Hash (cost=26,645.56..26,645.56 rows=1,568,356 width=25) (actual time=2,417.308..2,417.309 rows=1,567,097 loops=1)

  • Buckets: 65,536 Batches: 32 Memory Usage: 3,355kB
9. 1,134.040 1,134.040 ↑ 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.021..1,134.040 rows=1,567,097 loops=1)