explain.depesz.com

PostgreSQL's explain analyze made readable

Result: umUe

Settings
# exclusive inclusive rows x rows loops node
1. 28.446 4,025.409 ↑ 4.2 48 1

GroupAggregate (cost=464,743.34..464,867.48 rows=200 width=24) (actual time=3,987.164..4,025.409 rows=48 loops=1)

  • Group Key: s.sample_hour
2. 66.958 3,996.963 ↓ 33.1 194,880 1

Sort (cost=464,743.34..464,758.04 rows=5,882 width=32) (actual time=3,986.349..3,996.963 rows=194,880 loops=1)

  • Sort Key: s.sample_hour
  • Sort Method: quicksort Memory: 16,702kB
3. 36.086 3,930.005 ↓ 33.1 194,880 1

Nested Loop Left Join (cost=2.82..464,375.06 rows=5,882 width=32) (actual time=11.025..3,930.005 rows=194,880 loops=1)

4. 35.481 3,504.159 ↓ 33.1 194,880 1

Nested Loop Left Join (cost=2.26..414,756.80 rows=5,882 width=36) (actual time=10.999..3,504.159 rows=194,880 loops=1)

5. 36.273 3,078.918 ↓ 33.1 194,880 1

Nested Loop Left Join (cost=1.69..365,262.53 rows=5,882 width=32) (actual time=10.970..3,078.918 rows=194,880 loops=1)

6. 55.368 2,652.885 ↓ 33.1 194,880 1

Nested Loop Left Join (cost=1.13..315,644.27 rows=5,882 width=28) (actual time=10.946..2,652.885 rows=194,880 loops=1)

7. 51.109 2,207.757 ↓ 33.1 194,880 1

Nested Loop Left Join (cost=0.56..266,006.00 rows=5,882 width=24) (actual time=10.925..2,207.757 rows=194,880 loops=1)

8. 134.851 1,766.888 ↓ 33.1 194,880 1

Nested Loop Left Join (cost=0.00..216,387.74 rows=5,882 width=20) (actual time=10.885..1,766.888 rows=194,880 loops=1)

9. 20.327 852.517 ↓ 33.1 194,880 1

Append (cost=0.00..170,020.80 rows=5,882 width=16) (actual time=10.779..852.517 rows=194,880 loops=1)

  • Subplans Removed: 2
10. 832.190 832.190 ↓ 576.6 194,880 1

Seq Scan on sample_2019_09_alvjcabb00t s (cost=0.00..32,995.02 rows=338 width=16) (actual time=10.778..832.190 rows=194,880 loops=1)

  • Filter: (((switch_name)::text = 'ALVJCABB00T'::text) AND (sample_hour >= (now() - '7 days'::interval)))
  • Rows Removed by Filter: 1,712,135
11. 779.520 779.520 ↓ 0.0 0 194,880

Index Scan using idx_reg_tru_hash on reg_tru tru (cost=0.00..7.88 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=194,880)

  • Index Cond: (s.id = sample_id)
  • Rows Removed by Index Recheck: 0
12. 389.760 389.760 ↓ 0.0 0 194,880

Index Scan using reg_tru2_pkey on reg_tru2 tru2 (cost=0.56..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=194,880)

  • Index Cond: (s.id = sample_id)
13. 389.760 389.760 ↓ 0.0 0 194,880

Index Scan using reg_incatot_pkey on reg_incatot incatot (cost=0.56..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=194,880)

  • Index Cond: (s.id = sample_id)
14. 389.760 389.760 ↓ 0.0 0 194,880

Index Scan using reg_incatot2_pkey on reg_incatot2 incatot2 (cost=0.56..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=194,880)

  • Index Cond: (s.id = sample_id)
15. 389.760 389.760 ↓ 0.0 0 194,880

Index Scan using reg_connect_pkey on reg_connect connect (cost=0.56..8.41 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=194,880)

  • Index Cond: (s.id = sample_id)
16. 389.760 389.760 ↓ 0.0 0 194,880

Index Scan using reg_connect2_pkey on reg_connect2 connect2 (cost=0.56..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=194,880)

  • Index Cond: (s.id = sample_id)