explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rYM6 : Optimization for: plan #EHl2

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 61,779.171 328,122.262 ↓ 0.0 14,445,816 1

Sort (cost=0..0 rows=0 width=0) (actual time=322,132.442..328,122.262 rows=14,445,816 loops=1)

  • Sort Key: e.subject_id, t.user_company_code
  • Sort Method: external sort Disk: 1807424kB
2. 219,300.988 266,343.091 ↓ 0.0 14,445,816 1

Nested Loop Left Join (cost=0..0 rows=0 width=0) (actual time=2.820..266,343.091 rows=14,445,816 loops=1)

3. 33,917.007 33,917.007 ↓ 0.0 729,172 1

Index Only Scan using idx_r_statement_object_predicate_subject on r_statement e (cost=0..0 rows=0 width=0) (actual time=1.080..33,917.007 rows=729,172 loops=1)

  • Index Cond: ((object_id = 346965) AND (predicate_id = 3))
  • Heap Fetches: 729172
4. 13,125.096 13,125.096 ↓ 0.0 20 729,172

Index Only Scan using t_type_company_pkey on t_type_company t (cost=0..0 rows=0 width=0) (actual time=0.003..0.018 rows=20 loops=729,172)

  • Index Cond: (type_id = (_entity_class_id(e.subject_id, ('6'::bigint)::d_entityid))::bigint)
  • Heap Fetches: 14445652
Planning time : 0.191 ms
Execution time : 332,262.872 ms