explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4vUb

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 713.299 ↓ 0.0 0 1

Unique (cost=27,555,565.66..28,820,124.65 rows=8,028,946 width=3,546) (actual time=713.299..713.299 rows=0 loops=1)

  • Buffers: shared hit=78036 dirtied=3
2. 0.093 713.298 ↓ 0.0 0 1

Sort (cost=27,555,565.66..27,575,638.02 rows=8,028,946 width=3,546) (actual time=713.298..713.298 rows=0 loops=1)

  • Sort Key: detailtable.c_indexrecordstatusid, batch.c_jobbatchdocumentid, table_9.c_value, table_0_2.c_documentid, table_2.c_edocapplication, table_2.c_edocauthor, table_2.c_edoccategory, table_2.c_edoccomments, table_2.c_edochiddenslides, table_2.c_edockeywords, table_2.c_edoclastauthor, table_2.c_edocmanager, table_2.c_edocmultimediaclips, table_2.c_edocorganization, table_2.c_edocpresentationformat, table_2.c_edocsubject, table_2.c_edoctemplate, table_2.c_edoctitle, table_2.c_edocversion, 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_10.c_value, table_11.c_value, table_6.c_value, table_13.c_value, table_21.c_value, table_14.c_value, table_15.c_value, table_16.c_value, table_17.c_value, table_7.c_value, table_18.c_value, table_19.c_value, table_20.c_value, table_22.c_value, table_12.c_value, table_23.c_value, table_24.c_value, table_3.c_value, table_4.c_value, table_5.c_value, table_8.c_value, table_0_4.c_path
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=78036 dirtied=3
3. 0.000 713.205 ↓ 0.0 0 1

Nested Loop (cost=2,089,170.6..5,080,107.25 rows=8,028,946 width=3,546) (actual time=713.205..713.205 rows=0 loops=1)

  • Buffers: shared hit=78036 dirtied=3
4. 94.750 773.856 ↓ 0.0 0 1

Gather (cost=2,089,170.46..4,913,657.93 rows=51,563 width=3,493) (actual time=713.204..773.856 rows=0 loops=1)

  • Buffers: shared hit=78036 dirtied=3
5. 0.000 679.106 ↓ 0.0 0 2

Nested Loop (cost=2,088,170.46..4,907,501.63 rows=8,594 width=3,493) (actual time=679.106..679.106 rows=0 loops=2)

  • Buffers: shared hit=78036 dirtied=3
6. 0.001 679.106 ↓ 0.0 0 2

Nested Loop (cost=2,088,169.9..4,904,796.61 rows=3,281 width=3,435) (actual time=679.106..679.106 rows=0 loops=2)

  • Buffers: shared hit=78036 dirtied=3
7. 0.001 679.105 ↓ 0.0 0 2

Nested Loop (cost=2,088,169.34..4,902,977.24 rows=1,927 width=3,427) (actual time=679.105..679.105 rows=0 loops=2)

  • Buffers: shared hit=78036 dirtied=3
8. 0.000 679.104 ↓ 0.0 0 2

Nested Loop (cost=2,088,168.78..4,901,015.56 rows=1,927 width=3,369) (actual time=679.104..679.104 rows=0 loops=2)

  • Buffers: shared hit=78036 dirtied=3
9. 0.578 679.104 ↓ 0.0 0 2

Hash Join (cost=2,088,168.22..4,899,053.88 rows=1,927 width=3,311) (actual time=679.103..679.104 rows=0 loops=2)

  • Buffers: shared hit=78036 dirtied=3
10. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=1,906,347.31..4,623,115.17 rows=25,095,060 width=3,295) (never executed)

11. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,787,737.1..4,438,629.94 rows=25,095,060 width=3,237) (never executed)

12. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,833.11..3,788,088.99 rows=9,673,273 width=3,179) (never executed)

13. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,832.55..3,666,933.05 rows=9,673,273 width=3,121) (never executed)

14. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,831.99..3,527,843.51 rows=9,673,273 width=3,063) (never executed)

15. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,831.44..3,406,687.57 rows=9,673,273 width=3,005) (never executed)

16. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,830.88..3,285,531.64 rows=9,673,273 width=2,947) (never executed)

17. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,830.32..3,164,375.7 rows=9,673,273 width=2,889) (never executed)

18. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,829.76..3,043,219.76 rows=9,673,273 width=2,831) (never executed)

19. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,829.21..2,922,063.83 rows=9,673,273 width=2,773) (never executed)

20. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,828.65..2,800,907.89 rows=9,673,273 width=2,715) (never executed)

21. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,828.09..2,679,751.95 rows=9,673,273 width=2,657) (never executed)

22. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,827.53..2,536,284.47 rows=9,673,273 width=2,599) (never executed)

23. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,826.98..2,404,428.4 rows=9,673,273 width=2,541) (never executed)

24. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,419,826.42..2,261,624.97 rows=9,673,273 width=2,483) (never executed)

25. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1,082,733.52..1,810,432.43 rows=4,407,994 width=2,425) (never executed)

26. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=748,454.42..1,420,725.53 rows=2,042,824 width=2,367) (never executed)

27. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=748,453.87..1,299,603.21 rows=2,042,824 width=2,309) (never executed)

28. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=748,453.44..1,244,271.11 rows=2,042,824 width=2,071) (never executed)

29. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=748,453.01..866,698.03 rows=2,042,824 width=76) (never executed)

30. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=748,452.46..753,559.52 rows=2,042,824 width=18) (never executed)

  • Sort Key: table_0_2.c_documentid
31. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=34,464.34..509,804.21 rows=2,042,824 width=18) (never executed)

32. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0..442,244.52 rows=2,042,824 width=8) (never executed)

33. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using t_e20so1_document_datastore_12_c_documentid_idx on t_e20so1_document_datastore_12 table_0_2 (cost=0.43..107,527.26 rows=316,035 width=8) (never executed)

34. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_datastore_11 table_0_1 (cost=0..324,482.79 rows=1,726,779 width=8) (never executed)

35. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_datastore_1 table_0 (cost=0..10.18 rows=18 width=8) (never executed)

36. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_datastore_default table_0_3 (cost=0..10.18 rows=18 width=8) (never executed)

37. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=25,426.17..25,426.17 rows=492,254 width=18) (never executed)

38. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_varchar table_7 (cost=0..25,426.17 rows=492,254 width=18) (never executed)

  • Filter: (table_7.c_fieldid = '3a5f6d8e-7da0-47c5-9200-1f46d4a7a7a6'::uuid)
39. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_5 (cost=0.56..107,463.61 rows=15,016 width=66) (never executed)

  • Index Cond: (table_5.c_fieldid = '1008fc7e-bd39-11e7-a8b9-14b31f1d9301'::uuid)
40. 0.000 0.000 ↓ 0.0 0 0

Index Scan using t_e20so1_document_email_c_documentid_idx on t_e20so1_document_email table_1 (cost=0.43..346,796.75 rows=2,096,414 width=2,003) (never executed)

41. 0.000 0.000 ↓ 0.0 0 0

Index Scan using t_e20so1_document_edoc_c_documentid_idx on t_e20so1_document_edoc table_2 (cost=0.42..28,380.94 rows=566,343 width=246) (never executed)

42. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_6 (cost=0.56..115,031 rows=26,028 width=66) (never executed)

  • Index Cond: (table_6.c_fieldid = '39be35bb-aaf4-47ef-819d-697fef5cf1a6'::uuid)
43. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=334,279.09..337,399.49 rows=1,248,161 width=66) (never executed)

  • Sort Key: table_3.c_documentid
44. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_text table_3 (cost=0..177,908.88 rows=1,248,161 width=66) (never executed)

  • Filter: (table_3.c_fieldid = '033af646-bd39-11e7-a8b1-14b31f1d9301'::uuid)
45. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=337,092.9..340,266.36 rows=1,269,384 width=66) (never executed)

  • Sort Key: table_4.c_documentid
46. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_text table_4 (cost=0..177,908.88 rows=1,269,384 width=66) (never executed)

  • Filter: (table_4.c_fieldid = '095f800a-bd39-11e7-a8b5-14b31f1d9301'::uuid)
47. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_8 (cost=0.56..114,372.43 rows=25,027 width=66) (never executed)

  • Index Cond: (table_8.c_fieldid = '4e273bdf-66e6-4b7c-9052-65866f276f2c'::uuid)
48. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_9 (cost=0.56..105,565.87 rows=12,414 width=66) (never executed)

  • Index Cond: (table_9.c_fieldid = '634b6544-bd38-11e7-a871-14b31f1d9301'::uuid)
49. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_10 (cost=0.56..114,900.53 rows=25,828 width=66) (never executed)

  • Index Cond: (table_10.c_fieldid = '698c2e34-bd38-11e7-a875-14b31f1d9301'::uuid)
50. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_11 (cost=0.56..96,783.33 rows=1,116 width=66) (never executed)

  • Index Cond: (table_11.c_fieldid = '7964c442-bd38-11e7-a879-14b31f1d9301'::uuid)
51. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_12 (cost=0.56..96,783.33 rows=1,116 width=66) (never executed)

  • Index Cond: (table_12.c_fieldid = '80b3419b-23a6-4da9-b278-b1a821338400'::uuid)
52. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_13 (cost=0.56..96,783.33 rows=1,116 width=66) (never executed)

  • Index Cond: (table_13.c_fieldid = '904b91fe-bd38-11e7-a87d-14b31f1d9301'::uuid)
53. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_14 (cost=0.56..96,783.33 rows=1,116 width=66) (never executed)

  • Index Cond: (table_14.c_fieldid = '986a6428-bd38-11e7-a881-14b31f1d9301'::uuid)
54. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_16 (cost=0.56..96,783.33 rows=1,116 width=66) (never executed)

  • Index Cond: (table_16.c_fieldid = 'c0eecb0a-bd38-11e7-a88d-14b31f1d9301'::uuid)
55. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_18 (cost=0.56..96,783.33 rows=1,116 width=66) (never executed)

  • Index Cond: (table_18.c_fieldid = 'd39d0870-bd38-11e7-a895-14b31f1d9301'::uuid)
56. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_19 (cost=0.56..96,783.33 rows=1,116 width=66) (never executed)

  • Index Cond: (table_19.c_fieldid = 'daa4079a-bd38-11e7-a899-14b31f1d9301'::uuid)
57. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_20 (cost=0.56..111,406.2 rows=20,622 width=66) (never executed)

  • Index Cond: (table_20.c_fieldid = 'e08238c6-bd38-11e7-a89d-14b31f1d9301'::uuid)
58. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_21 (cost=0.56..96,783.33 rows=1,116 width=66) (never executed)

  • Index Cond: (table_21.c_fieldid = 'e510b3c8-bd62-4b12-8e84-508d5fb36d16'::uuid)
59. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=367,903.99..371,655.58 rows=1,500,636 width=66) (never executed)

  • Sort Key: table_15.c_documentid
60. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_text table_15 (cost=0..177,908.88 rows=1,500,636 width=66) (never executed)

  • Filter: (table_15.c_fieldid = '9f591fae-bd38-11e7-a885-14b31f1d9301'::uuid)
61. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=117,843.38..117,843.38 rows=61,347 width=66) (never executed)

62. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on t_e20so1_document_text table_17 (cost=0..117,843.38 rows=61,347 width=66) (never executed)

  • Filter: (table_17.c_fieldid = 'c6da2ef6-bd38-11e7-a891-14b31f1d9301'::uuid)
63. 1.005 678.526 ↓ 0.0 0 2

Hash (cost=181,816.16..181,816.16 rows=380 width=24) (actual time=678.526..678.526 rows=0 loops=2)

  • Buffers: shared hit=77989 dirtied=3
64. 4.020 677.521 ↓ 0.0 0 2

Nested Loop (cost=1..181,816.16 rows=380 width=24) (actual time=677.521..677.521 rows=0 loops=2)

  • Buffers: shared hit=77989 dirtied=3
65. 673.493 673.493 ↑ 1.0 500 2

