explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CWbW

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 8.683 ↓ 0.0 0 1

Limit (cost=4,147.19..4,147.19 rows=1 width=1,901) (actual time=8.683..8.683 rows=0 loops=1)

2. 0.006 8.681 ↓ 0.0 0 1

Sort (cost=4,147.19..4,147.19 rows=1 width=1,901) (actual time=8.681..8.681 rows=0 loops=1)

  • Sort Key: vendor_invoice_number
  • Sort Method: quicksort Memory: 25kB
3. 8.028 8.675 ↓ 0.0 0 1

Bitmap Heap Scan on vendor_invoices (cost=57.13..4,147.18 rows=1 width=1,901) (actual time=8.675..8.675 rows=0 loops=1)

  • Recheck Cond: (company_id = 'a9781eb8-0b3d-11e5-aab8-5f018336d280'::uuid)
  • Filter: ((deleted IS NOT TRUE) AND (voided IS DISTINCT FROM true) AND ((vendor_invoice_number)::text ~~* 'REP%'::text))
  • Rows Removed by Filter: 5077
  • Heap Blocks: exact=3728
4. 0.647 0.647 ↓ 4.4 5,082 1

Bitmap Index Scan on vendor_invoices_post_date_key (cost=0.00..57.13 rows=1,160 width=0) (actual time=0.647..0.647 rows=5,082 loops=1)

  • Index Cond: (company_id = 'a9781eb8-0b3d-11e5-aab8-5f018336d280'::uuid)