explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sQDY

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.023 ↑ 1.0 1 1

Result (cost=12.66..12.67 rows=1 width=1) (actual time=0.022..0.023 rows=1 loops=1)

2.          

Initplan (for Result)

3. 0.011 0.021 ↑ 1.0 1 1

Bitmap Heap Scan on driver_problem_types (cost=4.18..12.66 rows=1 width=0) (actual time=0.021..0.021 rows=1 loops=1)

  • Recheck Cond: (org_id = '188f6bd9-9242-4155-ab27-c700f109acdc'::uuid)
  • Filter: (lower(name) = 'new option1'::text)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=1
4. 0.010 0.010 ↓ 3.2 13 1

Bitmap Index Scan on uq_driver_problem_types_org_id_name (cost=0.00..4.18 rows=4 width=0) (actual time=0.010..0.010 rows=13 loops=1)

  • Index Cond: (org_id = '188f6bd9-9242-4155-ab27-c700f109acdc'::uuid)