explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eEJP

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.122 ↓ 0.0 0 1

Limit (cost=21.08..21.09 rows=1 width=68) (actual time=0.116..0.122 rows=0 loops=1)

  • OR (((locked_on)::text = '1.2.3.4'::text) AND (locked_by = 'ip_address'::lockouts_locked_by)) OR (((((locked_on)::inet - '0.0.0.0'::inet) & '4294967040'::bigint) = '16909056'::bigint) AND (locked_by = 'ip_address_subnet'::lockouts_locked_by))))
2. 0.024 0.107 ↓ 0.0 0 1

Sort (cost=21.08..21.09 rows=1 width=68) (actual time=0.101..0.107 rows=0 loops=1)

  • Sort Key: golf_six DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.016 0.083 ↓ 0.0 0 1

Bitmap Heap Scan on lima (cost=12.50..21.07 rows=1 width=68) (actual time=0.076..0.083 rows=0 loops=1)

  • Recheck Cond: ((((golf_delta)::text = 'five'::text) AND (two_mike = 'two_foxtrot'::sierra)) OR (((golf_delta)::text ='kilo'::text) AND (two_mike = 'seven'::sierra)) OR (two_mike = 'charlie'::sierra))
  • Filter: ((golf_six >= zulu()) AND ((((golf_delta)::text = 'five'::text) AND (two_mike = 'two_foxtrot'::sierra))
4. 0.015 0.067 ↓ 0.0 0 1

BitmapOr (cost=12.50..12.50 rows=4 width=0) (actual time=0.061..0.067 rows=0 loops=1)

5. 0.024 0.024 ↓ 0.0 0 1

Bitmap Index Scan on victor (cost=0.00..4.16 rows=1 width=0) (actual time=0.017..0.024 rows=0 loops=1)

  • Index Cond: (((golf_delta)::text = 'five'::text) AND (two_mike = 'two_foxtrot'::sierra))
6. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on victor (cost=0.00..4.16 rows=1 width=0) (actual time=0.008..0.014 rows=0 loops=1)

  • Index Cond: (((golf_delta)::text = 'kilo'::text) AND (two_mike = 'seven'::sierra))
7. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on golf_zulu (cost=0.00..4.18 rows=4 width=0) (actual time=0.008..0.014 rows=0 loops=1)

  • Index Cond: (two_mike = 'charlie'::sierra)
Planning time : 0.601 ms
Execution time : 0.336 ms