explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gnbl

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 91,833.610 ↑ 1.0 1 1

Limit (cost=0.86..474,990.01 rows=1 width=499) (actual time=91,833.608..91,833.610 rows=1 loops=1)

2. 0.000 91,833.605 ↑ 14.0 1 1

Nested Loop (cost=0.86..6,649,848.89 rows=14 width=499) (actual time=91,833.605..91,833.605 rows=1 loops=1)

3. 66,104.141 66,104.141 ↑ 1.1 8,596,796 1

Index Scan Backward using idx_rpi_operation_operation_date on rpi_operation (cost=0.43..1,978,180.45 rows=9,529,914 width=499) (actual time=174.106..66,104.141 rows=8,596,796 loops=1)

4. 25,790.388 25,790.388 ↓ 0.0 0 8,596,796

Index Scan using session_rpi_pkey on session_rpi (cost=0.43..0.48 rows=1 width=22) (actual time=0.003..0.003 rows=0 loops=8,596,796)

  • Index Cond: (id = rpi_operation.rpi_id)
  • Filter: ((rpi_operation.barcode = '14080432013314'::text) OR (barcode = '14080432013314'::text))
  • Rows Removed by Filter: 1
Planning time : 147.726 ms
Execution time : 91,833.745 ms