explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wbJu

Settings
# exclusive inclusive rows x rows loops node
1. 13.440 52.081 ↓ 2.1 88,429 1

Hash Join (cost=40.57..2,237.51 rows=42,934 width=70) (actual time=0.487..52.081 rows=88,429 loops=1)

  • Hash Cond: (we.fk_entity = e.id)
2. 15.130 38.447 ↓ 2.1 88,429 1

Hash Join (cost=19.93..2,103.25 rows=42,934 width=86) (actual time=0.288..38.447 rows=88,429 loops=1)

  • Hash Cond: (we.fk_entity = company_whitelist_entry.fk_entity)
3. 23.046 23.046 ↓ 1.0 91,315 1

Seq Scan on company_whitelist_entry we (cost=0.00..1,849.99 rows=88,099 width=78) (actual time=0.011..23.046 rows=91,315 loops=1)

4. 0.064 0.271 ↓ 1.8 414 1

Hash (cost=17.05..17.05 rows=231 width=8) (actual time=0.271..0.271 rows=414 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
5. 0.092 0.207 ↓ 1.8 414 1

Unique (cost=0.42..14.74 rows=231 width=8) (actual time=0.022..0.207 rows=414 loops=1)

6. 0.115 0.115 ↓ 1.3 414 1

Index Only Scan using company_whitelist_entry_pkey on company_whitelist_entry (cost=0.42..13.95 rows=316 width=8) (actual time=0.022..0.115 rows=414 loops=1)

  • Index Cond: (fk_facility = 1,210,252,920)
  • Heap Fetches: 19
7. 0.088 0.194 ↓ 1.0 523 1

Hash (cost=14.17..14.17 rows=517 width=8) (actual time=0.194..0.194 rows=523 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 29kB
8. 0.106 0.106 ↓ 1.0 523 1

Seq Scan on company e (cost=0.00..14.17 rows=517 width=8) (actual time=0.006..0.106 rows=523 loops=1)

Planning time : 0.341 ms
Execution time : 55.393 ms