explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KSMT

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.111 ↑ 1.0 1 1

Limit (cost=81.31..81.31 rows=1 width=326) (actual time=0.110..0.111 rows=1 loops=1)

2. 0.014 0.110 ↑ 14.0 1 1

Sort (cost=81.31..81.34 rows=14 width=326) (actual time=0.110..0.110 rows=1 loops=1)

  • Sort Key: rpi_operation.operation_date DESC, rpi_operation.id DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.022 0.096 ↑ 2.8 5 1

HashAggregate (cost=81.10..81.24 rows=14 width=326) (actual time=0.095..0.096 rows=5 loops=1)

  • Group Key: rpi_operation.id, rpi_operation.rpi_id, rpi_operation.operation_type, rpi_operation.operation_date, rpi_operation.linked_item_type, rpi_operation.linked_item_barcode, rpi_operation.barcode, rpi_operation.sc_site_id, rpi_operation.sc_user_id, rpi_operation.rpi_assignment_id, rpi_operation.cell_seal_id, rpi_operation.sc_workstation_id, rpi_operation.arm_id, rpi_operation.changed_properties, rpi_operation.big_data_id, rpi_operation.linked_container_id, rpi_operation.linked_cell_seal_id, rpi_operation.details, rpi_operation.violation_report_operation_id, rpi_operation.session_id, rpi_operation.sortmachine_id, rpi_operation.operation_type_code, rpi_operation.sorting_plan_id, rpi_operation.register_main_office_id
4. 0.001 0.074 ↑ 1.4 10 1

Append (cost=0.56..80.26 rows=14 width=326) (actual time=0.040..0.074 rows=10 loops=1)

5. 0.047 0.047 ↑ 1.6 5 1

Index Scan using idx_rpi_operation_barcode on rpi_operation (cost=0.56..36.69 rows=8 width=499) (actual time=0.040..0.047 rows=5 loops=1)

  • Index Cond: (barcode = '14080432013314'::text)
6. 0.001 0.026 ↑ 1.2 5 1

Nested Loop (cost=0.86..43.43 rows=6 width=499) (actual time=0.022..0.026 rows=5 loops=1)

7. 0.016 0.016 ↑ 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.015..0.016 rows=1 loops=1)

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

Index Scan using idx_rpi_operation_rpi_id on rpi_operation rpi_operation_1 (cost=0.43..34.90 rows=8 width=499) (actual time=0.006..0.009 rows=5 loops=1)

  • Index Cond: (rpi_id = session_rpi.id)
Planning time : 1.864 ms
Execution time : 0.241 ms