explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mhhf

Settings
# exclusive inclusive rows x rows loops node
1. 35.512 4,563.713 ↑ 4.2 48 1

GroupAggregate (cost=468,014.67..468,138.81 rows=200 width=24) (actual time=4,511.952..4,563.713 rows=48 loops=1)

  • Group Key: s.sample_hour
2. 107.528 4,528.201 ↓ 33.1 194,880 1

Sort (cost=468,014.67..468,029.37 rows=5,882 width=32) (actual time=4,510.272..4,528.201 rows=194,880 loops=1)

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

Nested Loop Left Join (cost=3.39..467,646.39 rows=5,882 width=32) (actual time=15.575..4,420.673 rows=194,880 loops=1)

4. 124.240 3,907.343 ↓ 33.1 194,880 1

Nested Loop Left Join (cost=2.82..418,028.13 rows=5,882 width=36) (actual time=15.505..3,907.343 rows=194,880 loops=1)

5. 139.994 3,393.343 ↓ 33.1 194,880 1

Nested Loop Left Join (cost=2.26..368,533.86 rows=5,882 width=32) (actual time=15.428..3,393.343 rows=194,880 loops=1)

6. 143.106 2,863.589 ↓ 33.1 194,880 1

Nested Loop Left Join (cost=1.69..318,915.60 rows=5,882 width=28) (actual time=15.391..2,863.589 rows=194,880 loops=1)

7. 0.000 2,330.723 ↓ 33.1 194,880 1

Nested Loop Left Join (cost=1.13..269,277.33 rows=5,882 width=24) (actual time=15.316..2,330.723 rows=194,880 loops=1)

8. 0.000 1,755.429 ↓ 33.1 194,880 1

Nested Loop Left Join (cost=0.56..219,659.07 rows=5,882 width=20) (actual time=15.277..1,755.429 rows=194,880 loops=1)

9. 21.689 1,197.293 ↓ 33.1 194,880 1

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

  • Subplans Removed: 2
10. 1,175.604 1,175.604 ↓ 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=15.147..1,175.604 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. 584.640 584.640 ↓ 0.0 0 194,880

Index Scan using reg_tru_pkey on reg_tru tru (cost=0.56..8.44 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=194,880)

  • Index Cond: (s.id = sample_id)
12. 584.640 584.640 ↓ 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.003..0.003 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)