explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oaAO

Settings
# exclusive inclusive rows x rows loops node
1. 23.951 293.298 ↑ 22.9 1,016 1

Gather (cost=1,000.00..131,865.82 rows=23,239 width=1,648) (actual time=32.492..293.298 rows=1,016 loops=1)

  • Output: id, type, geography, data, tags, helios_createdat, helios_modifiedat, helios_deletedat, helios_audit, helios_activeat
  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=126,567
2. 269.347 269.347 ↑ 27.5 169 6 / 6

Parallel Seq Scan on public.entities (cost=0.00..128,541.91 rows=4,648 width=1,648) (actual time=20.537..269.347 rows=169 loops=6)

  • Output: id, type, geography, data, tags, helios_createdat, helios_modifiedat, helios_deletedat, helios_audit, helios_activeat
  • Filter: ((entities.helios_deletedat IS NULL) AND (entities.helios_deletedat IS NULL) AND (entities.type = 'eSmart.Utility.Models.Pole'::citext))
  • Rows Removed by Filter: 147,025
  • Buffers: shared hit=126,567
  • Worker 0: actual time=6.363..268.064 rows=187 loops=1
  • Buffers: shared hit=21,529
  • Worker 1: actual time=17.451..268.097 rows=141 loops=1
  • Buffers: shared hit=19,681
  • Worker 2: actual time=21.391..266.136 rows=179 loops=1
  • Buffers: shared hit=19,662
  • Worker 3: actual time=18.798..268.073 rows=155 loops=1
  • Buffers: shared hit=22,861
  • Worker 4: actual time=26.963..266.345 rows=156 loops=1
  • Buffers: shared hit=21,063
Planning time : 0.114 ms
Execution time : 293.404 ms