explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P8Vo

Settings
# exclusive inclusive rows x rows loops node
1. 56.851 409.034 ↓ 1.2 16 1

GroupAggregate (cost=28,715.07..28,787.31 rows=13 width=16) (actual time=306.100..409.034 rows=16 loops=1)

  • Group Key: traces."destinationDomain
2. 129.667 352.183 ↓ 37.7 362,770 1

Sort (cost=28,715.07..28,739.11 rows=9,615 width=12) (actual time=304.533..352.183 rows=362,770 loops=1)

  • Sort Key: traces."destinationDomain
  • Sort Method: external merge Disk: 8064kB
3. 22.261 222.516 ↓ 37.7 362,770 1

Gather (cost=8,849.20..28,078.99 rows=9,615 width=12) (actual time=122.771..222.516 rows=362,770 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 28.288 200.255 ↓ 30.2 120,923 3

Hash Left Join (cost=7,849.20..26,117.49 rows=4,006 width=12) (actual time=123.391..200.255 rows=120,923 loops=3)

  • Hash Cond: (occurrences."IncidentId" = incidents.id)
  • Filter: (((incidents.status)::text = 'active'::text) OR (incidents.id IS NULL))
5. 77.938 171.907 ↑ 1.2 120,923 3

Parallel Hash Left Join (cost=7,846.21..25,688.75 rows=145,076 width=12) (actual time=123.271..171.907 rows=120,923 loops=3)

  • Hash Cond: ((traces.id)::text = (occurrences."TraceId")::text)
6. 32.349 32.349 ↑ 1.2 69,088 3

Parallel Seq Scan on traces (cost=0.00..14,572.28 rows=86,342 width=36) (actual time=0.068..32.349 rows=69,088 loops=3)

  • Filter: (("destinationDomain" IS NOT NULL) AND ("projectId" = 1))
7. 38.210 61.620 ↑ 1.3 116,027 3

Parallel Hash (cost=5,040.76..5,040.76 rows=145,076 width=32) (actual time=61.620..61.620 rows=116,027 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 3328kB
8. 23.410 23.410 ↑ 1.3 116,027 3

Parallel Seq Scan on occurrences (cost=0.00..5,040.76 rows=145,076 width=32) (actual time=0.019..23.410 rows=116,027 loops=3)

9. 0.017 0.060 ↑ 1.0 44 3

Hash (cost=2.44..2.44 rows=44 width=520) (actual time=0.060..0.060 rows=44 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 0.043 0.043 ↑ 1.0 44 3

Seq Scan on incidents (cost=0.00..2.44 rows=44 width=520) (actual time=0.028..0.043 rows=44 loops=3)

Planning time : 0.435 ms
Execution time : 420.475 ms