explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xp8Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 13.755 ↓ 9.0 9 1

Nested Loop (cost=407.08..599.09 rows=1 width=8) (actual time=13.549..13.755 rows=9 loops=1)

  • Buffers: shared hit=475
2. 0.419 13.582 ↓ 1.2 26 1

Merge Join (cost=406.79..411.88 rows=21 width=8) (actual time=13.506..13.582 rows=26 loops=1)

  • Buffers: shared hit=331
3. 0.011 0.048 ↑ 1.0 77 1

Merge Append (cost=0.15..4.47 rows=77 width=8) (actual time=0.025..0.048 rows=77 loops=1)

  • Buffers: shared hit=2
4. 0.037 0.037 ↑ 1.0 77 1

Index Only Scan using t_e20so1_document_datastore_15_pkey on t_e20so1_document_datastore_15 document (cost=0.14..3.69 rows=77 width=8) (actual time=0.023..0.037 rows=77 loops=1)

  • Index Cond: (document.c_datastoresid = 15)
  • Buffers: shared hit=2
5. 1.176 13.115 ↓ 269.8 5,665 1

Group (cost=406.64..406.74 rows=21 width=8) (actual time=11.495..13.115 rows=5,665 loops=1)

  • Buffers: shared hit=329
6. 2.821 11.939 ↓ 346.5 7,277 1

Sort (cost=406.64..406.69 rows=21 width=8) (actual time=11.493..11.939 rows=7,277 loops=1)

  • Sort Key: "DocFolderBoolean".c_documentid
  • Sort Method: quicksort Memory: 534kB
  • Buffers: shared hit=329
7. 1.273 9.118 ↓ 346.5 7,277 1

Append (cost=198.57..406.18 rows=21 width=8) (actual time=2.269..9.118 rows=7,277 loops=1)

  • Buffers: shared hit=329
8. 1.773 7.838 ↓ 363.9 7,277 1

Nested Loop (cost=198.57..382.3 rows=20 width=8) (actual time=2.268..7.838 rows=7,277 loops=1)

  • Buffers: shared hit=329
9. 0.200 2.527 ↓ 2.2 29 1

Hash Join (cost=198.28..212.86 rows=13 width=16) (actual time=2.248..2.527 rows=29 loops=1)

  • Filter: (("FieldPermissionTbl".c_isdisplay AND ("FieldPermissionTbl".c_roleid = 2)) OR (fielddetails.c_isprivate AND (fieldschema1.c_createdby = 168)))
  • Buffers: shared hit=112
10. 0.102 0.102 ↓ 1.0 553 1

Seq Scan on t_e20so1_fielddetails fielddetails (cost=0..12.48 rows=548 width=17) (actual time=0.007..0.102 rows=553 loops=1)

  • Buffers: shared hit=7
11. 0.028 2.225 ↓ 2.1 63 1

Hash (cost=197.91..197.91 rows=30 width=33) (actual time=2.225..2.225 rows=63 loops=1)

  • Buffers: shared hit=105
12. 0.990 2.197 ↓ 2.1 63 1

Hash Join (cost=122.67..197.91 rows=30 width=33) (actual time=0.942..2.197 rows=63 loops=1)

  • Buffers: shared hit=105
13. 0.643 0.643 ↑ 1.0 3,011 1

Seq Scan on t_sys_fieldpermission FieldPermissionTbl (cost=0..67.07 rows=3,107 width=25) (actual time=0.013..0.643 rows=3,011 loops=1)

  • Buffers: shared hit=36
14. 0.020 0.564 ↑ 1.0 30 1

Hash (cost=122.3..122.3 rows=30 width=24) (actual time=0.564..0.564 rows=30 loops=1)

  • Buffers: shared hit=69
15. 0.544 0.544 ↑ 1.0 30 1

Index Scan using "IX_fieldschema" on t_sys_fieldschema fieldschema1 (cost=0.28..122.3 rows=30 width=24) (actual time=0.217..0.544 rows=30 loops=1)

  • Index Cond: (fieldschema1.c_tablegroupsid = 'e4308ac6-c388-11e7-8c54-9b97e6527505'::uuid)
  • Buffers: shared hit=69
16. 3.538 3.538 ↑ 1.2 251 29

Index Scan using t_e20so1_document_bool_folder_fieldid_idx on t_e20so1_document_boolean_folders DocFolderBoolean (cost=0.28..9.96 rows=307 width=24) (actual time=0.007..0.122 rows=251 loops=29)

  • Index Cond: ("DocFolderBoolean".c_fieldid = fieldschema1.c_fieldschemaid)
  • Filter: "DocFolderBoolean".c_value
  • Buffers: shared hit=217
17. 0.001 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.43..23.56 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

18. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=0.28..21.56 rows=1 width=32) (actual time=0.006..0.006 rows=0 loops=1)

19. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on t_e20so1_batchstatus BatchStatus (cost=0..16 rows=2 width=16) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ("BatchStatus".c_acceptedby = 168)
20. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_t_fieldschema on t_sys_fieldschema fieldschema2 (cost=0.28..2.5 rows=1 width=16) (never executed)

  • Index Cond: (fieldschema2.c_fieldschemaid = "BatchStatus".c_batchlabelid)
  • Filter: (fieldschema2.c_tablegroupsid = '7de6756f-4315-4198-bc94-2576467cbd79'::uuid)
21. 0.000 0.000 ↓ 0.0 0 0

Index Scan using t_e20so1_document_bool_batches_fieldid_idx on t_e20so1_document_boolean_batches DocBatchBoolean (cost=0.15..1.97 rows=3 width=24) (never executed)

  • Index Cond: ("DocBatchBoolean".c_fieldid = fieldschema2.c_fieldschemaid)
  • Filter: "DocBatchBoolean".c_value
22. 0.156 0.156 ↑ 1.0 1 26

Index Scan using t_sys_indexrecordstatus_c_recordid_idx on t_sys_indexrecordstatus recordstatus (cost=0.29..8.9 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=26)

  • Index Cond: (document.c_documentid = recordstatus.c_recordid)
  • Filter: (recordstatus.c_viewid = '075248ba-0381-444b-b03b-357857c3560e'::uuid)
  • Buffers: shared hit=144
Planning time : 4.116 ms
Execution time : 14.375 ms