explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qca7

Settings
# exclusive inclusive rows x rows loops node
1. 10,056.464 28,510.545 ↓ 6,227.1 1,245,417 1

HashAggregate (cost=2,968,088.03..2,968,090.03 rows=200 width=8) (actual time=28,184.672..28,510.545 rows=1,245,417 loops=1)

  • Group Key: "DocFolderBoolean".c_documentid
  • Buffers: shared hit=692,806 read=37,613
2. 2,429.762 18,454.081 ↓ 2.4 27,238,077 1

Append (cost=9,300.02..2,939,476.72 rows=11,444,525 width=8) (actual time=58.006..18,454.081 rows=27,238,077 loops=1)

  • Buffers: shared hit=692,806 read=37,613
3. 4,383.312 14,485.882 ↓ 2.3 23,606,261 1

Merge Join (cost=9,300.02..2,683,459.69 rows=10,332,932 width=8) (actual time=58.006..14,485.882 rows=23,606,261 loops=1)

  • Buffers: shared hit=692,661
4. 43.781 298.368 ↓ 1.5 47,075 1

Merge Join (cost=9,263.47..16,405.88 rows=30,693 width=16) (actual time=57.938..298.368 rows=47,075 loops=1)

  • Filter: (("FieldPermissionTbl".c_isdisplay AND ("FieldPermissionTbl".c_roleid = 2)) OR (fielddetails.c_isprivate AND (fieldschema1.c_createdby = 72,128)))
  • Buffers: shared hit=111,783
5. 42.261 185.848 ↓ 1.6 88,814 1

Merge Join (cost=9,263.05..13,815.11 rows=53,987 width=33) (actual time=57.898..185.848 rows=88,814 loops=1)

  • Buffers: shared hit=55,409
6. 66.035 66.035 ↑ 1.0 53,977 1

Index Scan using t_sys_fieldschema_tablegroupsid_fieldschemaid on t_sys_fieldschema fieldschema1 (cost=0.42..3,464.84 rows=53,987 width=24) (actual time=0.024..66.035 rows=53,977 loops=1)

  • Index Cond: (fieldschema1.c_tablegroupsid = 'e4308ac6-c388-11e7-8c54-9b97e6527505'::uuid)
  • Buffers: shared hit=54,269
7. 61.833 77.552 ↑ 1.0 88,052 1

Sort (cost=9,260.51..9,480.84 rows=88,135 width=25) (actual time=57.862..77.552 rows=88,052 loops=1)

  • Sort Key: "FieldPermissionTbl".c_fieldschemaid
  • Sort Method: quicksort Memory: 9,954kB
  • Buffers: shared hit=1,140
8. 15.719 15.719 ↑ 1.0 88,088 1

Seq Scan on t_sys_fieldpermission FieldPermissionTbl (cost=0..2,021.35 rows=88,135 width=25) (actual time=0.01..15.719 rows=88,088 loops=1)

  • Buffers: shared hit=1,140
9. 68.739 68.739 ↓ 1.6 91,354 1

Index Scan using t_e20so1_fielddetails_c_fieldschemaid_idx on t_e20so1_fielddetails fielddetails (cost=0.41..1,819.76 rows=56,537 width=17) (actual time=0.033..68.739 rows=91,354 loops=1)

  • Buffers: shared hit=56,374
10. 9,804.202 9,804.202 ↓ 1.0 32,004,481 1

Index Scan using t_e20so1_document_boolean_folders_c_tablegroupsid on t_e20so1_document_boolean_folders DocFolderBoolean (cost=0.57..2,485,735.12 rows=31,208,333 width=24) (actual time=0.033..9,804.202 rows=32,004,481 loops=1)

  • Index Cond: (("DocFolderBoolean".c_value = true) AND ("DocFolderBoolean".c_tablegroupsid = 'e4308ac6-c388-11e7-8c54-9b97e6527505'::uuid))
  • Filter: "DocFolderBoolean".c_value
  • Buffers: shared hit=580,878
11. 823.617 1,538.437 ↓ 3.3 3,631,816 1

Hash Join (cost=1,052.67..84,349.16 rows=1,111,593 width=8) (actual time=10.613..1,538.437 rows=3,631,816 loops=1)

  • Buffers: shared hit=145 read=37,613
12. 704.355 704.355 ↑ 1.0 3,631,838 1

Seq Scan on t_e20so1_document_boolean_batches DocBatchBoolean (cost=0..73,762.25 rows=3,631,925 width=24) (actual time=0.075..704.355 rows=3,631,838 loops=1)

  • Filter: "DocBatchBoolean".c_value
  • Buffers: shared hit=2 read=37,441
13. 4.576 10.465 ↑ 1.0 28,277 1

Hash (cost=698.6..698.6 rows=28,326 width=16) (actual time=10.465..10.465 rows=28,277 loops=1)

  • Buffers: shared hit=143 read=172
14. 5.889 5.889 ↑ 1.0 28,277 1

Index Only Scan using t_sys_fieldschema_tablegroupsid_fieldschemaid on t_sys_fieldschema fieldschema2 (cost=0.42..698.6 rows=28,326 width=16) (actual time=0.042..5.889 rows=28,277 loops=1)

  • Index Cond: (fieldschema2.c_tablegroupsid = '7de6756f-4315-4198-bc94-2576467cbd79'::uuid)
  • Heap Fetches: 158
  • Buffers: shared hit=143 read=172
Planning time : 2.688 ms
Execution time : 28,582.082 ms