explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hp0Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.132 ↑ 1.0 1 1

Limit (cost=77.60..77.60 rows=1 width=504) (actual time=0.131..0.132 rows=1 loops=1)

2.          

Initplan (forLimit)

3. 0.001 0.021 ↑ 1.0 1 1

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

4. 0.020 0.020 ↑ 1.0 1 1

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

  • Index Cond: (barcode = '14080432013314'::text)
5. 0.054 0.130 ↑ 15.0 1 1

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

  • Sort Key: rpi_operation.operation_date DESC
  • Sort Method: top-N heapsort Memory: 25kB
6. 0.015 0.076 ↑ 3.0 5 1

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

  • Recheck Cond: ((barcode = '14080432013314'::text) OR (rpi_id = $0))
  • Heap Blocks: exact=4
7. 0.001 0.061 ↓ 0.0 0 1

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

8. 0.030 0.030 ↑ 1.6 5 1

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

  • Index Cond: (barcode = '14080432013314'::text)
9. 0.030 0.030 ↑ 1.6 5 1

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

  • Index Cond: (rpi_id = $0)
Planning time : 0.341 ms
Execution time : 0.178 ms