explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FVu1

Settings
# exclusive inclusive rows x rows loops node
1. 1,587.723 115,547.156 ↑ 31.3 53,024 1

GroupAggregate (cost=782,434.90..919,526.55 rows=1,661,717 width=326) (actual time=92,338.501..115,547.156 rows=53,024 loops=1)

  • Group Key: sensor.dev_id, signature.sig_id, iphdr.ip_src, iphdr.ip_src_name, iphdr.ip_dst, iphdr.ip_dst_name, sensor.cl_id
2. 69,789.194 113,959.433 ↑ 1.0 1,649,246 1

Sort (cost=782,434.90..786,589.19 rows=1,661,717 width=189) (actual time=92,338.479..113,959.433 rows=1,649,246 loops=1)

  • Sort Key: sensor.dev_id, signature.sig_id, iphdr.ip_src, iphdr.ip_src_name, iphdr.ip_dst, iphdr.ip_dst_name, sensor.cl_id
  • Sort Method: external merge Disk: 305,928kB
3. 646.189 44,170.239 ↑ 1.0 1,649,246 1

Hash Left Join (cost=117,517.80..304,039.28 rows=1,661,717 width=189) (actual time=10,496.393..44,170.239 rows=1,649,246 loops=1)

  • Hash Cond: ((event.cid = udphdr.cid) AND (event.sid = udphdr.sid))
4. 571.668 43,506.568 ↑ 1.0 1,649,246 1

Hash Left Join (cost=116,002.25..293,799.71 rows=1,661,717 width=181) (actual time=10,478.832..43,506.568 rows=1,649,246 loops=1)

  • Hash Cond: (event.signature = signature.sig_id)
5. 532.788 42,931.612 ↑ 1.0 1,649,246 1

Hash Right Join (cost=115,658.38..289,091.87 rows=1,661,717 width=122) (actual time=10,475.514..42,931.612 rows=1,649,246 loops=1)

  • Hash Cond: (event.sid = sensor.sid)
6. 17,658.500 42,398.781 ↑ 1.0 1,649,225 1

Hash Left Join (cost=115,655.27..284,349.47 rows=1,661,717 width=107) (actual time=10,475.463..42,398.781 rows=1,649,225 loops=1)

  • Hash Cond: ((event.cid = iphdr.cid) AND (event.sid = iphdr.sid))
7. 5,564.031 22,884.522 ↑ 1.0 1,649,225 1

Hash Left Join (cost=16,326.58..126,123.76 rows=1,661,717 width=44) (actual time=1,796.226..22,884.522 rows=1,649,225 loops=1)

  • Hash Cond: ((event.cid = tcphdr.cid) AND (event.sid = tcphdr.sid))
8. 17,144.955 17,144.955 ↑ 1.0 1,649,225 1

Seq Scan on event (cost=0.00..72,841.17 rows=1,661,717 width=36) (actual time=1,620.607..17,144.955 rows=1,649,225 loops=1)

9. 118.858 175.536 ↑ 1.0 386,663 1

Hash (cost=8,260.63..8,260.63 rows=386,663 width=20) (actual time=175.536..175.536 rows=386,663 loops=1)

  • Buckets: 65,536 Batches: 8 Memory Usage: 2,966kB
10. 56.678 56.678 ↑ 1.0 386,663 1

Seq Scan on tcphdr (cost=0.00..8,260.63 rows=386,663 width=20) (actual time=0.014..56.678 rows=386,663 loops=1)

11. 1,347.838 1,855.759 ↓ 1.0 1,651,372 1

Hash (cost=53,597.28..53,597.28 rows=1,651,228 width=75) (actual time=1,855.759..1,855.759 rows=1,651,372 loops=1)

  • Buckets: 65,536 Batches: 64 Memory Usage: 3,469kB
12. 507.921 507.921 ↓ 1.0 1,651,372 1

Seq Scan on iphdr (cost=0.00..53,597.28 rows=1,651,228 width=75) (actual time=0.010..507.921 rows=1,651,372 loops=1)

13. 0.015 0.043 ↑ 1.0 49 1

Hash (cost=2.49..2.49 rows=49 width=19) (actual time=0.043..0.043 rows=49 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
14. 0.028 0.028 ↑ 1.0 49 1

Seq Scan on sensor (cost=0.00..2.49 rows=49 width=19) (actual time=0.013..0.028 rows=49 loops=1)

  • Filter: ((handler_group_2_shifts IS NOT NULL) OR (handler_group_3_shifts IS NOT NULL) OR (handler_group_4_shifts IS NOT NULL) OR (handler_group_5_shifts IS NOT NULL) OR (handler_group_6_shifts IS NOT NULL) OR (handler_group_7_shifts IS NOT NULL) OR (handler_group_8_shifts IS NOT NULL) OR (handler_group_9_shifts IS NOT NULL) OR (handler_group_10_shifts IS NOT NULL))
15. 1.868 3.288 ↑ 1.0 9,372 1

Hash (cost=226.72..226.72 rows=9,372 width=59) (actual time=3.288..3.288 rows=9,372 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 999kB
16. 1.420 1.420 ↑ 1.0 9,372 1

Seq Scan on signature (cost=0.00..226.72 rows=9,372 width=59) (actual time=0.011..1.420 rows=9,372 loops=1)

17. 11.025 17.482 ↑ 1.0 46,822 1

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

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,890kB
18. 6.457 6.457 ↑ 1.0 46,822 1

Seq Scan on udphdr (cost=0.00..813.22 rows=46,822 width=20) (actual time=0.011..6.457 rows=46,822 loops=1)