explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d3JG

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

Nested Loop Left Join (cost=4.73..17.39 rows=1 width=1,775) (actual time=0.025..0.025 rows=0 loops=1)

2. 0.000 0.025 ↓ 0.0 0 1

Nested Loop (cost=4.16..13.79 rows=1 width=1,682) (actual time=0.025..0.025 rows=0 loops=1)

3. 0.001 0.025 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.58..10.18 rows=1 width=1,575) (actual time=0.025..0.025 rows=0 loops=1)

  • Join Filter: (merchant_type.id = merchant.type_id)
4. 0.000 0.024 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.58..8.88 rows=1 width=1,558) (actual time=0.024..0.024 rows=0 loops=1)

5. 0.000 0.024 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.30..5.58 rows=1 width=225) (actual time=0.024..0.024 rows=0 loops=1)

  • Join Filter: (crm_rating.id = merchant.rating_id)
6. 0.017 0.024 ↓ 0.0 0 1

Hash Right Join (cost=3.30..4.49 rows=1 width=213) (actual time=0.024..0.024 rows=0 loops=1)

  • Hash Cond: (employee_count.id = merchant.employee_count_id)
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on employee_count (cost=0.00..1.13 rows=13 width=13) (never executed)

8. 0.000 0.007 ↓ 0.0 0 1

Hash (cost=3.29..3.29 rows=1 width=200) (actual time=0.007..0.007 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
9. 0.007 0.007 ↓ 0.0 0 1

Index Scan using merchant_mrch_rt_entid_idx on merchant (cost=0.28..3.29 rows=1 width=200) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (merchant_root_entity_id = '2776918043'::bigint)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on crm_rating (cost=0.00..1.04 rows=4 width=12) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Index Scan using merchant_options_uniq on merchant_options (cost=0.27..3.29 rows=1 width=1,333) (never executed)

  • Index Cond: (merchant_id = merchant.id)
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on merchant_type (cost=0.00..1.13 rows=13 width=17) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using entity_pkey on entity (cost=0.58..3.60 rows=1 width=107) (never executed)

  • Index Cond: (id = merchant.entity_id)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using uri_pkey on uri (cost=0.57..3.59 rows=1 width=53) (never executed)

  • Index Cond: (id = merchant.uri_id)
Planning time : 2.689 ms
Execution time : 0.376 ms