explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uOVO

Settings
# exclusive inclusive rows x rows loops node
1. 126.344 3,337.420 ↓ 0.0 0 1

Gather (cost=1,000.00..60,654.28 rows=1 width=4) (actual time=3,337.420..3,337.420 rows=0 loops=1)

  • Output: id
  • Workers Planned: 4
  • Workers Launched: 1
  • Buffers: shared hit=53759
2. 3,211.076 3,211.076 ↓ 0.0 0 2

Parallel Seq Scan on jenkins.netrika_lab_test_result (cost=0.00..59,654.18 rows=1 width=4) (actual time=3,211.076..3,211.076 rows=0 loops=2)

  • Output: id
  • Filter: ((netrika_lab_test_result.netrica_observation_guid IS NULL) AND (netrika_lab_test_result.diagnostic_report_guid = 'a9a33432-802e-4095-ad2f-796d5bafbe56'::text))
  • Rows Removed by Filter: 1075519
  • Buffers: shared hit=52947
  • Worker 0: actual time=3085.713..3085.713 rows=0 loops=1
  • Buffers: shared hit=21532
Planning time : 0.068 ms
Execution time : 3,489.526 ms