explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6qyi

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 61,370.004 ↓ 0.0 0 1

Limit (cost=0.86..480,274.65 rows=1 width=504) (actual time=61,370.004..61,370.004 rows=0 loops=1)

2. 5,128.712 61,370.003 ↓ 0.0 0 1

Nested Loop (cost=0.86..6,723,833.83 rows=14 width=504) (actual time=61,370.003..61,370.003 rows=0 loops=1)

3. 36,891.125 36,891.125 ↑ 1.0 9,675,083 1

Index Scan Backward using idx_rpi_operation_operation_date on rpi_operation (cost=0.43..1,978,998.25 rows=9,688,973 width=504) (actual time=6.422..36,891.125 rows=9,675,083 loops=1)

4. 19,350.166 19,350.166 ↓ 0.0 0 9,675,083

Index Scan using session_rpi_pkey on session_rpi (cost=0.43..0.48 rows=1 width=22) (actual time=0.002..0.002 rows=0 loops=9,675,083)

  • Index Cond: (id = rpi_operation.rpi_id)
  • Filter: ((rpi_operation.barcode = '1409742800279913'::text) OR (barcode = '1409742800279913'::text))
  • Rows Removed by Filter: 1
Planning time : 1.411 ms
Execution time : 61,370.073 ms