explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PM64

Settings
# exclusive inclusive rows x rows loops node
1. 0.213 4,884.806 ↓ 38.5 77 1

Sort (cost=75,871.14..75,871.15 rows=2 width=122) (actual time=4,884.760..4,884.806 rows=77 loops=1)

  • Sort Key: fastpath.measurement_start_time
  • Sort Method: quicksort Memory: 31kB
2. 0.154 4,884.593 ↓ 38.5 77 1

Unique (cost=75,871.07..75,871.11 rows=2 width=122) (actual time=4,883.577..4,884.593 rows=77 loops=1)

3. 1.344 4,884.439 ↓ 39.0 78 1

Sort (cost=75,871.07..75,871.07 rows=2 width=122) (actual time=4,883.573..4,884.439 rows=78 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: quicksort Memory: 31kB
4. 0.151 4,883.095 ↓ 39.0 78 1

Append (cost=0.43..75,871.06 rows=2 width=122) (actual time=534.535..4,883.095 rows=78 loops=1)

5. 210.559 210.559 ↓ 0.0 0 1

Index Scan using input_idx on fastpath (cost=0.43..264.73 rows=1 width=107) (actual time=210.557..210.559 rows=0 loops=1)

  • Index Cond: (input = 'http://twitter.com/'::text)
  • Filter: ((measurement_start_time >= '2018-01-01 00:00:00'::timestamp without time zone) AND (probe_cc = 'EG'::bpchar) AND (test_name = 'web_connectivity'::ootest))
  • Rows Removed by Filter: 779
6. 50.555 4,672.385 ↓ 78.0 78 1

Nested Loop (cost=1.01..75,606.31 rows=1 width=102) (actual time=323.973..4,672.385 rows=78 loops=1)

7. 33.956 4,472.691 ↓ 139.3 16,571 1

Nested Loop (cost=0.57..75,384.08 rows=119 width=35) (actual time=2.884..4,472.691 rows=16,571 loops=1)

8. 237.558 237.558 ↑ 1.0 1 1

Seq Scan on input (cost=0.00..30,566.45 rows=1 width=25) (actual time=1.971..237.558 rows=1 loops=1)

  • Filter: (input = 'http://twitter.com/'::text)
  • Rows Removed by Filter: 1,567,096
9. 4,201.177 4,201.177 ↑ 1.8 16,571 1

Index Scan using measurement_v2_input_no_idx on measurement (cost=0.57..44,515.72 rows=30,191 width=18) (actual time=0.902..4,201.177 rows=16,571 loops=1)

  • Index Cond: (input_no = input.input_no)
  • Filter: (measurement_start_time >= '2018-01-01 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 535
10. 149.139 149.139 ↓ 0.0 0 16,571

Index Scan using report_pkey on report (cost=0.43..1.86 rows=1 width=11) (actual time=0.009..0.009 rows=0 loops=16,571)

  • Index Cond: (report_no = measurement.report_no)
  • Filter: ((probe_cc = 'EG'::bpchar) AND (test_name = 'web_connectivity'::ootest))
  • Rows Removed by Filter: 1
Planning time : 27.873 ms
Execution time : 4,885.145 ms