explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bzfy

Settings
# exclusive inclusive rows x rows loops node
1. 6.687 35.898 ↑ 1.0 1 1

Aggregate (cost=4,006.08..4,006.09 rows=1 width=8) (actual time=35.898..35.898 rows=1 loops=1)

2. 5.983 29.211 ↓ 1.1 116,382 1

Result (cost=0.43..3,731.35 rows=109,892 width=0) (actual time=0.023..29.211 rows=116,382 loops=1)

  • One-Time Filter: ((current_setting('nimble.company_id'::text))::bytea = '\x4d670aba143e3287b9d4427a'::bytea)
3. 23.228 23.228 ↓ 1.1 116,382 1

Index Only Scan using contacts_pkey on contacts (cost=0.43..3,731.35 rows=109,892 width=0) (actual time=0.018..23.228 rows=116,382 loops=1)

  • Index Cond: (company_id = '\x4d670aba143e3287b9d4427a'::bytea)
  • Heap Fetches: 22
Planning time : 0.163 ms
Execution time : 35.961 ms