explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wSwb

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 36,101.928 ↑ 1.0 1 1

Limit (cost=8.88..9.31 rows=1 width=499) (actual time=36,101.926..36,101.928 rows=1 loops=1)

2. 36,101.887 36,101.924 ↑ 4,764,961.0 1 1

Index Scan Backward using idx_rpi_operation_operation_date on rpi_operation (cost=8.88..2,025,838.47 rows=4,764,961 width=499) (actual time=36,101.924..36,101.924 rows=1 loops=1)

  • Filter: ((barcode = '14080432013314'::text) OR (hashed SubPlan 1))
  • Rows Removed by Filter: 8596795
3.          

SubPlan (forIndex Scan Backward)

4. 0.037 0.037 ↑ 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.036..0.037 rows=1 loops=1)

  • Index Cond: (barcode = '14080432013314'::text)
Planning time : 0.468 ms
Execution time : 36,102.058 ms