explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wtL3

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 5,676.128 ↓ 0.0 0 1

WindowAgg (cost=1,001.56..65,859.15 rows=1 width=210) (actual time=5,676.128..5,676.128 rows=0 loops=1)

2. 0.001 5,676.126 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,001.56..65,859.13 rows=1 width=154) (actual time=5,676.126..5,676.126 rows=0 loops=1)

3. 0.000 5,676.125 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,001.27..65,850.82 rows=1 width=146) (actual time=5,676.125..5,676.125 rows=0 loops=1)

4. 0.001 5,676.125 ↓ 0.0 0 1

Nested Loop (cost=1,000.85..65,842.38 rows=1 width=138) (actual time=5,676.125..5,676.125 rows=0 loops=1)

5. 0.000 5,676.124 ↓ 0.0 0 1

Nested Loop (cost=1,000.42..65,833.93 rows=1 width=114) (actual time=5,676.124..5,676.124 rows=0 loops=1)

6. 0.016 5,676.124 ↓ 0.0 0 1

Nested Loop (cost=1,000.14..65,825.62 rows=1 width=55) (actual time=5,676.124..5,676.124 rows=0 loops=1)

  • Join Filter: (event.sid = sensor.sid)
7. 0.059 0.059 ↓ 1.4 47 1

Index Scan using sensor_pkey on sensor (cost=0.14..17.94 rows=34 width=19) (actual time=0.019..0.059 rows=47 loops=1)

  • Filter: ((handler_group_2_shifts < 100) AND (handler_group_3_shifts < 100) AND (handler_group_4_shifts < 100) AND (handler_group_5_shifts < 100) AND (handler_group_6_shifts < 100) AND (handler_group_7_shifts < 100) AND (handler_group_8_shifts < 100) AND (handler_group_9_shifts < 100) AND (handler_group_10_shifts < 100))
  • Rows Removed by Filter: 2
8. 0.000 5,676.049 ↓ 0.0 0 47

Materialize (cost=1,000.00..65,807.18 rows=1 width=36) (actual time=120.767..120.767 rows=0 loops=47)

9. 25.123 5,678.346 ↓ 0.0 0 1

Gather (cost=1,000.00..65,807.17 rows=1 width=36) (actual time=5,676.049..5,678.346 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
10. 5,653.223 5,653.223 ↓ 0.0 0 3

Parallel Seq Scan on event (cost=0.00..64,807.07 rows=1 width=36) (actual time=5,653.223..5,653.223 rows=0 loops=3)

  • Filter: (reviewed_by = 0)
  • Rows Removed by Filter: 549742
11. 0.000 0.000 ↓ 0.0 0

Index Scan using signature_pkey on signature (cost=0.29..8.30 rows=1 width=59) (never executed)

  • Index Cond: (sig_id = event.signature)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using iphdr_pkey on iphdr (cost=0.43..8.45 rows=1 width=36) (never executed)

  • Index Cond: ((sid = event.sid) AND (cid = event.cid))
13. 0.000 0.000 ↓ 0.0 0

Index Scan using tcphdr_pkey on tcphdr (cost=0.42..8.44 rows=1 width=20) (never executed)

  • Index Cond: ((sid = event.sid) AND (cid = event.cid))
14. 0.000 0.000 ↓ 0.0 0

Index Scan using udphdr_pkey on udphdr (cost=0.29..8.31 rows=1 width=20) (never executed)

  • Index Cond: ((sid = event.sid) AND (cid = event.cid))
Planning time : 4.489 ms
Execution time : 5,678.620 ms