explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dVbn

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

Nested Loop (cost=1,002.57..101,669.48 rows=1 width=91) (never executed)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,002.15..101,669.01 rows=1 width=111) (never executed)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,001.72..101,667.53 rows=3 width=30) (never executed)

4. 0.000 0.000 ↓ 0.0

Gather (cost=1,001.29..101,658.64 rows=13 width=22) (never executed)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.29..100,657.34 rows=5 width=22) (never executed)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..100,311.57 rows=380 width=18) (never executed)

7. 0.000 0.000 ↓ 0.0

Index Scan using idx_files_countersigned_on on files parent_f (cost=0.43..60,593.68 rows=46,927 width=12) (never executed)

  • Index Cond: (countersigned_on IS NOT NULL)
8. 0.000 0.000 ↓ 0.0

Index Scan using pk_file_types on file_types parent_ft (cost=0.43..0.85 rows=1 width=14) (never executed)

  • Index Cond: ((cid = parent_f.cid) AND (id = parent_f.file_type_id))
9. 0.000 0.000 ↓ 0.0

Index Scan using idx_file_associations_cid_file_id on file_associations fa (cost=0.43..0.9 rows=1 width=12) (never executed)

  • Index Cond: ((cid = parent_f.cid) AND (file_id = parent_f.id))
  • Filter: (file_signed_on IS NOT NULL)
10. 0.000 0.000 ↓ 0.0

Index Scan using idx_file_signatures_file_association_id on file_signatures fs (cost=0.43..0.67 rows=1 width=16) (never executed)

  • Index Cond: (file_association_id = fa.id)
  • Filter: ((unique_layout_key IS NULL) AND (fa.cid = cid) AND (updated_on < (now() - '6 mons'::interval)))
11. 0.000 0.000 ↓ 0.0

Index Scan using pk_files on files f (cost=0.43..0.5 rows=1 width=81) (never executed)

  • Index Cond: ((cid = fs.cid) AND (id = fs.signature_file_id))
  • Filter: ((details IS NULL) OR ((details ? 'is_legacy_esignature'::text) IS FALSE))
12. 0.000 0.000 ↓ 0.0

Index Scan using pk_file_types on file_types ft (cost=0.43..0.47 rows=1 width=8) (never executed)

  • Index Cond: ((cid = f.cid) AND (id = f.file_type_id))
  • Filter: ((system_code)::text = 'SIGNATURE'::text)