explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RBMW

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

"Sort (cost=8.46..8.46 rows=1 width=286) (actual rows= loops=)

  • Sort Key: updated_on DESC
2. 0.000 0.000 ↓ 0.0

Index Scan using idx_document_print_status_doc_type on document_print_status (cost=0.42..8.45 rows=1 width=286) (actual rows= loops=)

  • Index Cond: ((doc_type)::text = 'RX'::text)
  • Filter: ((labjob_id = '291d0ce9-b34d-4c5b-b047-1fc4f55b19b0'::uuid) AND ((template_name)::text = ''::text))