explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZfjG

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 86.699 ↓ 0.0 0 1

WindowAgg (cost=9,441.46..9,680.48 rows=27 width=210) (actual time=86.699..86.699 rows=0 loops=1)

2. 0.000 87.336 ↓ 0.0 0 1

Gather Merge (cost=9,441.46..9,679.87 rows=27 width=154) (actual time=86.697..87.336 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.000 158.232 ↓ 0.0 0 3

Nested Loop (cost=8,441.43..8,676.73 rows=11 width=154) (actual time=52.744..52.744 rows=0 loops=3)

4. 0.003 158.232 ↓ 0.0 0 3

Nested Loop (cost=8,441.15..8,673.40 rows=11 width=95) (actual time=52.744..52.744 rows=0 loops=3)

  • Join Filter: (sensor.sid = event.sid)
5. 0.000 158.229 ↓ 0.0 0 3

Nested Loop (cost=8,440.72..8,672.74 rows=1 width=95) (actual time=52.743..52.743 rows=0 loops=3)

  • Join Filter: (sensor.sid = iphdr.sid)
6. 0.003 158.229 ↓ 0.0 0 3

Merge Join (cost=8,440.29..8,454.47 rows=240 width=59) (actual time=52.743..52.743 rows=0 loops=3)

  • Merge Cond: (tcphdr.sid = sensor.sid)
7. 0.036 158.226 ↓ 0.0 0 3

Sort (cost=8,435.84..8,439.18 rows=1,336 width=40) (actual time=52.742..52.742 rows=0 loops=3)

  • Sort Key: tcphdr.sid
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
8. 81.273 158.190 ↓ 0.0 0 3

Hash Join (cost=1,515.55..8,366.47 rows=1,336 width=40) (actual time=52.729..52.730 rows=0 loops=3)

  • Hash Cond: ((tcphdr.sid = udphdr.sid) AND (tcphdr.cid = udphdr.cid))
9. 33.687 33.687 ↑ 1.2 128,888 3

Parallel Seq Scan on tcphdr (cost=0.00..6,005.10 rows=161,110 width=20) (actual time=0.008..11.229 rows=128,888 loops=3)

10. 29.080 43.230 ↑ 1.0 46,822 2

Hash (cost=813.22..813.22 rows=46,822 width=20) (actual time=21.615..21.615 rows=46,822 loops=2)

  • Buckets: 65536 Batches: 1 Memory Usage: 3073kB
11. 14.150 14.150 ↑ 1.0 46,822 2

Seq Scan on udphdr (cost=0.00..813.22 rows=46,822 width=20) (actual time=0.021..7.075 rows=46,822 loops=2)

12. 0.000 0.000 ↓ 0.0 0

Sort (cost=4.46..4.54 rows=34 width=19) (never executed)

  • Sort Key: sensor.sid
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on sensor (cost=0.00..3.59 rows=34 width=19) (never executed)

  • 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))
14. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((sid = tcphdr.sid) AND (cid = tcphdr.cid))
15. 0.000 0.000 ↓ 0.0 0

Index Scan using event_pkey on event (cost=0.43..0.65 rows=1 width=36) (never executed)

  • Index Cond: ((sid = iphdr.sid) AND (cid = iphdr.cid))
16. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (sig_id = event.signature)