explain.depesz.com

PostgreSQL's explain analyze made readable

Result: udcc

Settings
# exclusive inclusive rows x rows loops node
1. 5.346 5,165.493 ↑ 1.1 16,938 1

Hash Join (cost=5,909.43..18,205.45 rows=17,873 width=765) (actual time=5,151.768..5,165.493 rows=16,938 loops=1)

  • Hash Cond: (contacts.company_id = companies.id)
2. 9.070 5,131.980 ↑ 1.1 16,938 1

Bitmap Heap Scan on contacts (cost=253.94..12,304.21 rows=17,873 width=765) (actual time=5,123.500..5,131.980 rows=16,938 loops=1)

  • Recheck Cond: ((edrpou)::text = '31316718'::text)
  • Heap Blocks: exact=5697
3. 5,122.910 5,122.910 ↑ 1.1 16,999 1

Bitmap Index Scan on ix_contacts_edrpou (cost=0.00..249.47 rows=17,873 width=0) (actual time=5,122.910..5,122.910 rows=16,999 loops=1)

  • Index Cond: ((edrpou)::text = '31316718'::text)
4. 11.532 28.167 ↓ 1.0 102,161 1

Hash (cost=4,379.66..4,379.66 rows=102,066 width=16) (actual time=28.167..28.167 rows=102,161 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5813kB
5. 16.635 16.635 ↓ 1.0 102,161 1

Seq Scan on companies (cost=0.00..4,379.66 rows=102,066 width=16) (actual time=0.007..16.635 rows=102,161 loops=1)

Planning time : 0.210 ms
Execution time : 5,165.898 ms