Index Scan using t_t71wx3_jobbatchdocument_indexi_c_servicetype_c_jobbatchid_idx on t_t71wx3_jobbatchdocument_indexing batch (cost=0.56..180,461.28 rows=513 width=16) (actual time=208.406..673.493 rows=500 loops=2)

  • Index Cond: (batch.c_jobbatchid = 276298)
  • Filter: (batch.c_jobid = 204)
  • Buffers: shared hit=71977 dirtied=3
66. 0.008 0.008 ↓ 0.0 0 1,000

Index Scan using t_sys_indexrecordstatus_pkey on t_sys_indexrecordstatus detailtable (cost=0.43..2.64 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=1,000)

  • Index Cond: (detailtable.c_indexrecordstatusid = batch.c_recordid)
  • Filter: ((detailtable.c_recordstatus = ANY ('{0,1}'::bigint[])) AND (detailtable.c_viewid = 'a522d1f1-371f-4436-b90f-2bc016359a04'::uuid))
  • Buffers: shared hit=6012
67. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_22 (cost=0.56..1.02 rows=1 width=66) (never executed)

  • Index Cond: ((table_0_2.c_documentid = table_22.c_documentid) AND (table_22.c_fieldid = 'e7364108-bd38-11e7-a8a1-14b31f1d9301'::uuid))
68. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_23 (cost=0.56..1.02 rows=1 width=66) (never executed)

  • Index Cond: ((table_0_2.c_documentid = table_23.c_documentid) AND (table_23.c_fieldid = 'f4c247e0-bd38-11e7-a8a9-14b31f1d9301'::uuid))
69. 0.000 0.000 ↓ 0.0 0 0

Index Scan using t_e20so1_document_bigint_c_documentid_idx on t_e20so1_document_bigint table_25 (cost=0.56..1.33 rows=2 width=16) (never executed)

  • Index Cond: (table_0_2.c_documentid = table_25.c_documentid)
  • Filter: (table_25.c_fieldid = 'b035afc8-439f-4f2c-a9ae-e054052511fd'::uuid)
70. 0.000 0.000 ↓ 0.0 0 0

Index Scan using "UQ_21948dc9-695f-4eaa-b1b2-29cf7dcbef3d" on t_e20so1_document_text table_24 (cost=0.56..1.36 rows=3 width=66) (never executed)

  • Index Cond: ((table_0_2.c_documentid = table_24.c_documentid) AND (table_24.c_fieldid = 'fbb66338-bd38-11e7-a8ad-14b31f1d9301'::uuid))
71. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.14..3.18 rows=5 width=69) (never executed)

72. 0.000 0.000 ↓ 0.0 0 0

Index Scan using t_e20so1_repository_default_c_repositoryid_idx on t_e20so1_repository_default table_0_4 (cost=0.14..0.27 rows=1 width=524) (never executed)

  • Index Cond: (table_25.c_value = table_0_4.c_repositoryid)
73. 0.000 0.000 ↓ 0.0 0 0

Index Scan using t_e20so1_repository_dynamic_c_repositoryid_idx on t_e20so1_repository_dynamic table_0_5 (cost=0.14..0.27 rows=1 width=524) (never executed)

  • Index Cond: (table_25.c_value = table_0_5.c_repositoryid)
74. 0.000 0.000 ↓ 0.0 0 0

Index Scan using t_e20so1_repository_document_c_repositoryid_idx on t_e20so1_repository_document table_0_6 (cost=0.43..0.88 rows=1 width=68) (never executed)

  • Index Cond: (table_25.c_value = table_0_6.c_repositoryid)
75. 0.000 0.000 ↓ 0.0 0 0

Index Scan using t_e20so1_repository_pages_c_repositoryid_idx on t_e20so1_repository_pages table_0_7 (cost=0.43..0.86 rows=1 width=79) (never executed)

  • Index Cond: (table_25.c_value = table_0_7.c_repositoryid)
76. 0.000 0.000 ↓ 0.0 0 0

Index Scan using t_e20so1_repository_supported_c_repositoryid_idx on t_e20so1_repository_supported table_0_8 (cost=0.43..0.87 rows=1 width=61) (never executed)

  • Index Cond: (table_25.c_value = table_0_8.c_repositoryid)