explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AeS2

Settings
# exclusive inclusive rows x rows loops node
1. 0.691 5,783.846 ↑ 3.8 4 1

Gather (cost=1,000.00..60,655.68 rows=15 width=4) (actual time=5,650.601..5,783.846 rows=4 loops=1)

  • Output: id
  • Workers Planned: 4
  • Workers Launched: 0
  • Buffers: shared hit=52947
2. 5,783.155 5,783.155 ↑ 1.0 4 1

Parallel Seq Scan on jenkins.netrika_lab_test_result (cost=0.00..59,654.18 rows=4 width=4) (actual time=5,649.916..5,783.155 rows=4 loops=1)

  • Output: id
  • Filter: (netrika_lab_test_result.diagnostic_report_guid = 'a9a33432-802e-4095-ad2f-796d5bafbe56'::text)
  • Rows Removed by Filter: 2151034
  • Buffers: shared hit=52947
Planning time : 0.093 ms
Execution time : 5,783.992 ms