explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z9iY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.051 ↓ 0.0 0 1

Limit (cost=77.60..77.60 rows=1 width=504) (actual time=0.051..0.051 rows=0 loops=1)

2.          

Initplan (forLimit)

3. 0.000 0.012 ↓ 0.0 0 1

Limit (cost=0.43..8.45 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)

4. 0.012 0.012 ↓ 0.0 0 1

Index Scan using idx_session_rpi_barcode on session_rpi (cost=0.43..8.45 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (barcode = '1409742800279913'::text)
5. 0.006 0.050 ↓ 0.0 0 1

Sort (cost=69.16..69.19 rows=15 width=504) (actual time=0.050..0.050 rows=0 loops=1)

  • Sort Key: rpi_operation.operation_date DESC
  • Sort Method: quicksort Memory: 25kB
6. 0.000 0.044 ↓ 0.0 0 1

Bitmap Heap Scan on rpi_operation (cost=9.12..69.08 rows=15 width=504) (actual time=0.044..0.044 rows=0 loops=1)

  • Recheck Cond: ((barcode = '1409742800279913'::text) OR (rpi_id = $0))
7. 0.003 0.045 ↓ 0.0 0 1

BitmapOr (cost=9.12..9.12 rows=15 width=0) (actual time=0.044..0.045 rows=0 loops=1)

8. 0.028 0.028 ↓ 0.0 0 1

Bitmap Index Scan on idx_rpi_operation_barcode (cost=0.00..4.62 rows=8 width=0) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: (barcode = '1409742800279913'::text)
9. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on idx_rpi_operation_rpi_id (cost=0.00..4.49 rows=8 width=0) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (rpi_id = $0)
Planning time : 0.424 ms
Execution time : 0.105 ms