explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HIOL

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

Unique (cost=21,930.59..21,932.12 rows=17 width=5,083) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=21,930.59..21,930.63 rows=17 width=5,083) (actual rows= loops=)

  • Sort Key: indexrecord.c_indexrecordstatusid, jobbatchdocument.c_jobbatchdocumentid, table_1.c_categories, table_0.c_documentid, table_1.c_emailappntconct, table_1.c_emailappntdurtn, table_1.c_emailappntresource, table_1.c_emailattlst, table_1.c_emailbcc, table_1.c_emailcaltimerng, table_1.c_emailcc, table_1.c_emailconversationindex, table_1.c_emailconversationtopic, table_1.c_emailentryid, table_1.c_emailfrom, table_1.c_emailheaderfull, table_1.c_emailitemtype, table_1.c_emailmailboxid, table_1.c_emailmailboxname, table_1.c_emailmailboxpath, table_1.c_emailoptionalattendees, table_1.c_emailpstinsidepath, table_1.c_emailreqattendees, table_1.c_emailsubject, table_1.c_emailto, table_1.c_inreplytoid, table_1.c_internetmessageid, table_1.c_lastmodifiername, table_1.c_msgbodytype, table_1.c_sensitivity, table_1.c_sentrepresentingaddrtype, table_1.c_sentrepresentingemailaddress, table_1.c_sentrepresentingentryid, table_1.c_sentrepresentingname, table_0_6.c_path
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.41..21,930.24 rows=17 width=5,083) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.27..21,909.51 rows=17 width=5,035) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.98..21,902.95 rows=17 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..21,882.34 rows=17 width=24) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using t_t71wx3_jobbatchdocument_indexi_c_servicetype_c_jobbatchid_idx on t_t71wx3_jobbatchdocument_indexing jobbatchdocument (cost=0.43..20,258.83 rows=666 width=16) (actual rows= loops=)

  • Index Cond: (c_jobbatchid = 51225)
8. 0.000 0.000 ↓ 0.0

Index Scan using t_sys_indexrecordstatus_pkey on t_sys_indexrecordstatus indexrecord (cost=0.42..2.44 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (c_indexrecordstatusid = jobbatchdocument.c_recordid)
  • Filter: (c_viewid = 'd8434adf-207c-4022-9d38-a5501f577ddf'::uuid)
9. 0.000 0.000 ↓ 0.0

Append (cost=0.13..1.15 rows=6 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_document_datastore_1_pkey on t_e20so1_document_datastore_1 table_0 (cost=0.13..0.15 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (c_documentid = indexrecord.c_recordid)
11. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_document_datastore_11_pkey on t_e20so1_document_datastore_11 table_0_1 (cost=0.29..0.36 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (c_documentid = indexrecord.c_recordid)
12. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_document_datastore_12_pkey on t_e20so1_document_datastore_12 table_0_2 (cost=0.13..0.15 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (c_documentid = indexrecord.c_recordid)
13. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_document_datastore_13_pkey on t_e20so1_document_datastore_13 table_0_3 (cost=0.13..0.15 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (c_documentid = indexrecord.c_recordid)
14. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_document_datastore_14_pkey on t_e20so1_document_datastore_14 table_0_4 (cost=0.14..0.16 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (c_documentid = indexrecord.c_recordid)
15. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_document_datastore_default_pkey on t_e20so1_document_datastore_default table_0_5 (cost=0.14..0.16 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (c_documentid = indexrecord.c_recordid)
16. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_document_email_c_documentid_idx on t_e20so1_document_email table_1 (cost=0.29..0.39 rows=1 width=5,011) (actual rows= loops=)

  • Index Cond: (table_0.c_documentid = c_documentid)
17. 0.000 0.000 ↓ 0.0

Append (cost=0.14..1.17 rows=5 width=64) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_repository_default_pkey on t_e20so1_repository_default table_0_6 (cost=0.14..0.16 rows=1 width=84) (actual rows= loops=)

  • Index Cond: (table_0.c_repositoryid = c_repositoryid)
19. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_repository_dynamic_pkey on t_e20so1_repository_dynamic table_0_7 (cost=0.14..0.16 rows=1 width=524) (actual rows= loops=)

  • Index Cond: (table_0.c_repositoryid = c_repositoryid)
20. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_repository_document_c_repositoryid_idx on t_e20so1_repository_document table_0_8 (cost=0.29..0.33 rows=1 width=60) (actual rows= loops=)

  • Index Cond: (table_0.c_repositoryid = c_repositoryid)
21. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_repository_pages_pkey on t_e20so1_repository_pages table_0_9 (cost=0.14..0.16 rows=1 width=524) (actual rows= loops=)

  • Index Cond: (table_0.c_repositoryid = c_repositoryid)
22. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_repository_supported_c_repositoryid_idx on t_e20so1_repository_supported table_0_10 (cost=0.29..0.33 rows=1 width=60) (actual rows= loops=)