explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZUNQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.113 22,601.387 ↑ 1.0 50 1

Limit (cost=3,760,875.72..3,760,875.84 rows=50 width=170) (actual time=22,601.215..22,601.387 rows=50 loops=1)

2. 2.508 22,601.274 ↑ 1.1 50 1

Sort (cost=3,760,875.72..3,760,875.86 rows=57 width=170) (actual time=22,601.211..22,601.274 rows=50 loops=1)

  • Sort Key: report.test_start_time DESC
  • Sort Method: top-N heapsort Memory: 41kB
3. 4.169 22,598.766 ↓ 5.0 286 1

Nested Loop (cost=76,619.74..3,760,874.05 rows=57 width=170) (actual time=1,737.192..22,598.766 rows=286 loops=1)

4. 5,879.301 22,587.447 ↑ 5.9 286 1

Hash Join (cost=76,619.30..3,757,726.49 rows=1,697 width=73) (actual time=1,736.807..22,587.447 rows=286 loops=1)

  • Hash Cond: (measurement.input_no = input.input_no)
5. 15,053.201 16,418.039 ↑ 1.1 5,407,314 1

Bitmap Heap Scan on measurement (cost=76,130.08..3,735,496.45 rows=5,793,025 width=52) (actual time=1,377.836..16,418.039 rows=5,407,314 loops=1)

  • Recheck Cond: ((measurement_start_time > '2016-09-30 00:00:00'::timestamp without time zone) AND (measurement_start_time <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Index Recheck: 221109
  • Heap Blocks: exact=35259 lossy=54014
6. 1,364.838 1,364.838 ↑ 1.1 5,411,752 1

Bitmap Index Scan on measurement_v2_measurement_start_time_idx (cost=0.00..74,681.82 rows=5,793,025 width=0) (actual time=1,364.836..1,364.838 rows=5,411,752 loops=1)

  • Index Cond: ((measurement_start_time > '2016-09-30 00:00:00'::timestamp without time zone) AND (measurement_start_time <= '2016-12-14 00:00:00'::timestamp without time zone))
7. 0.496 290.107 ↑ 94.0 5 1

Hash (cost=483.35..483.35 rows=470 width=25) (actual time=290.105..290.107 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 1.317 289.611 ↑ 94.0 5 1

Bitmap Heap Scan on input (cost=14.12..483.35 rows=470 width=25) (actual time=288.655..289.611 rows=5 loops=1)

  • Recheck Cond: ((input ~~ 'www.sarawakreport.org%'::text) OR (input ~~ 'http://www.sarawakreport.org%'::text) OR (input ~~ 'https://www.sarawakreport.org%'::text))
  • Heap Blocks: exact=5
9. 0.002 288.294 ↓ 0.0 0 1

BitmapOr (cost=14.12..14.12 rows=470 width=0) (actual time=288.294..288.294 rows=0 loops=1)

10. 217.286 217.286 ↑ 31.4 5 1

Bitmap Index Scan on input_input_trgm_idx (cost=0.00..4.59 rows=157 width=0) (actual time=217.284..217.286 rows=5 loops=1)

  • Index Cond: (input ~~ 'www.sarawakreport.org%'::text)
11. 37.717 37.717 ↑ 39.2 4 1

Bitmap Index Scan on input_input_trgm_idx (cost=0.00..4.59 rows=157 width=0) (actual time=37.715..37.717 rows=4 loops=1)

  • Index Cond: (input ~~ 'http://www.sarawakreport.org%'::text)
12. 33.289 33.289 ↓ 0.0 0 1

Bitmap Index Scan on input_input_trgm_idx (cost=0.00..4.59 rows=157 width=0) (actual time=33.286..33.289 rows=0 loops=1)

  • Index Cond: (input ~~ 'https://www.sarawakreport.org%'::text)
13. 7.150 7.150 ↑ 1.0 1 286

Index Scan using report_pkey on report (cost=0.43..1.84 rows=1 width=97) (actual time=0.024..0.025 rows=1 loops=286)

  • Index Cond: (report_no = measurement.report_no)
  • Filter: (probe_cc = 'MY'::bpchar)
Planning time : 2.571 ms
Execution time : 22,602.378 ms