explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EXNl

Settings
# exclusive inclusive rows x rows loops node
1. 159.892 26,809.876 ↓ 26.3 236,173 1

Gather (cost=85,025.41..7,203,339.39 rows=8,988 width=4) (actual time=2,701.028..26,809.876 rows=236,173 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 22,789.101 26,649.984 ↓ 21.0 78,724 3 / 3

Hash Join (cost=84,025.41..7,201,440.59 rows=3,745 width=4) (actual time=2,699.547..26,649.984 rows=78,724 loops=3)

  • Hash Cond: (observation.camera_id = camera.id)
  • Join Filter: (((match.match)::text = (exemption.plate)::text) OR ((observation.manual)::text = (exemption.plate)::text))
  • Rows Removed by Join Filter: 260,012,558
3. 1,713.281 3,855.007 ↑ 1.1 2,246,616 3 / 3

Parallel Hash Left Join (cost=83,591.65..231,411.95 rows=2,432,169 width=26) (actual time=2,674.245..3,855.007 rows=2,246,616 loops=3)

  • Hash Cond: (observation.id = match.observation_id)
4. 379.310 379.310 ↑ 1.3 1,945,387 3 / 3

Parallel Seq Scan on observation (cost=0.00..89,391.69 rows=2,432,169 width=17) (actual time=0.042..379.310 rows=1,945,387 loops=3)

5. 398.454 1,762.416 ↑ 1.3 1,570,583 3 / 3

Parallel Hash (cost=49,464.29..49,464.29 rows=1,963,229 width=13) (actual time=1,762.416..1,762.416 rows=1,570,583 loops=3)

  • Buckets: 131,072 Batches: 128 Memory Usage: 2,784kB
6. 1,363.962 1,363.962 ↑ 1.3 1,570,583 3 / 3

Parallel Seq Scan on match (cost=0.00..49,464.29 rows=1,963,229 width=13) (actual time=0.345..1,363.962 rows=1,570,583 loops=3)

7. 2.337 5.876 ↑ 1.0 11,637 3 / 3

Hash (cost=283.99..283.99 rows=11,982 width=13) (actual time=5.876..5.876 rows=11,637 loops=3)

  • Buckets: 16,384 Batches: 1 Memory Usage: 671kB
8. 2.574 3.539 ↑ 1.0 11,637 3 / 3

Hash Join (cost=2.53..283.99 rows=11,982 width=13) (actual time=0.084..3.539 rows=11,637 loops=3)

  • Hash Cond: (exemption.area_id = camera.area_id)
9. 0.921 0.921 ↑ 1.0 5,794 3 / 3

Seq Scan on exemption (cost=0.00..110.94 rows=5,794 width=13) (actual time=0.027..0.921 rows=5,794 loops=3)

10. 0.015 0.044 ↑ 1.0 68 3 / 3

Hash (cost=1.68..1.68 rows=68 width=8) (actual time=0.044..0.044 rows=68 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
11. 0.029 0.029 ↑ 1.0 68 3 / 3

Seq Scan on camera (cost=0.00..1.68 rows=68 width=8) (actual time=0.020..0.029 rows=68 loops=3)

Planning time : 0.791 ms
Execution time : 26,826.071 ms