explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZhKl

Settings
# exclusive inclusive rows x rows loops node
1. 113.055 14,580.313 ↑ 3.9 174,240 1

Sort (cost=2,604,930.91..2,606,608.94 rows=671,215 width=249) (actual time=14,545.724..14,580.313 rows=174,240 loops=1)

  • Sort Key: signal."timestamp
  • Sort Method: quicksort Memory: 46487kB
2. 219.806 14,467.258 ↑ 3.9 174,240 1

HashAggregate (cost=2,533,257.17..2,539,969.32 rows=671,215 width=249) (actual time=14,378.538..14,467.258 rows=174,240 loops=1)

  • Group Key: signal.signal_id, parameter.name, parameter.unit, source_type.name, source.name, source.serial, site.name, quality.method, quality.flag
3. 32.432 14,247.452 ↑ 3.9 174,240 1

Hash Left Join (cost=1,257,887.22..2,516,476.80 rows=671,215 width=245) (actual time=4,081.686..14,247.452 rows=174,240 loops=1)

  • Hash Cond: (signal_quality.quality_id = quality.quality_id)
4. 32.823 14,215.009 ↑ 3.9 174,240 1

Hash Left Join (cost=1,257,885.97..2,507,246.34 rows=671,215 width=185) (actual time=4,081.646..14,215.009 rows=174,240 loops=1)

  • Hash Cond: (signals_signal_quality_association.signal_quality_id = signal_quality.signal_quality_id)
5. 39.206 14,182.084 ↑ 3.9 174,240 1

Hash Join (cost=1,257,874.98..2,498,006.15 rows=671,215 width=185) (actual time=4,081.523..14,182.084 rows=174,240 loops=1)

  • Hash Cond: (signal.parameter_id = parameter.parameter_id)
6. 40.084 14,142.850 ↑ 3.9 174,240 1

Hash Left Join (cost=1,257,872.86..2,488,774.82 rows=671,215 width=125) (actual time=4,081.482..14,142.850 rows=174,240 loops=1)

  • Hash Cond: (signal.site_id = site.site_id)
7. 8,752.790 14,102.734 ↑ 3.9 174,240 1

Hash Right Join (cost=1,257,869.73..2,479,542.49 rows=671,215 width=97) (actual time=4,081.412..14,102.734 rows=174,240 loops=1)

  • Hash Cond: (signals_signal_quality_association.signal_id = signal.signal_id)
8. 5,194.792 5,194.792 ↑ 1.0 67,047,743 1

Seq Scan on signals_signal_quality_association (cost=0.00..967,150.50 rows=67,047,850 width=8) (actual time=0.072..5,194.792 rows=67,047,743 loops=1)

9. 37.406 155.152 ↑ 5.3 126,720 1

Hash (cost=1,249,479.54..1,249,479.54 rows=671,215 width=93) (actual time=155.152..155.152 rows=126,720 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 21186kB
10. 40.451 117.746 ↑ 5.3 126,720 1

Hash Right Join (cost=1,249,438.37..1,249,479.54 rows=671,215 width=93) (actual time=81.298..117.746 rows=126,720 loops=1)

  • Hash Cond: (signals_comments_association.signal_id = signal.signal_id)
11. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on signals_comments_association (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.004..0.004 rows=0 loops=1)

12. 35.911 77.291 ↑ 5.3 126,720 1

Hash (cost=1,241,048.18..1,241,048.18 rows=671,215 width=89) (actual time=77.291..77.291 rows=126,720 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 20196kB
13. 16.416 41.380 ↑ 5.3 126,720 1

Nested Loop (cost=18,917.79..1,241,048.18 rows=671,215 width=89) (actual time=10.299..41.380 rows=126,720 loops=1)

14. 0.022 0.069 ↑ 1.0 1 1

Hash Join (cost=3.23..4.52 rows=1 width=65) (actual time=0.061..0.069 rows=1 loops=1)

  • Hash Cond: (source_type.source_type_id = source.source_type_id)
15. 0.018 0.018 ↑ 1.0 21 1

Seq Scan on source_type (cost=0.00..1.21 rows=21 width=36) (actual time=0.015..0.018 rows=21 loops=1)

16. 0.006 0.029 ↑ 1.0 1 1

Hash (cost=3.21..3.21 rows=1 width=37) (actual time=0.029..0.029 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.023 0.023 ↑ 1.0 1 1

Seq Scan on source (cost=0.00..3.21 rows=1 width=37) (actual time=0.015..0.023 rows=1 loops=1)

  • Filter: ((name)::text = 'bf_f06_11e_russikerstr'::text)
  • Rows Removed by Filter: 96
18. 14.848 24.895 ↑ 5.3 126,720 1

Bitmap Heap Scan on signal (cost=18,914.56..1,234,331.51 rows=671,215 width=32) (actual time=10.233..24.895 rows=126,720 loops=1)

  • Recheck Cond: ((source_id = source.source_id) AND ('2018-06-01 00:00:00'::timestamp without time zone <= "timestamp") AND ("timestamp" <= '2019-03-07 16:56:51'::timestamp without time zone))
  • Heap Blocks: exact=1374
19. 10.047 10.047 ↑ 5.3 126,720 1

Bitmap Index Scan on ix_timetamp_source_id (cost=0.00..18,746.76 rows=671,215 width=0) (actual time=10.047..10.047 rows=126,720 loops=1)

  • Index Cond: ((source_id = source.source_id) AND ('2018-06-01 00:00:00'::timestamp without time zone <= "timestamp") AND ("timestamp
20. 0.011 0.032 ↑ 1.0 50 1

Hash (cost=2.50..2.50 rows=50 width=36) (actual time=0.032..0.032 rows=50 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
21. 0.021 0.021 ↑ 1.0 50 1

Seq Scan on site (cost=0.00..2.50 rows=50 width=36) (actual time=0.013..0.021 rows=50 loops=1)

22. 0.015 0.028 ↑ 1.0 50 1

Hash (cost=1.50..1.50 rows=50 width=68) (actual time=0.028..0.028 rows=50 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
23. 0.013 0.013 ↑ 1.0 50 1

Seq Scan on parameter (cost=0.00..1.50 rows=50 width=68) (actual time=0.007..0.013 rows=50 loops=1)

24. 0.055 0.102 ↑ 1.0 355 1

Hash (cost=6.55..6.55 rows=355 width=8) (actual time=0.101..0.102 rows=355 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
25. 0.047 0.047 ↑ 1.0 355 1

Seq Scan on signal_quality (cost=0.00..6.55 rows=355 width=8) (actual time=0.012..0.047 rows=355 loops=1)

26. 0.005 0.011 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=68) (actual time=0.011..0.011 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
27. 0.006 0.006 ↑ 1.0 11 1

Seq Scan on quality (cost=0.00..1.11 rows=11 width=68) (actual time=0.005..0.006 rows=11 loops=1)