explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FON6

Settings
# exclusive inclusive rows x rows loops node
1. 0.165 0.187 ↑ 1.0 4 1

Sort (cost=6.23..6.24 rows=4 width=4) (actual time=0.187..0.187 rows=4 loops=1)

  • Sort Key: supplier_invoice_issue_id
  • Sort Method: quicksort Memory: 25kB
2. 0.022 0.022 ↑ 1.0 4 1

Index Scan using supplier_invoice_issue_invoice_type_reference_unique on supplier_invoice_issue (cost=0.41..6.19 rows=4 width=4) (actual time=0.016..0.022 rows=4 loops=1)

  • Index Cond: (supplier_invoice_id = 776)
Planning time : 0.777 ms
Execution time : 0.203 ms