explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 83nD

Settings
# exclusive inclusive rows x rows loops node
1. 0.066 0.102 ↑ 4.0 4 1

Bitmap Heap Scan on jenkins.netrika_lab_test_result (cost=4.68..68.04 rows=16 width=4) (actual time=0.101..0.102 rows=4 loops=1)

  • Output: id
  • Recheck Cond: (netrika_lab_test_result.diagnostic_report_guid = 'a9a33432-802e-4095-ad2f-796d5bafbe56'::text)
  • Heap Blocks: exact=2
  • Buffers: shared hit=6
2. 0.036 0.036 ↑ 3.2 5 1

Bitmap Index Scan on netrika_lab_test_result_diagnostic_report_guid_idx (cost=0.00..4.67 rows=16 width=0) (actual time=0.036..0.036 rows=5 loops=1)

  • Index Cond: (netrika_lab_test_result.diagnostic_report_guid = 'a9a33432-802e-4095-ad2f-796d5bafbe56'::text)
  • Buffers: shared hit=4
Planning time : 0.067 ms
Execution time : 0.127 ms