explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HLnS

Settings
# exclusive inclusive rows x rows loops node
1. 10,986.943 202,384.772 ↓ 1.3 7,908,819 1

Unique (cost=8,199,688.21..8,339,008.43 rows=6,192,010 width=122) (actual time=169,941.444..202,384.772 rows=7,908,819 loops=1)

2. 120,749.556 191,397.829 ↓ 1.3 8,125,585 1

Sort (cost=8,199,688.21..8,215,168.23 rows=6,192,010 width=122) (actual time=169,941.440..191,397.829 rows=8,125,585 loops=1)

  • Sort Key: (false), (false), fastpath.input, fastpath.measurement_start_time, fastpath.probe_cc, ((fastpath.scores)::text), fastpath.test_name, fastpath.tid
  • Sort Method: external merge Disk: 631,432kB
3. 9,445.700 70,648.273 ↓ 1.3 8,125,585 1

Append (cost=0.00..6,294,812.79 rows=6,192,010 width=122) (actual time=0.023..70,648.273 rows=8,125,585 loops=1)

4. 1,903.026 1,903.026 ↓ 1.0 1,263,810 1

Seq Scan on fastpath (cost=0.00..112,535.24 rows=1,263,785 width=107) (actual time=0.020..1,903.026 rows=1,263,810 loops=1)

  • Filter: (measurement_start_time >= '2019-09-09 00:00:00'::timestamp without time zone)
5. 12,204.344 59,299.547 ↓ 1.4 6,861,775 1

Hash Join (cost=733,150.97..6,120,357.45 rows=4,928,225 width=102) (actual time=26,091.718..59,299.547 rows=6,861,775 loops=1)

  • Hash Cond: (measurement.input_no = input.input_no)
6. 13,813.344 44,968.298 ↓ 1.4 7,151,241 1

Hash Join (cost=676,178.96..5,918,888.56 rows=5,053,726 width=21) (actual time=23,787.089..44,968.298 rows=7,151,241 loops=1)

  • Hash Cond: (measurement.report_no = report.report_no)
7. 7,395.825 8,148.516 ↓ 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=759.434..8,148.516 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
8. 752.691 752.691 ↓ 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=752.691..752.691 rows=7,151,241 loops=1)

  • Index Cond: (measurement_start_time >= '2019-09-09 00:00:00'::timestamp without time zone)
9. 10,320.300 23,006.438 ↑ 1.0 8,745,922 1

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

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

11. 1,140.392 2,126.905 ↑ 1.0 1,567,097 1

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

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